The connection with Expert M works with both the normal version and Eva Online.
Setting the parameters
It is often the case that the numbering of the documents does not agree with the numbering of the invoices in relation to Expert M. The invoices are, for example, 1, 2, 3, etc. but in Expert M the document numbers are 201400001, 201400002, etc.
We have provided for this conversion in Teamleader. With "Numbering Documents" you can select, for example, "Set length at 9 figures, starting with the year", and the invoice numbers will be converted.
Importing into Expert M
To import the file into Expert M, select Extra –Import external applications – xml–Expert/M on the menu bar.
Next, select the .xml file, and indicate that you want to import customers and sales.
Before importing, you will be asked in what year and accounting period the documents need to be booked. This means you can only export one period at a time!
After importing, an overview of the number of records imported and the reason for any records not having been imported will be displayed.
It is possible that you receive error notifications when importing. This is usually because an incorrect parameter was entered; you need to export the invoices with edited parameters in this event. Naturally, the invoices will not be charged twice. Common error notifications:
- “This is not a valid amount!" This notification is usually the result of selecting the incorrect separator when exporting (decimal separator), which is either a point or a comma.
- “This is not a valid date!" The format is set by default to dd/MM/yyyy (e.g. 31/12/2014), but sometimes this is set differently in Expert M, for example, dd-MM-yyyy (31-12-2014) or yyyy-MM-dd (2014-12-31). You can quickly discover what the correct format is by checking the date notation of one of your sales.
If it is not immediately clear what caused the error notification, it is best if you forward the notification to firstname.lastname@example.org.
You can export the error notification(s) by right-clicking them -> export to Excel. Send the file with which you attempted to import as well so that we can assist you more quickly.