Importing batches and vouchers.
Example of an import file for the Associates table where the customer number is known
An example is shown below of an import file for the Associates table with a test of the Customer number field. Here, the associate number will not be exported. If the customer is not registered it is imported and is automatically assigned the next free number.
@Actor (=CustNo, Nm, Ad1, Ad2, Pno, Parea, BsNo) 10001 "Dataspesialisten AS" "Torggt. 1" "2601" "LILLEHAMMER" "123456789" 10010 "Kontorservice AS" "Postboks 12 Lia 2" "3001" "DRAMMEN" "234567891"
Example of an import file for the batches and vouchers tables.
This is the minimum that you must include in the import file when importing vouchers without currency or organisational units. This assumes that the tax processing has been added to the account plan/VAT codes and that there are correct account number series for customer, supplier and general ledger accounts. Visma Business calculates the VAT amount on updating, which can lead to rounding differences between the invoicing system and the accounting. Here you can read more about Importing batches/vouchers.
@IMPORT_METHOD(3) @WaBnd(ValDt) 20181002 @WaVo(VoNo,VoDt,VoTp,DbAcNo,DbTxCd,DbTrnCl,DbAcCl,CrAcNo,CrTxCd,CrTrnCl,CrAcCl,AmExVAT,VatAm,Am,InvoNo,DueDt) 1 20181002 11 10001 0 0 1 0 0 0 0 1250.00 0 1250.00 1234 20181101 1 20181002 11 0 0 0 0 3000 3 1 3 1000.00 250.00 1250.00 1234 0