Setup inside Visma Business

License

Settings

Product mapping for flow Payment in payroll, ERP integration for re-invoice/bookkeeping

Expense types from Visma.net Expense need to be mapped to products in Visma Business when expenses are being re-invoiced. For booking only payment vouchers with flow Payment in AutoPay, ERP integration for bookkeeping, tax report through payroll this mapping is not required.. The mapping is done in the Leveringsalternativ table.

The corresponding mileage types, daily allowance types and expenses must be mapped in Produktnr hos lev. column in Leveringsalternativ table for each product that is used for re-invoicing claims.

It is possible to map Visma.net Expense lines with products in Visma Business only by using the content of the <Type category> tag in the incoming document table (see Standard type categories section above). Because <Type category> is quite generic, the content of <Expense type> tag can also be used for product mapping. The latter provides a more detailed way to categorize products. This is helpful especially when having to differentiate between similar expense types that bear different VAT rates. It is recommended to map products always based on <Expense type>. (see Standard expense types section)

The product prices received from Visma.net Expense are gross prices. Since Visma Business uses net prices on orders by default, gross prices from Visma.net Expense are automatically altered to net prices to avoid double VAT on re-invoicing. In order to achieve this the Merverdiavgift should be applied to each individual Produktnr. This feature can be disabled in Produkt table via Behandlingsmåte flag Trekk ikke mva. fra Expense-priser på ordrer for example for Mileage and Daily allowances.

The Produktnr hos lev. column in Leveringsalternativ table should contain Visma.net Expense expense types only once.

It is recommended to exempt expense products from warehousing.

Expenses can be mapped to more specific categories by expense type that enables mapping for each expense type in Visma Business. Mapping each expense code enables also more sophisticated VAT handling for each expense. If expense codes are to be used, there is a possibility to export a list of expense codes on the expense type configuration page in Visma.net Expense.

If any new codes or types are added in Visma.net Expense there will be unique code that should be copied from the expense type export list to Leveringsalternativ table.