It's that time of year again - just finished doing my physical inventory using a import files via Physical Inventory wizard in SOM. I would like to run an SQL report to see if all my Items have been updated... just to make sure I didn't miss any items since I did the physical inventory counts by department... Is their a field in the items DB that gets updated?
As you mentioned and it seems that you imported the physical inventory to the SO Manager> Inventory > Physical Inventory, now go there and see the Ref. Number
Now go to SO Administrator | File Connect the DB | then go to Query and Click the New, type this
select * from PhysicalInventoryEntry where PhysicalInventoryID In ( select ID from PhysicalInventory where code='0000001' -- Here enter ref no)
This will lst you all the items you fill. now you wanted to check specific, note down your PhysicalInventoryID for another query, type another query:
select * from PhysicalInventoryEntry where PhysicalInventoryID=1 -- ID you got from previous query and QuantityCounted=0
This way you can check which items are not entered the QuantityCounted. one more thing you may be concern about the itemlookupcode so have this:
Select Item.ItemLookupcode,PhysicalInventoryEntry.* from PhysicalInventoryEntry,Item Where PhysicalInventoryEntry.ItemID=Item.ID AND PhysicalInventoryID=1 and QuantityCounted=0
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.