Read here how to convert from Nav to Uniconta.
NOTE: We recommend using a reseller for this conversion.
If you use Dynamics NAV, we offer a free conversion tool that ensures the transfer of data to Uniconta.
Read here what is automatically included in a conversion
It is recommended to contact a Uniconta reseller, as we cannot standard convert everything from a NAV. Also, loading Export Objects in Nav usually requires reseller knowledge.
The conversion tools for NAV are suitable for version 2009 (6.0) and onwards. If you have an older version of NAV, we recommend upgrading to NAV 2009 first and then converting to Uniconta or alternatively doing a manual conversion where master data + opening numbers can be imported into Uniconta.
Note about debtor and creditor items
Originally, NAV had the following files containing debtor and creditor entries.
"21 - Cust. Ledger Entry", "Debtor Entries"
"25 - Vendor Ledger Entry", "Vendor Entries"
In recent versions, two new files have been added that also contain information about when they are closed.
"379 - Detailed Cust. Ledg. Entry", "Debtor Entries"
"380 - Detailed Vendor Ledg. Entry", "Vendor Ledg. Entry"
If an import does not equalize correctly, try deleting the last two files, 379 and 380, and try importing again.
In the files "380 - Detailed Vendor Ledg. Entry" and "379 - Detailed Cust. Ledg. Entry", "Accounts Receivable Entries", we have corrected "granted cash discount", which originally has a different code than "normal entry" and has therefore not been loaded, to now being loaded.
ATTENTION:
REMEMBER THAT A USER MUST BE CREATED IN UNICONTA FOR A CONVERSION TO BE MADE.
REMEMBER to check if all fiscal years are created in NAV! You can post in NAV without the fiscal year being created, this causes the conversion to fail in Uniconta. This means that if a fiscal year is missing, it is created in NAV before the output!
This can be done by clicking here
If a fiscal year has been deleted in NAV and the first loaded fiscal year is 01-01-2013, NAV creates the primary records on 31-12-2012, i.e. in a fiscal year that does not exist, which means that they were not loaded into Uniconta. An additional fiscal year is now created before the first fiscal year, and the primary records are then loaded correctly.
The object gets ID 99991. Remember to check that there is no existing report with the same ID.
ID can be corrected in the .txt file before import.
From the Object designer, select Report -> File -> Import
The report must be compiled before it can be run. Check for errors with F11 (Compile) in Object Designer and select 'Run'
The Nav RTC client now opens in the user's default account and the report dialog appears.
Export format is default Windows. The format I sent you earlier, specify the location of the files and select 'Ok'
With large amounts of data, you may experience that the export stalls. This can be solved by changing the "Metadata Provider Cache Size" from 30 to 150 in Service Tier.
When the report is complete, the files are in the specified location.
For loading in Uniconta. Read more
More information
Convert from C5
Convert from e-conomic
Convert from eCTRLLoad accounting
After conversion
Export data from Nav
You must first install an export object in NAV There are 3 versions One for all versions of 2009 One from version 13 to 15 One from version 16 to 18 Download Export objects here Nav to Uniconta export tool To install on a 2016, you must have access to the development environment and administrator rights (contact your reseller)
The object gets ID 99991. Remember to check that there is no existing report with the same ID.
ID can be corrected in the .txt file before import.
From the Object designer, select Report -> File -> Import
The report must be compiled before it can be run. Check for errors with F11 (Compile) in Object Designer and select 'Run'
The Nav RTC client now opens in the user's default account and the report dialog appears.
Export format is default Windows. The format I sent you earlier, specify the location of the files and select 'Ok'
With large amounts of data, you may experience that the export stalls. This can be solved by changing the "Metadata Provider Cache Size" from 30 to 150 in Service Tier.
When the report is complete, the files are in the specified location.
For loading in Uniconta. Read more
More information
Convert from C5
Convert from e-conomic
Convert from eCTRLLoad accounting
After conversion