Turn on Navision as an option for invoice export
Go to System Settings → Economy → Invoice Export and check Navision as an option for invoice export. Then, Navision will appear as a choice in the invoice overview when you have ticked the relevant invoices.
Before exporting an invoice, however, it is important that you match information inside RecMan with that one in Navision for the connection to be smooth.
Connect products in RecMan to Navision
Here you go to the product overview. This can be found in Economy → Products. Here, you get a complete overview of all the products you have created in RecMan. When creating products, it is required to add the name and product number, and other information is not mandatory. To link the products to Navision, however, you must add information here. From the product overview, the product number and credit account are included in the export to Navision. The product number is unique and does not need to be edited, but the credit account number must be set up to match the account number in Navision.
The image below shows where you enter the credit account (press the Edit button in the product overview). As stated, these must correspond with similar information that is registered in Navision.
After the information here has been added and stored, and this information corresponds to the same contained in Navision, it is mostly ready for invoice export. The last but important step is to make sure that the customer numbers in RecMan match those in Navision.
File export to Navision
When exporting to Navision, it can be good to have an understanding of which fields from RecMan are included in the file export. The first thing to do is generate the Navision files. This is done by selecting the relevant invoices and pressing the Navision button. Then you will get two files you can download from the file type «TXT», a customer file (typically called something with «customer») and a document file (typically called something with «invoice»). We will look at these here:
The customer file
| Line | Information |
| 1 | Customer number |
| 2 | Customer name |
| 3 | Organization number |
| 4 | Not in use |
| 5 | Customer email |
| 6 | Not in use |
| 7 | Postal address line 1 |
| 8 | Postal address line 2 |
| 9 | Post - Postcode |
| 10 | Post - Posted (by) |
| 11 | Post - Country Code ("NO") |
| 12 | Not in use |
| 13 | Invoice - address bar 1 |
| 14 | Invoice - address bar 2 |
| 15 | Invoice - Postcode |
| 16 | Invoice - City |
| 17 | Invoice - country code («NO») |
| 18 | Not in use |
| 19 | Number of days credit |
| 20 | Not in use |
The document file
If you open the file, you will see that there are two lines, a credit line and a debit line, the two lines carry a little different information. The credit lines are summed per product.
As mentioned before, there is a little different information that is included on the credit/debit line, this is marked in blue in the table below. In parentheses, we enter the information from rows 1 and 2 in the example file above (linked to invoice number 658) so that you can easily see which information is included.
| Column | Information - Credit line | Information - Debit line |
| A | Customer number («1607476») | Customer number («1607476») |
| B | Invoice number («658») | Invoice number («658») |
| C | Document number in RecMan («658») | Document number in RecMan («658») |
| D | Order number in RecMan (Not in use) | Order number in RecMan (Not in use) |
| E | ID («F» inans) | ID («D» ebet) |
| F | Invoice date («23.03.2016») | Invoice date («23.03.2016») |
| G | Credit account number ("3010") | Customer number («1607476») |
| H | Product name («Temporary rental») | Customer name («Vatvedt Industri AS») |
| I | Credit amount («-12206,25») | Debit amount ("12206.25") |
| J | Department number (Department «0») | Department number (Department «0») |
| K | Due date | Due date |
| L | Kid number | Kid number |
Navision sample files
Navision is a file export. The file generated in RecMan can be downloaded and reloaded into the accounting system of the same name. Here, both an invoice file and a customer file are generated, both in TXT format.
- Navision V1
- Invoice - Customer file, attachments
- Credit note - Customer file, appendix
- Navision V2
- Invoice - Customer file, attachments
- Credit note - Customer file, appendix
- Navision V3