+2How do I find the last Date an item was physically counted in the system?
For example:
Item A was counted last on March 10th
Item B was counted on February 14th
Is there an inquiry like this? If not, does anyone know what data table would hold this information so I can make an inquiry?
Thanks Everyone!
Best answer by Michaelh
Well, I’ll post here for posterity…
INPIDetail and INPIHeader have the data we need.
I joined InventoryItem to INPIDetail by Inventory ID
Then I joined INPIDetail to INPIHeader by PIID and SiteID (might not need Site ID)
This will show you every count by the LOCATION. If you just want to know what the last time the item was counted regardless of location, just group by ItemID and use =max(CountDate) from the INPIHeader table.
This really SHOULD be a stock inquiry somewhere, but I can’t find it, so I built my own inquiry. Cheers my friends!
+2Well, I’ll post here for posterity…
INPIDetail and INPIHeader have the data we need.
I joined InventoryItem to INPIDetail by Inventory ID
Then I joined INPIDetail to INPIHeader by PIID and SiteID (might not need Site ID)
This will show you every count by the LOCATION. If you just want to know what the last time the item was counted regardless of location, just group by ItemID and use =max(CountDate) from the INPIHeader table.
This really SHOULD be a stock inquiry somewhere, but I can’t find it, so I built my own inquiry. Cheers my friends!
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
