platformaerp.com

Inwentaryzacja

SELECT -- inventorySheetName, i.* FROM [item].[inventorySheetLine] i inner join item.inventorysheet ii on i.inventorySheetID = ii.inventorySheetID inner join wms.location l on ii.warehouseID = l.locationid where i.inventorySheetID ='b9066de4-bce4-e711-9466-d89d6719e0cb'

--http://platforma/MM/inventory/1a06af7e-bbe4-e711-9466-d89d6719e0cb

-- update [item].[inventorySheetLine] set itemserialnumber = '232705092017' where inventorySheetLineid = '87e54004-5b31-43e6-bc86-d86e4219141f' update [item].[inventorySheetLine] set itemserialnumber = 'sn113819062017' where inventorySheetLineid = '5eaf6520-bee5-411a-b7d6-ac27ab1e78ac' update [item].[inventorySheetLine] set itemserialnumber = '27070856' where inventorySheetLineid = '1ad0c538-78d8-4d8f-8102-d251a7269398'

select * from [item].[inventorySheetLine] where inventorySheetLineid = '87e54004-5b31-43e6-bc86-d86e4219141f'

SELECT -- inventorySheetName, * FROM [item].[inventorySheet] where inventorysheetname like '%101%' update [item].[inventorySheet] set includeSerialNumbers = 1 where inventorySheetID ='B9066DE4-BCE4-E711-9466-D89D6719E0CB'

--B9066DE4-BCE4-E711-9466-D89D6719E0CB

select i.itemCode itemCode, i.itemName itemName, --i.itemUnitID , x.itemSerialNumber serialNumber, --max(x.stockBalanceDate) stockDate, l.locationCode warehouseCode, l.locationID, l_l.locationCode locationCode, l_l.locationName locationName, sum(x.quantityIN - x.quantityOUT) stock

 from wms.stockBalanceDate x
 inner join wms.item i on i.itemID = x.itemID
 inner join wms.location l on l.locationID = x.warehouseID
 LEFT  join wms.location l_l on l_l.locationID = x.locationID
 where itemSerialNumber is not null
 and    l.locationCode   = '101'
 group by
        i.itemCode  ,
        i.itemName  ,
        x.itemSerialNumber  ,
        l.locationCode  ,
        l.locationID  ,
        l_l.locationCode ,
        i.itemUnitID,
        l_l.locationName
        having   sum(x.quantityIN -  x.quantityOUT)  > 0