How to export posted sales invoice to a new database

rahul_jnk

Hi all,

Which is the best way to import posted sales invoices from an old NAV database to invoices in new database both are 2013 versions.
I have the requirement that the invoices nos remain the same in both. Please help.

Thanks in advance.
Rahul

archer89

export the posted sales invoices using rapidstart services. then edit the resulting excel doc so, that you can import the data as sales invoices (format from table sales header and sales line). to get the correct format, export one sales invoice from nav to excel. then after importing the data into new db, post the documents.

postsaurav

And why you want to do that?
And what about other related entries (ledgers), Item ledger, Customer Ledger and other entries which are created when you post a sales invoice?

rahul_jnk

Hi Saurav,

Thanks for the reply.

For some reasons we need to abandon an old db, but some invoices from this years needs to be retrieved from old DB to a new DB. Hopefully, if I could get the posted sales invoices from old db to open invoices in the new db then much of the manual entry will be eliminated. Once I get the data as open invoices I can check and post it one by one, right?

Regards,
Rahul

archer89

export the posted sales invoices using rapidstart services. then edit the resulting excel doc so, that you can import the data as sales invoices (format from table sales header and sales line). to get the correct format, export one sales invoice from nav to excel. then after importing the data into new db, post the documents.