Using External Code for Sorting in Report Grouping

Post Reply
jhummer
Posts: 1166
Joined: Wed Mar 17, 2010 2:49 pm

Using External Code for Sorting in Report Grouping

Post by jhummer » Mon Feb 04, 2019 2:52 pm

Here is the process to sort Accountcode in SAP Business One. First go to the Chart of Account in SAP Business One and find the External Code. Code the Accountcode in the order that you want so 100, 200 etc. To the Report Designer and drag and drop the Account Code, Account Name and measure. You can drag and drop the External Code or just use in in the Grouping. Go to the Grouping and change the Sort Order to the External Code first and then sort it.
Attachments
SBO GL Enternal.jpg
SBO GL Enternal.jpg (178.08 KiB) Viewed 102 times
SBO GL Enternal 2.jpg
SBO GL Enternal 2.jpg (73.3 KiB) Viewed 102 times
SBO GL Enternal 3.jpg
SBO GL Enternal 3.jpg (102.17 KiB) Viewed 102 times
SBO GL Enternal 4.jpg
SBO GL Enternal 4.jpg (61.95 KiB) Viewed 102 times

Post Reply