What is the export format for sales to Multivers?

  • Published on Jun 10, 2024
  • 1 minute(s) read
  • MV
 Prev Next

<span class="fr-marker" data-id="0" data-type="true" style="display: none; line-height: 0;"></span><span class="fr-marker" data-id="0" data-type="false" style="display: none; line-height: 0;"></span<span class="fr-marker" data-id="0" data-type="true" style="display: none; line-height: 0;"></span><span class="fr-marker" data-id="0" data-type="false" style="display: none; line-height: 0;"></span>This document describes the export format of sales information to Multivers. See also QA 253 for a general explanation of setting up a connection with a financial administration.

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.