Solved

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

  • 9 February 2024
  • 5 replies
  • 39 views
M
Rank
Userlevel 1
Badge

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?

 

icon

Best answer by frederickodendaal77 9 February 2024, 17:52

View original

5 replies

F
Rank
Userlevel 3
Badge

@mralyea Can you please attach the generic inquiry?

 

M
Rank
Userlevel 1
Badge

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

F
Rank
Userlevel 3
Badge

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

1 Attachment
M
Rank
Userlevel 1
Badge

@frederickodendaal77 yes that worked, thank you!

F
Rank
Userlevel 3
Badge

@frederickodendaal77 yes that worked, thank you!

Awesome, glad I could help 🙂

Reply


Terms & ConditionsCookie 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