Skip to main content
Solved

Last date an item was Physically Counted


Michaelh
Semi-Pro II
Forum|alt.badge.img+1

How 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!

View original
Did this topic help you find an answer to your question?

2 replies

Michaelh
Semi-Pro II
Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 184 replies
  • Answer
  • April 17, 2023

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!


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2621 replies
  • April 17, 2023

Thank you for sharing your solution with the community @Michael Hansen !


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings