Skip to main content
Question

GI needed to display days in-stock

  • May 30, 2023 5:14 PM UTC
  • 5 replies
  • 194 views
  • Translate All
michaelho
Semi-Pro III
Forum|alt.badge.img+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.

2024 Acumatica MVP

    5 replies

    Kandy Beatty
    Captain II
    Forum|alt.badge.img+18

    HI @mikeho 

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

    Translate
    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*.
      michaelho
      Semi-Pro III
      Forum|alt.badge.img+1
      • michaelho
      • Author
      • Semi-Pro III
      • May 30, 2023 9:34 PM UTC

      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.

      Translate
      2024 Acumatica MVP
      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • Jun 21, 2023 10:40 PM UTC

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

      Translate
      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*.
      michaelho
      Semi-Pro III
      Forum|alt.badge.img+1
      • michaelho
      • Author
      • Semi-Pro III
      • Jun 22, 2023 3:15 AM UTC

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

      Translate
      2024 Acumatica MVP
        Freshman I
        • hagermanl
        • Freshman I
        • Nov 17, 2023 9:00 PM UTC

        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?

        Translate
        Terms & ConditionsAccessibility statement
        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