Exporting sales invoices from Tricorn into Sage

Applies to: Tricorn (on-premises and cloud) – Sage 50 sales invoice export
Module: Invoices / Accounts

Overview

Tricorn can export your issued sales invoices to a CSV file that you then import into Sage. This article covers the standard export process and the two most common reasons the export fails.

Before you start

• Make sure every invoice you intend to export has a tax code set. Invoices with a missing tax code will stop the export (see Troubleshooting below).
• Decide the date range you want to export.

Exporting the invoices

1. Go to Tools → Export to Financial System.
2. Click Sales Invoices.
3. Enter the Start Date and End Date for the period you want to export.
4. Click Export.
5. Choose where to save the file (for example, your Desktop) and click Save.
6. When the list of invoices appears, click Select All, then OK.

Tricorn will generate the CSV file in the location you chose, ready to import into Sage.

Note: re-exporting an invoice does not change the export status of the others. Any invoices you have not yet exported remain flagged as un-exported until you export them.

Troubleshooting

Error: "Access violation … in module 'TricornAccountsOutput.exe' (Read of address 00000000)"

This usually means one or more of the invoices in your selected range has no tax code.

Fix: identify the invoices without a tax code, add the correct tax code to each, then run the export again.

The export will not run, or the export program is missing

Anti-virus software can sometimes mistake the Tricorn accounts export program (TricornAccountsExport.exe / TricornAccountsOutput.exe) for a threat and quarantine or delete it.

Fix:

1. Re-run the Tricorn installer, which re-copies the export program back onto the machine.
2. Ask your IT team to whitelist the program in your anti-virus so it is not removed again.

Still stuck?

If the export still fails after the steps above, contact Fitfactory Support with the exact error message and the invoice numbers involved so we can investigate.