Skip to main content
Question

GI needed to display days in-stock

M
Semi-Pro II
Forum|alt.badge.img

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
Captain II
Forum|alt.badge.img+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*.
T
Chris Hackett
2 people like this
  • T
    tommaricle43
  • Chris Hackett
    Chris Hackett
M
Semi-Pro II
Forum|alt.badge.img
  • mikeho
  • Author
  • Semi-Pro II
  • 228 replies
  • May 30, 2023

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
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2756 replies
  • June 21, 2023

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
Semi-Pro II
Forum|alt.badge.img
  • mikeho
  • Author
  • Semi-Pro II
  • 228 replies
  • June 22, 2023

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

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
H
Freshman I
  • hagermanl
  • Freshman I
  • 1 reply
  • November 17, 2023

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


Most helpful members this week

Terms & ConditionsCookie settings

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