Sending Visma.net Expense claims to re-invoicing

To start the process

1. Select one or more lines in Inngående regnskapsdokument table and then manually trigger Behandle dokument in Behandling menu.
   • If the Behandle innkommende bokføringsdokumenter automatisk setting is enabled then the processing is automatically triggered when document is received from the origin.
2. If Opprinnelse for the document is 2 - Expense, then the following flow applies.
3. If all the conditions are met (see the Conditions section below), a sales order is created. If multiple documents were simultaneously selected for processing, a sales order is created for each document.
4. If Opprett separate ordrer fra Visma.net Expense is enabled, then new separate orders will be created for each customer from the initial sales order from Visma.net Expense.

An incoming accounting document coming from Visma.net Expense can be successfully processed when the following conditions are met:

• The document has not been processed before. (i.e. neither Sent to re-invoicing nor Sendt til bokføring is checked in Status column)
• The document contains transactions to be re-invoiced when the message includes a customer number. Tag <businessId>.
• The ISO-kode column in Valuta table should contain the same currency code as the incoming accouting document
• The Produktnr hos lev. column in Leveringsalternativ table should contain Visma.net Expense type categories only once.

• Feil i behandling if
  • the currency code in the document does not exist in the ISO-kode column in Valuta table
  • one or more Visma.net Expense type categories or codes are missing from the Produktnr hos lev. column in Leveringsalternativ table
  • one or more Visma.net Expense type categories or codes are defined multiple times in the Produktnr hos lev. column in Leveringsalternativ table
• Ingenting å behandle if the document does not contain any transactions to be re-invoiced or booked to accounting.

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.

• Flow
  • Verify in the Produkt table for the corresponding product whether the Trekk ikke mva. fra Expense-priser på ordrer flag in Beh.måte 4 | Prices is enabled
    • if enabled no VAT deduction will apply to the product and instead its gross price from the incoming document will be used as net price in Visma Business
    • if not enabled continue the flow in order to find the corresponding Merverdiavgift
  • Fetch from the Produkt table the corresponding Avg. og bokf.gr. value for each mapped product (see Leveringsalternativ table)
    • if Avg. og bokf.gr. is empty then use the Std. avg. og bokf.gr. value from Bedriftsopplysninger table
  • Next, fetch from the Avgifts- og bokføringsopplysninger table the Avg.k. salg value which corresponds to the previously fetched Avg. og bokf.gr. or Std. avg. og bokf.gr. value
  • Next, fetch from the Avgiftskode table the Mva nr value which corresponds to the previously fetched Avg.k. salg value
  • Finally, fetch from the Merverdiavgift table the Sats value which corresponds to the previously fetched Mva nr value
    • if Sats is empty then no VAT deduction will apply to the product and instead its gross price from the incoming document will be used
    • if Fom. dato and Ny sats are both filled out and Fom. dato is also older than current date, then the Ny sats value will be applied instead
• Feil i behandling if
  • the product has no corresponding value in Avg. og bokf.gr. in Produkt table and also the Std. avg. og bokf.gr. field from Bedriftsopplysninger table is empty
  • the Avg.k. salg field from the Avgifts- og bokføringsopplysninger table is empty