Skip to main content
Question

Trying to create a GI for when parts were cycle counted

  • July 9, 2026
  • 3 replies
  • 29 views
K
Freshman II
Forum|alt.badge.img

I’m trying to create a table that can tell users when a part was last cycle counted. I’ve attached the table that I have so far. The quantity is correct, however, some parts are not attaching correctly to their serial numbers, thereby resulting in no data being found for them. Any way to get this table to produce the correct results?

    3 replies

    bwhite49
    Captain II
    Forum|alt.badge.img+12
    • bwhite49
    • Captain II
    • July 9, 2026

    Try this instead 

     

     

      K
      Freshman II
      Forum|alt.badge.img
      • kkraus
      • Author
      • Freshman II
      • July 10, 2026

      Thank you for the suggestion ​@bwhite49. Unfortunately, it made the results worse without resolve the issue. All of the older than 360 days parts got folded into the not counted box, and the parts without their correct serial still didn’t have them. The only I’ve been able to get the serial number to appear is to have the INPIDetail as the parent table, but that has the unfortunate result of leaving out all of the parts without serial numbers.

        bwhite49
        Captain II
        Forum|alt.badge.img+12
        • bwhite49
        • Captain II
        • July 10, 2026

        Ah, well that does not sound good. I don’t think I can be of help without understanding your data. 

        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