You can import batches and vouchers using the EDI import method DIRDEBR.
The EDI import method DIRDEBR uses the rule file "dirdebr.imp" and the data file "dirdebr.edi". You must create a row in the "EDI messages" table, in which you register "Message type" and the path for the rule file "dirdebr.imp" in the "EDI template" field. This import method performs a lookup on underlying fields. This means that if for example you have specified a voucher type in the data file "dirdebr.edi", the voucher text will automatically be completed when you import.
Fields which may be present in the "dirdebr.imp" rule file:
Batches (WaBnd) can contain the following: | ||
---|---|---|
Field name in the imp file | Field names in Visma Business | Note |
RecType | H | Must have the fixed value H |
ValDt | Value date | Must be completed so that the batch will be updated. |
VoSrNo | Voucher series no. | If you specify the voucher series, the voucher number and voucher type can be automatically allocated based on values in the voucher series. |
Descr | Description | |
Cur2 | Currency no. 2 | Is used if you want to override standard rules. The field can have the currency number that is defined in Visma Business or in the ISO code. |
Vouchers (WaVo) can contain the following: | ||
Field name in the imp file | Field names in Visma Business | Note |
RecType | Must have the fixed value L | If "Voucher series no." is in use, this value will not be used. Merk: This field must
have a value so that the tab can be updated.
|
VoNo | Voucher no. | Can be automatically allocated if the voucher series is used. |
VoDt | Voucher date | This field must be completed so that due dates among other things are calculated correctly. |
ValDt | Value date | Will be used from the batch head if empty. |
VoTp | Voucher type | If "Voucher series no." is in use, "Voucher type" will be retrieved from the voucher series. |
Txt | Text | If "Voucher series no." is in use, "Text" will be retrieved from "Voucher type" for the voucher series. |
Txt2 | Additional text | |
DbAcCl | Debit account type | "1. Customer, "2. Supplier", "3. General ledger, "4. Capital asset" are not needed if the account number series is unique. |
DbAcNo | Debit account | Customer number/Supplier number/General ledger account number/Capital asset number |
DbTxCd | Debit VAT code | Can be retrieved from the general ledger. |
DbTrnCl | Debit turnover cl. | Can be retrieved from the general ledger, VAT code or customer/supplier. |
CrAcCl | Credit account type | "1. Customer, "2. Supplier", "3. General ledger, "4. Capital asset" are not needed if the account number series is unique. |
CrAcNo | Credit account | Customer number/Supplier number/General ledger account number/Capital asset number |
CrTxCd | Credit VAT code | Can be retrieved from the general ledger. |
CrTrnCl | Credit turnover cl. | Can be retrieved from the general ledger, VAT code or customer/supplier. |
AcCl | Account class? | This field can be used instead of DbAcCl or CrAcCl, and if the amount is negative it is a credit transaction. |
AcNo | Account no? | This field can be used instead of DbAcCl or CrAcCl, and if the amount is negative it is a credit transaction. |
TxCd | VAT code? | This field can be used instead of DbTxCd or CrTxCd, and if the amount is negative it is a credit transaction. |
TrnCl | Turnover class? | This field can be used instead of DbTrnCl or CrTrnCl, and if the amount is negative it is a credit transaction. |
Am,20 | Amount | The voucher must have an amount to be updated. |
Cur | Currency no | Is imported from customer/supplier/general ledger/capital asset or default currency is
used. You can either use the Visma Business number or the ISO code for the currency in the import file. |
ExRt | Currency exchange rate? | If the currency number is/or is being retrieved, this field is calculated if you have not entered a value in the import file. |
CurAm | Amount in currency | This field is calculated if the currency number is specified in the file; if not, you can override this with a value in the file. |
AgRef | Cross reference | Is used against voucher lines that will be matched against invoices and that will then
contain invoice numbers (the value in the "Reference" field in the open entry.). Merk: Should
not be used together with InvoNo.
|
InvoNo | Invoice no. | Should only be used in invoices or as a reference that should be used for later
matching. Merk: Should not be used together with AgRef.
|
DepartmentNo | R1 | The value here will be updated in the organisational unit class 1. |
ProjectNo | R2 | The value here will be updated in the organisational unit class 2. Merk: Should not be
used together with CaseNo.
|
CaseNo | R2 | The value here will be updated in the organisational unit class 2. Merk: Cannot be used
together with ProjectNo.
|
PointOfSales | R5 | The value here will be updated in the organisational unit class 5. |
R1 | R1 |
Merk: Cannot be used together with DepartmentNo.
|
R2 | R2 |
Merk: Cannot be used together with CaseNo. or ProjectNo.
|
R3 | R3 | |
R4 | R4 |
Merk: Is reserved for "Reason" if VIC is used from Visma Retail cases.
|
R5 | R5 |
Merk: Cannot be used together with PointOfSales.
|
R6 | R6 | |
R7 | R7 | |
R8 | R8 |
Merk: Is reserved for "shop" if VIC is used from Visma Retail cases.
|
R9 | R9 | |
R10 | R10 | |
R11 | R11 | |
R12 | R12 | |
EmpNo | Emp. no. | |
VoGr1 | Voucher gr. 1 | |
VoGr2 | Voucher gr. 2 | |
ExtRef1 | External reference 1 | |
ExtRef2 | External reference 2 | |
ExtRef3 | External reference 3 | |
Cur2 | Currency no. 2 | You can use this field if you want to override default values for currency no. 2. You can either use the Visma Business number or the ISO code for the currency in the import file. |
ExRt2 | Exchange rate 2 | This field automatically retrieves the correct value from the voucher date, but can be overridden from the file. |
CurAm2 | Amount in currency 2 | This field automatically retrieves the correct value from the voucher date, but can be overridden from the file. |
Ending the import definition (Dummy layout) | ||
DummyLayout | This line must appear at the end of an import definition file. | |
RecType | This line must appear at the end of an import definition file. |