Skip to main content
Answer

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

  • February 9, 2024
  • 5 replies
  • 66 views
M
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

    5 replies

    F
    Jr Varsity I
    Forum|alt.badge.img

    @mralyea Can you please attach the generic inquiry?

     

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

    F
    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

    1 Attachments
    Chris Hackett
    M
    Jr Varsity III
    Forum|alt.badge.img
    • mralyea
    • Author
    • Jr Varsity III
    • February 9, 2024

    @frederickodendaal77 yes that worked, thank you!

    Chris Hackett
    F
    Jr Varsity I
    Forum|alt.badge.img

    @frederickodendaal77 yes that worked, thank you!

    Awesome, glad I could help 🙂

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility 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