Physical Inventory - help

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

Reply to
Danny
Loading thread data ...

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:

Reply to
Akber Alwani

Akber

Thanks and rated as always... Did you get your MVP yet?

Reply to
Danny

Reply to
Akber Alwani

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.