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.