Sage MAS Intelligence with the Report Designer Add-In can be used to run your financial reports when Natural Account is not a 1st segment. You will need to use ‘CONCATENATE’ function in Excel. Here is an example:
100-2100-000-000 – Natural Account is set on the 2nd Segment.
To concatenate display the Natural Account as ‘???-2100’:
In Excel, click on the ‘fx’ or Function Argument
Select the Category as ‘Text’
Select Function as ‘CONCATENATE’, Click on ‘OK’
Function Argument
Enter Text1 and Text2, and click on ‘OK’
Cheers,
Zenon