What is the format of sales to Exact Online?
- 10 Jun 2024
- 1 Minute to read
- Contributors
- Print
- DarkLight
- PDF
What is the format of sales to Exact Online?
- Updated on 10 Jun 2024
- 1 Minute to read
- Contributors
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Exact has separate formats for importing cash and invoice sales lines. In both situations, RetailVista creates a comma-separated ASCII file that can be automatically imported into Exact.
The first line of each export file contains a title line. This can be used to simplify the mapping of columns to Exact. In the numeric fields, a period is used as the decimal separator if applicable. Date fields have the format yyyy-mm-dd.
Cash journal
The following columns exist in the cash journal:
Line number | N | Line number, starts at 0 and increments. Resets to 0 at the next header line |
Journal entry | C | Unique journal entry number |
Journal | C | Code of journal, can be specified in RetailVista settings |
Year | N | Year of export, indicated during the creation of an export file |
Period | N | Period of export, indicated during the creation of an export file |
Date | C | Date of the mutation |
Amount | N | General ledger mutation amount |
VAT code | C | Code of VAT rate, can be specified in VAT settings of RetailVista |
VAT amount | N | VAT amount of booking |
Relation | C | <Experimental application, please contact support desk if necessary> |
General ledger | N | General ledger number |
Description | C | Description of the booking |
Product | C | <Experimental, please contact support desk> |
Invoice journal
The invoice journal file for Exact Online contains a different section for each invoice. In fact, there is always an invoice 'header' line, followed by the detail lines of that invoice.
The following columns exist in the invoice journal:
Line number | N | Line number, starts at 0 and increments. Resets to 0 for each new invoice |
Journal | C | Journal code, can be specified in RetailVista settings |
Year | N | Export year, indicated during the creation of an export file |
Period | N | Export period, indicated during the creation of an export file |
Invoice number | C | Unique invoice number |
Description | C | Description of the invoice |
Customer | C | Debtor number, must match the debtor numbers in the financial administration |
Invoice date | C | Creation date of the invoice |
Due date | C | Date by which the invoice must be paid |
Amount | N | Total amount of the invoice including VAT |
Payment term | Number of days within which the invoice must be paid | |
Payment condition | Code from payment condition table | |
For each invoice created in the same file, the following columns are generated:
Line number | N | Line number, starts at 1 for a new invoice and increments |
General ledger | N | General ledger number |
Amount | N | General ledger mutation amount |
VAT code | C | Code of VAT rate, can be specified in VAT settings of RetailVista |
VAT amount | N | VAT amount of booking |
No rights can be derived from the definitions in this QA. Definitions may change in the future.
Was this article helpful?