Visma Global

Export configuration

Configuration of export is to be done following the standard configuration.

Visma Global requires 1 additional field to be configured:

  • Voucher type number

Set the correct voucher type number found in Visma Global, by default this is set to 9.

File

The file produced is a CSV file using "," (comma) as a separator.

Column

Section

Field

Description

A

TransType

B

BatchLine

EntryDate

C

BatchLine

VoucherNo

D

BatchLine

VoucherDate

E

BatchLine

VoucherTypeNo

Value defined in configuration

F

BatchLine

VoucherText

G

BatchLine

DepNo

H

BatchLine

ProjectNo

I

BatchLine

DebitAccountNo

J

BatchLine

CreditAccountNo

K

BatchLine

VATCode

L

BatchLine

CurrencyNo

M

BatchLine

ExchangeRate

N

BatchLine

ExchangeAmount

O

BatchLine

Amount

P

BatchLine

ContraEntryNo

Q

BatchLine

DueDate

R

BatchLine

ContraEntryChainNo

S

BatchLine

Quantity

T

BatchLine

KID

U

BatchLine

TaxClassNo

V

BatchLine

SLAccount

W

BatchLine

SuppliersInvoiceNo

X

BatchLine

RemittanceProfileNo

Y

BatchLine

ProductNo

Z

BatchLine

EmployeeNo

AA

BatchLine

ExtraCostUnitINo

AB

BatchLine

ExtraCostUnitIINo

AC

BatchLine

ExtraCostUnitIIINo

AD

BatchLine

ExtraCostUnitIVNo

*

BatchLine

AssetNo

*New field

*

BatchLine

NetAmountSelfEmployed

*New field

*

BatchLine

SAFTStdVatCode

*New field

*

BatchLine

SAFTStdVatCodeCredit

*New field

AE

Customer

CustomerNo

AF

Customer

ChainNo

AG

Customer

Name

AH

Customer

Address1

AI

Customer

Address2

AJ

Customer

PostCode

AK

Customer

PostOffice

AL

Contact

Name

AM

Customer

Telephone

AN

Customer

Telefax

AO

Customer

SortName

AP

Customer

PostAccount

AQ

Customer

BankAccount

AR

Customer

CreditLimit

AS

CustomerDeliveryAddress

DeliveryName

AT

CustomerDeliveryAddress

DeliveryAddress1

AU

CustomerDeliveryAddress

DeliveryAddress2

AV

CustomerDeliveryAddress

DeliveryPostCode

AW

CustomerDeliveryAddress

DeliveryPostOffice

AX

Customer

EmployeeNo

AY

Customer

DistrictNo

AZ

Customer

TermsOfPayCustNo

BA

Customer

GLAccountRec

*New field

BB

Customer

CustomerTypeNo

BC

Customer

DiscountGrpCustNo

BD

Customer

CustomerProfileNo

*

Customer

CompanyNo

*New field

*

Customer

VatRegNo

*New field

*

Customer

LocalGovermentNo

*New field

*

Customer

CountryNo

*New field

*

Customer

CurrencyNo

*New field

*

Customer

EmailAddress

*New field

Format

  • Date format: DD.MM.YYYY

  • Decimal separator: . (Period)

As can be seen in the list above there are some new fields, these have not yet been implemented, but will come soon.

Last updated