Visma Business
Visma Business is one of many Visma accounting systems. The same file format is used by Visma eAccounting.
Export configuration
Configuration of export is to be done following the standard configuration.
Visma Business has 8 additional fields to be configured:
Include all new customers and projects
Active to include all new customers and projects as part of the export.
By default, the file, only customers and projects related to the invoices will be included.
Export customers to accounting Customers will be included in the file
Export projects to accounting Project will be included in the file
Field name for projects Define the table used for projects in your Visma Business
Field name for external project number The field used for external project number.
Add extra new line after header Insert extra line between header and data in the file
Allow export of invoice basis from To be invoiced Include data from To be invoiced
Client ID for exporting to accounting system Customer ID in Visma Business, this should be the number for your company in Visma Business.
Set the various fields as needed and save the configuration to be able to use it.
File
The file produced for a Visma Business export is an EDI file containing sections of data.
The {ClientID} and {FieldNameForProjects} found in the table are reference to the fields in Configuration above.
Section | Value |
@FIRM_BEGIN | {ClientID} |
@IMPORT_METHOD | 1 |
@Actor | =custNo,BsNo,Nm,Ad1,Ad2,Ad3,PNo,PArea,Ctry |
@Actor | [Customers listed one row for each] |
@{FieldNameForProjects} | =RNo,Nm,CustNo |
@{FieldNameForProjects} | [Projects listed one row for each] |
@WaBnd | Descr,ValDt,SrcTp |
@WaBnd | "Export fra Moment",{Date},"12" |
@WaVo | VoNo,VoDt,VoTp,Txt,DbAcNo,Am,InvoNo,AgRef,Cust,DueDt,CID,ValDt,Cur,ExRt,CurAm,CrAcNo,CrTrnCl,{FieldNameForProjects},R1,CrTxCd,DbTrnCl,DbTxCd |
@WaVo | [Invoices listed one row for each] |
@FIRM_END | {ClientID} |
Section | Field | Description |
@Actor | custNo | Customer number |
@Actor | BsNo | |
@Actor | Nm | Customer Name |
@Actor | Ad1 | Address line 1 |
@Actor | Ad2 | Address line 2 |
@Actor | Ad3 | Address line 3 |
@Actor | PNo | Postal Number |
@Actor | PArea | Postal City |
@Actor | Ctry | Country |
@{FieldNameForProjects} | RNo | Project number |
@{FieldNameForProjects} | Nm | Project name |
@{FieldNameForProjects} | CustNo | Customer number |
@WaBnd | Descr | Description |
@WaBnd | ValDt | Validation date |
@WaBnd | SrtTp | Source type |
@WaVo | VoNo | Voucher number |
@WaVo | VoDt | Voucher date |
@WaVo | VoTp | Voucher type |
@WaVo | Txt | Text |
@WaVo | DbAcNo | Debit account number |
@WaVo | Am | Amount |
@WaVo | InvoNo | Invoice number |
@WaVo | AgRef | |
@WaVo | Cust | Customer |
@WaVo | DueDt | Due date |
@WaVo | CID | |
@WaVo | ValDt | Validation date |
@WaVo | Cur | Currency |
@WaVo | ExRt | Exchange rate |
@WaVo | CurAm | Currency amount |
@WaVo | CrAcNo | Credit account number |
@WaVo | CrTrnCl | Credit transaction class |
@WaVo | {FieldNameForProjects} | Project name |
@WaVo | R1 | Department |
@WaVo | CrTxCd | Credit tax code |
@WaVo | DbTrnCl | Debit transaction class |
@WaVo | DbTxCd | Debit tax code |
Format
Date format: YYYYMMDD
Decimal separator: . (Period)
Last updated