Visma Global
Last updated
Last updated
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.
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.