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
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Akber
Thanks and rated as always... Did you get your MVP yet?
Danny

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
hi Danny, not yet but i will not stop my posts and help hi I will send you the reports by eveving not in the office.
"Danny" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.