Is it ok to dataport sales records?

geja · 2008-02-28

We are using Navision 3.10A and we want to transfer our existing sales orders to a newly created database. Is it ok to simply use dataport with all field validation off to do this? I will be transferring all fields with their contents anyway so I figure there's no need to validate the contents. There are quite a lot of sales records to transfer and it could save our sales people a good number of days of inputting them over again.

Thanks.

ara3n · 2008-02-28

One of the problems will be partially shipped or invoiced orders.

I would suggest to write a proper dataport and validate the fields.

geja · 2008-02-28

ara3n wrote:

One of the problems will be partially shipped or invoiced orders.

I would suggest to write a proper dataport and validate the fields.

No partial shipments at all. Will it be ok then?

ara3n · 2008-02-28

if he following is true
same posting groups,
No foreigncurrency.
invoice discounting.
No warehouse management.
no serialized /lot tracked items,
no reservation
no dropshipment
same item pricing
same dimensions setup, and you need to load dimensions

It could work.

Try to do it in test. Ship and invoice all of them in test and if you don't get any errors, you should be fine.

DenSter · 2008-02-28

I would definately validate field values, in the same order as if the order would be entered manually, and then compare the records to each other. You really need to make sure that the business logic runs properly in the target database.

Before you move the orders over, make sure that ALL quantities shipped and quantities invoiced are 0. Partially posted orders are not easy to move over.

Is it ok to dataport sales records?

Comments

Categories