Skip to main content
Answer

how to implement looping in transactions view ?

  • September 3, 2021
  • 2 replies
  • 289 views

yanuaralfianus37
Jr Varsity II

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.

Best answer by Naveen Boga

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

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • September 3, 2021

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


yanuaralfianus37
Jr Varsity II

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