In SAP Business One, I have a Sales Order with multiple rows and I would like to merge these into 1 record? How could I do it?
Example: Sales Order 12345 have the following rows:
Item No. Quantity
Expected output is:
12345, Prod1, 100, Prod2, 200, Prod3, 300