Inwentaryzacja uzupelnienie arkusza zerami
/* Title: Uzupełnienie arkusza zerami
przykladowy adres inwentaryzacji http://platformaxxxx/MM/inventory/94b844d0-bde4-e711-9466-d89d6719e0cb */
Begin tran
update [item].[inventorySheetLine] set stockBalanceCurrent =0 , moddate = getutcdate() FROM [item].[inventorySheet] ii inner join [item].[inventorySheetLine] iisl on ii.inventorySheetID = iisl.inventorySheetID where ii.inventoryid= '94b844d0-bde4-e711-9466-d89d6719e0cb' and iisl.stockBalanceCurrent is null
--Comment transaction to executre rollback tran