Visma – Export Orders

Order Heading Field descriptions*

Field no	Name	Evatic Field	Format	Visma Field	Comment
1	Customer number	CUSTOMER_NO	Text	KUNDNR
2	Invoice name	ADDRESS.NAME	Text	OOF.NAMN
2	Invoice address 1	ADDRESS.ADDRESS_1	Text	OOF.POSTADR
3	Invoice address 2	ADDRESS.ADDRESS_2	Text	OOF.POSTADR2
4	Invoice Postal code	ADDRESS.POSTAL_CODE	Text	OOF.POSTNR
5	Invoice Post location	ADDRESS.POST_LOCATION	Text	OOF.ORT
3	Invoice date	INVOICE_DATE	Date
4	Delivery date	DELIVERY_DATE	Date
5	Delivery name	DELIVERY_NAME	Text	OOF.LEVNAMN
6	Delivery address 1	DELIVERY_ADDRESS1	Text	OOF.LEVADR
7	Delivery address 2	DELIVERY_ADDRESS2	Text	OOF.LEVADR2
8	Delivery postal code	DELIVERY_POSTALCODE	Text	OOF.LEVPOSTNR
9	Delivery city	DELIVERY_POSTLOCATION	Text	OOF.LEVORT
10	Customer reference	CUSTOMER_REFERENCE	Text	OOF.ERREF
11	Our reference	OUR_REFERENCE	Text	OOF.VAARREF
12	Salesman code	SALESMAN_CODE	Text
12	VAT	-	Bool	OOF.INKLMOMS	Always 0
13	Remark	ORDER_NO	Text	LOKALANM
14	Contract number	CONTRACT_NO	Text	OOF.KONTRAKTNR
15	Electronic reference	CUSTOMER_REFERENCE_INFO	Text
16	Delivered status		Boolean	ADK_OOI_HEAD_ORDER_DELIVERED	If order export and export delivered quantity
17	Stock ship date	DELIVERY_DATE	Date	ADK_OOI_HEAD_STOCK_SHIP_VER_DATE	If order export and export delivered quantity

* Orders can be imported into Visma as orders or invoices, according to integration setting (see explanation in Integration settings below.) Fields will be imported into the same Visma Admin table regardless, with different DOKTYPE.

Order Lines Field descriptions

Field no	Name	Visma Field	Format	Evatic Field	Comment
1	Article number	ADK_OOI_ROW_ARTICLE_NUMBER	Text	ARTICLE_NO	Item number
2	Quantity delivered	ADK_OOI_ROW_QUANTITY1	Double	QTY_DELIVERED	If export delivered quantity
3	Ordered quantity	ADK_OOI_ROW_QUANTITY2	Double	QTY_DELIVERED
4	Sales price	ADK_OOI_ROW_PRICE_EACH_CURRENT_CURRENCY	Double	SALES_PRICE	If invoicable
5	Cost price	ADK_OOI_ROW_PRICE2	Double	COST_PRICE
6	Discount flag	ADK_OOI_ROW_AMOUNT_DISCOUNT_FLAG	Bool	DISCOUNT	Always 0 (percent)
7	Discount	ADK_OOI_ROW_DISCOUNT	Double	DISCOUNT
8	Unit	ADK_OOI_ROW_UNIT	Text	UNIT
9	Type of row	ADK_OOI_ROW_TYPE_OF_ROW	Text	-	Set for text lines only - T for textstrad
10	Description	ADK_OOI_ROW_TEXT	Text	DESCRIPTION
11	Account number	ADK_OOI_ROW_ACCOUNT_NUMBER	Text	ACCOUNT_NO	If export account number

Integration settings

Name	Description
Export order as invoice	Unchecked: orders from Evatic to Visma are exported as order (create order in Visma Admin). Checked: orders from Evatic to Visma are exported as invoice (create invoice in Visma Admin)
Only export invoices	Unchecked: export orders and invoices from Evatic. Checked: export only invoices from Evatic.
Export delivered quantity on order	Unchecked: then only ADK_OOI_ROW_QUANTITY2 (Ordered) will be set. Checked: then both ADK_OOI_ROW_QUANTITY2 and ADK_OOI_ROW_QUANTITY1 (Delivered) will be set. If order export is selected the delivered status on the order heading will also be set to true.
Export delivered quantity on order from contract module	Same as above, but only for orders from the contract module
Export account number on order	Unchecked: Account number from Evatic will not be used and then the account number will be default from the item in Visma. Checked: account number will be exported from Evatic to Visma (ADK_OOI_ROW_ACCOUNT_NUMBER)
Export contract number on order	Unchecked: Contract number from Evatic will not be imported. Checked: contract number will be exported from Evatic to Visma (ADK_OOI_HEAD_CONTRACTNR)