Skip to content
logo
platformaerp.com

nie można wydać indeksu

SQL
1
2
3
4
5
6
7
8
9
select itemid from wms.item where itemcode= 'S01DE00094097'
--BAECCB0C-619D-ED11-9597-D89D6719E0CA

select * from wms.stockBalance where itemid=
(select itemid from wms.item where itemcode= 'S01DE00094097')

select *  from   wms.stockBalance where quantityDraft <0
delete   from   wms.stockBalance where quantityDraft <0  --bezpieczne
exec wms.stockBalanceFix @itemid= 'BAECCB0C-619D-ED11-9597-D89D6719E0CA'

Dodany job smarrtch który raz dzienni testuje i poprawia ew.