We have done our physical inventory and imported into RMS 2.0. How do we verify this, is there a report that we run? We have looked through operations manager and administrator and have not found anything to point us how to do this.
Verify physical inventory
Jan 04, 2008
2 Replies
I use this query to see if I missed any items from my manual physical inventory count. The following query will output what ILC you have no entries for in your physical inventory count.
select i.itemlookupcode, i.description from item i where i.id not in (select itemid from physicalInventoryEntry)
Maybe someone can put this into a qrp report.
Danny
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required