The “out of the box” functionality supports SAGE50 but we were recently asked if there was support for other SAGE packages.
Some time ago, we added the ability for users to add their own custom exports in whatever format they felt was best for them, however, it’s recently come to our attention that it’s not clear where the “Reference” field can be obtained from.
If you need the “Reference” in your report, simply select “Header Sequence” as one of the columns for your custom export. You then simply need to add the letters “EXP” in front of each sequence number to get the “Reference”.
To do this quickly in excel, you can simply use the formula:
=CONCATENATE(“EXP”,[CELL REF])
Where [CELL REF] should be replaced by the Cell containing the Header Sequence number.