Skip to main content
Solved

How to Add a Related Item To SOLine Programatically

  • October 19, 2024
  • 3 replies
  • 40 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.

 

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

3 replies

Forum|alt.badge.img+8
  • Semi-Pro I
  • 715 replies
  • 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
  • 715 replies
  • 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
  • 1 reply
  • October 21, 2024

@ChandraM Thank you for the response!


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