What is the export format for sales to Multivers?
- 10 Jun 2024
- 1 Minute to read
- Contributors
- Print
- DarkLight
- PDF
What is the export format for sales to Multivers?
- 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
Multivers has separate formats for importing cash and invoice sales rules. In both situations, RetailVista creates a semicolon-separated ASCII file that can be automatically imported into Multivers.
The first line of each export file contains a title line. This can be used to simplify the mapping of columns to Multivers. In numeric fields, a period is used as the decimal separator if applicable. Date fields have the format dd-mm-yyyy.
Cash journal
Fiscal year;Period;Journal code;Transaction;General ledger account;Credit amount (currency);Debit amount (currency);Booking date;Document;Explanation
Fiscal year | N | Fiscal year of export, indicated during the creation of an export file |
Period | N | Period of export, indicated during the creation of an export file |
Product code | Code of the product, can be specified in RetailVista settings | |
Transaction | N | Financial journal number. Each new journal receives a next unique consecutive number |
General ledger account | C | General ledger account of the mutation |
Credit amount | N | Credit booking (empty for debit) |
Debit amount | N | Debit booking (empty for credit) |
Booking date | Date of financial mutation | |
Document | C | Note on financial mutation |
Explanation | C | Description of the journal (transaction) |
Invoice journal
Customer number;Invoice number;Invoice date;Journal code;Period;Payment condition code;Reminder code;Invoice amount (currency);Amount exclusive (currency);Amount VAT (currency);Calculate VAT;VAT scenario;Adjusted VAT;VAT code;General ledger account;VAT type;Record type
Customer number | C | Number must match number in accounting |
Invoice number | N | Unique invoice number |
Invoice date | C | Date of invoice |
Journal code | Code of journal, can be specified in RetailVista settings | |
Period | Export period, indicated during the creation of an export file | |
Payment condition code | C | Code from payment condition table for example 14 days |
Remind code | <Not used> | |
Invoice amount | N | |
Amount exclusive | N | General ledger mutation amount exclusive of VAT |
VAT amount | N | General ledger mutation VAT amount |
Calculate VAT | C | Always contains 'Y' |
VAT scenario | Code of VAT group, can be specified in RetailVista settings | |
VAT adjusted | C | Always contains 'N' |
VAT code | C | Export code from VAT table |
General ledger account | C | General ledger account of mutation |
VAT type | C | Always contains 'D' G - Goods D - Services |
Type of record | C | F - Invoice header G - General ledger mutation B - VAT mutation |
No rights can be derived from the definitions in this QA. Definitions may change in the future.
Was this article helpful?