Skip to main content
Answer

Sales Order GI show inventory items in sales order lines

  • August 16, 2024
  • 1 reply
  • 118 views

Forum|alt.badge.img

I am trying to make a copy of the Sales Orders GI that is in Acumatica but I want the GI to display the Inventory ID of the items in the Sales order, I tried adding the SOLine table to the GI and relating it to the SOOrder table but the Inventory ID result tab just shows up as blank for all sales orders despite having multiple Inventory items and Inventory ID codes in each SO. has anyone else ever done this before and could show me what I need to do to get those ID codes to display in the GI?

Best answer by hkabiri

@BrendanL I suggest to start with a simple GI with only SOOrder and SOLine on Tables and linked them OrderType and OrderNbr on both Tables.

This case when you select SOLine.InventoryID it should show you each and every line of orders with corresponding InventoryID.

For existing GI you copied and modified, you may need to review the Table relations.

1 reply

hkabiri
Acumatica Moderator
Forum|alt.badge.img+8
  • Acumatica Support Team
  • Answer
  • August 16, 2024

@BrendanL I suggest to start with a simple GI with only SOOrder and SOLine on Tables and linked them OrderType and OrderNbr on both Tables.

This case when you select SOLine.InventoryID it should show you each and every line of orders with corresponding InventoryID.

For existing GI you copied and modified, you may need to review the Table relations.