Skip to main content
Solved

How to bring 2 QtyAvail feilds into a GI for kit and kit component items

  • February 9, 2024
  • 5 replies
  • 98 views
  • Translate All
Jr Varsity III
Forum|alt.badge.img

I am trying to bring in 2 different qty avail fields in this GI. I have a finished good (kit) sku on the left, and the related kit components on the right. The qty avail is pulling from the InSiteStatus table, but it is only pulling the kit sku levels in. Based on the pictures below, how would I display the kit components qty avail?

 

Best answer by frederickodendaal77

@mralyea Please try the attached generic inquiry, I think I know what your issue is and it is in the joins

View original

    5 replies

    Jr Varsity I
    Forum|alt.badge.img

    @mralyea Can you please attach the generic inquiry?

     

    Translate
    Jr Varsity III
    Forum|alt.badge.img
    • mralyea
    • Author
    • Jr Varsity III
    • February 9, 2024

    @frederickodendaal77 that is not going to pull in the correct data. I have tried doing that before.

    Translate
    Jr Varsity I
    Forum|alt.badge.img

    @mralyea Please try the attached generic inquiry, I think I know what your issue is and it is in the joins

    Translate
      Jr Varsity III
      Forum|alt.badge.img
      • mralyea
      • Author
      • Jr Varsity III
      • February 9, 2024

      @frederickodendaal77 yes that worked, thank you!

      Translate
        Jr Varsity I
        Forum|alt.badge.img

        @frederickodendaal77 yes that worked, thank you!

        Awesome, glad I could help 🙂

        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