Hi Folks
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?
Any suggestions would be appreciated. Danny
hi Danny,
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
If work rate this.
Akber
"Danny" wrote:
Akber
Thanks and rated as always... Did you get your MVP yet?
Have something to add? Share your thoughts — no account required.
Ask the community — no account required