Question

GI needed to display days in-stock

  • 30 May 2023
  • 5 replies
  • 104 views
M
Rank
Userlevel 5
Badge +1

I’m trying to determine the best way to create a GI that displays the number of days a stock item has been “in-stock”. Does anyone have any suggestions? I thought maybe using the INItemSiteHistDay table would be the way to go but I’m just not sure where to go from there. We’re also using the Average inventory valuation model which does us no favors when it comes to item history. Any suggestions are appreciated.

5 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @mikeho 

Are you looking for when the item was created or when it was received on a PO?

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
M
Rank
Userlevel 5
Badge +1

Hi @kandybeatty49 - this specifically has to do with inventory qty on hand so when it was received on a PO would make the most sense. To provide additional clarification, we would like to be able to show data that answers the following questions: “Out of the past 90/120/180 days, how many days has this product been in-stock”? The reason being, as we continue to deal with supply chain issues our sell-through history doesn’t provide the entire picture and this data can help fill in some of the gaps.

Chris Hackett
Rank
Userlevel 7
Badge

Hi @mikeho were you able to find a solution? Thank you!

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*.
M
Rank
Userlevel 5
Badge +1

Hi @Chris Hackett - I have not, still trying to find a way to do this.

H
Rank

Out of the past 90/120/180 days, how many days has this product been in-stock”?

 

I too am looking for this data. Anyone come up with an idea/find anything?

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