Activate Navision as an option for salary export
Go to System Settings → Staffing → Export → Select department(s) → check off Navision.
Go to Paychecks and tick on one or more paychecks. You see that Navision comes as a choice for export.
If you click on it, a file named navision.txt will be downloaded. This txt file contains different information to be imported into Navision. You can open the file in Notepad (Windows) or Text editor (Mac) to see what information RecMan brings with it in the export.
Payroll file navision.txt
When you retrieve the file to look at it in Notepad, you will get relatively confusing lines with numbers. We will try to explain the file here so that you can get an understanding of what is included in the export and where the various information comes from. We separate the different fields in the example file below with punctuation |.
The line below is from a sample file taken from our demo system. We try to explain the different fields in the table below:
0000000 | 0000000 | 00000127 | 00000000 | 00000000000000000 | 1051 | 001 | 290216 | 0000000750 | 0000000000 000000000 1 2 3 4 5 6 7 8 9 10
| Punctuation | Information | From the example above |
|---|---|---|
| 1 | Not in use | «000…» x7 |
| 2 | Department number | Section 0 |
| 3 | Project number | 127 |
| 4 | Subproject (must be numeric) | 0 (means that it is not linked to a subproject) |
| 5 | Not in use | «0000….» x16 |
| 6 | Employee number | 1051 |
| 7 | Wage type number | 1 |
| 8 | Date (DDMMYY) | Date 29.02.16 |
| 9 | Number | 7.5 hours |
| 10 | Not in use | «0000….» x19 |
Note
The lines are not summed per salary type. This must be done in Navision.