Solved

how to implement looping in transactions view ?

  • 3 September 2021
  • 2 replies
  • 19 views

hi, i have a case to check value from Shipment Line to Sales Order Line, my problem is how to looping that proses for every line in transaction view ? Thanks.

icon

Best answer by Naveen B 3 September 2021, 06:25

Hi, if you want to join ShipmentLine to SOLine, please use below fields.

To loop the records in Transaction View..

foreach(SOShipLine objShipLine in Base.Transactions.Select())

{

  //Write SOLine Query by providing below values, to fetch the respective line of SOShipLine 

}

Please let me know if you have any queries

SOShipLine SOLine
OrigOrderType OrderType
OrigOrderNbr OrderNbr
OrigLineNbr LineNbr
InventoryID InventoryID

View original

2 replies

Userlevel 6
Badge +9

Hi, if you want to join ShipmentLine to SOLine, please use below fields.

To loop the records in Transaction View..

foreach(SOShipLine objShipLine in Base.Transactions.Select())

{

  //Write SOLine Query by providing below values, to fetch the respective line of SOShipLine 

}

Please let me know if you have any queries

SOShipLine SOLine
OrigOrderType OrderType
OrigOrderNbr OrderNbr
OrigLineNbr LineNbr
InventoryID InventoryID

Hi @Naveen B thanks for reply, my problem is solved with the code you give to me. Thanks for Helping :).

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved