Solved

Last date an item was Physically Counted

  • 17 April 2023
  • 2 replies
  • 103 views
Michaelh
Rank
Userlevel 5
Badge

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!

icon

Best answer by Michaelh 18 April 2023, 00:08

View original
Permanent Newb, don't let the posts fool you.

2 replies

Michaelh
Rank
Userlevel 5
Badge

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!

Permanent Newb, don't let the posts fool you.
Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved