By default when you run a supplier statement report in Sage50 the invoice reference that is displayed will be the DragonDMS generated invoice number and not the suppliers reference.
Sage50 has the option to edit the standard reports, in this case the report can be changed to show the suppliers reference – which we put into the Extra Ref field.
To do this in Sage50 follow these steps.
Find the supplier report, right click and select Edit
The report builder will open, select the field highlighted below called INV_REF.
On the left hand side of the screen the INV_REF field will be displayed.
In the list on the left hand side, scroll up and find EXTRA_REF.
Save the report.
The saved report will now show in your list of My Supplier Reports, you may want to mark this report as a favourite to get the report to show in your list of Favourites.
When you run this report the Invoice Ref will now show your suppliers reference and not the DragonDMS generated number.