Voucher import
This procedure is used to import vouchers in to the accounting from text files.
It is only possible to import new vouchers. It is not possible to update existing vouchers. Balances become updated for the accounts included in the import.
Prior to the import you can use the button Change accounting year on the toolbar of the procedure, to choose to which accounting year the import should be made. It is not possible to select a future accounting year.
Import file
In the Import file box you enter the path to the file from which you will import data. To start the import click the button Import in the toolbar. All data will be loaded to the list in the Loaded records box. You can manually add and delete rows. You can also filter to decide which rows to see. To complete the import you must check the box Include for the rows you wish to save and then click Save
. When you save, the included rows will be removed from the list.
Format templates
You can configure the format of the file at the time of the import. You can create a temporary format or a format template which can be used again. The function Format templates is found in the backstage of the procedure. There you can select for which columns data should be loaded/imported. For the content of the file you can also configure which limiters should be used as column limiter and decimal limiter. Furthermore you can enter a specific number of initial rows which should be skipped during the import.
Read more about format templates.
Specific for the voucher import you can choose which date format should be used for voucher date.