Skip to main content
Answer

How to Add a Related Item To SOLine Programatically

  • October 19, 2024
  • 3 replies
  • 73 views

Hi All,

 

I want to add a related Item to SOLine in a sales order programmatically. I tried to find a relationship between SOLine DAC and RelatedItem DAC. But I was unable to find a clue to proceed with this requirement.

 

Any help would be much appreciated.

 

Thanks

Best answer by ChandraM

Hi @charitha82 Plese find the below details of the Related Items table - INRelatedInventory

  1. InventoryID - It is the main stock item (1 to many relation - One Inventory ID is related to Many). While using BQL Insert, this InventoryID should be the main Item for which you are adding related items. This should be part of your BQL join Condition to retrieve data.
  2. RelatedInventoryID - This is the Related Item you are trying to insert newly. Use BQL INSERT.

 

3 replies

Forum|alt.badge.img+8
  • Semi-Pro I
  • Answer
  • October 20, 2024

Hi @charitha82 Plese find the below details of the Related Items table - INRelatedInventory

  1. InventoryID - It is the main stock item (1 to many relation - One Inventory ID is related to Many). While using BQL Insert, this InventoryID should be the main Item for which you are adding related items. This should be part of your BQL join Condition to retrieve data.
  2. RelatedInventoryID - This is the Related Item you are trying to insert newly. Use BQL INSERT.

 


Forum|alt.badge.img+8
  • Semi-Pro I
  • October 20, 2024

@charitha82 Highlighted the below details for more assistance, please find the details on the DAC, for your review from - 

https://help.acumatica.com/dacBrowser/PX.Objects.IN.RelatedItems/INRelatedInventory 

 


  • Author
  • Freshman I
  • October 21, 2024

@ChandraM Thank you for the response!