Skip to main content
Answer

GI that returns alternate ID for two columns

  • October 4, 2024
  • 4 replies
  • 75 views
M
Freshman I

I am attempting to create a kit BOM GI to send to our warehouse. Our warehouses uses our products alternate ID (in this case ISBN) to identify our products. 

Is there a way to return the alternate ID for the kit header as well as each of the components? 


Thanks,​​​​​

Best answer by dcomerford

@mcanavan Here you go your joins were all wrong. The join is now based on the Descr field on the Cross Reference line equal to 'ISBN'

 

4 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • October 4, 2024

@mcanavan That should be possible you will just join the INItemXRef table twice in the GI once to the Inventroy on the header and once on the components. Give them different aliases so you can tell them a part. the table could have multiple alternate id’s so you will need to consider than in your joins, If you get stuck you can share the GI.

Dermot Comerford
Chris Hackett
A
Captain II
Forum|alt.badge.img+8
  • aiwan
  • Captain II
  • October 4, 2024

Hi @mcanavan 

 

You should use the INKitSpecHdr & INKitSpec(Non)StkDet tables to retrieve the data for the kits.

Where do you store this alternate ID?

 

Hope this helps.

Aleks

Aleks
Chris Hackett
M
Freshman I
  • mcanavan
  • Author
  • Freshman I
  • October 4, 2024

@mcanavan That should be possible you will just join the INItemXRef table twice in the GI once to the Inventroy on the header and once on the components. Give them different aliases so you can tell them a part. the table could have multiple alternate id’s so you will need to consider than in your joins, If you get stuck you can share the GI.

I am getting stuck on the logic for joining the table twice. I get an error when trying to view the GI. Here is the XML for the GI I am working with if you have more suggestions. 


Thanks​​​

1 Attachments
dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • Answer
  • October 4, 2024

@mcanavan Here you go your joins were all wrong. The join is now based on the Descr field on the Cross Reference line equal to 'ISBN'

 

1 Attachments
Dermot Comerford
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