Skip to main content
Solved

How to Add a Related Item To SOLine Programatically

  • Oct 19, 2024 5:31 PM UTC
  • 3 replies
  • 126 views
  • Translate All

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.

 

View original

3 replies

Forum|alt.badge.img+8
  • Semi-Pro I
  • Answer
  • Oct 20, 2024 2:13 AM UTC

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.

 

Translate

Forum|alt.badge.img+8
  • Semi-Pro I
  • Oct 20, 2024 2:18 AM UTC

@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 

 

Translate

  • Author
  • Freshman I
  • Oct 21, 2024 6:40 PM UTC

@ChandraM Thank you for the response!

Translate