Import Customer Opening Balances - NAV 2013.

TPReggie

Hi all,

Have done this before with inventory, and GL, but not with Customers. I would imagine RapidStart is the best way to do this, the customer information will be exported from a Version 5 NAV system. Sadly some customer numbers have been changed in the 2013 system, so cross referencing will need to be done first.

If anyone knows of a step by step for this, or could point me in the right direction as far as what tables/fields are best and easiest to use for both extraction and import I would appreciate it.

It is only the outstanding balance owing that we need.

Thank you very much

neilgf

Hi! If you are migrating data to Nav 2013 just create the data in excel using common general journal headings and once created copy and paste into a Nav 2013 general journal batch which has no number series assigned. So make sure your excel data has Document No., Balancing Acc Type=G/L Account and Bal Acc No. of the control account GL code associated with the customer. Account type is obviously customer followed by account number. Then all potential VAT issues should potentially disappear. This can also hold currency codes and Amount and Amount (LCY).
Getting the data from version 5 is easy enough through creating a form to display open items with all the column headings you need.
Hope this helps.

Neil

TPReggie

Hi Thanks, Neil.
I have managed to do this using Rapid Start to create a General Journal with document type of "Invoice" and then posting it through that way - it has worked fine.

Appreciate your response