Skip to main content
Solved

GI that returns alternate ID for two columns


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'

 

View original
Did this topic help you find an answer to your question?

4 replies

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 583 replies
  • 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.


Forum|alt.badge.img+7
  • Captain II
  • 292 replies
  • 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


  • Author
  • Freshman I
  • 6 replies
  • October 4, 2024
dcomerford wrote:

@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​​​


dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 583 replies
  • 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'

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings