Transaction Data Migration???

bbcai

How Navision do transaction data migration? Means all the outstanding contracts and all other related documents like invoices, credit memo, return orders can it be imported into Navision database? Is there any ways to know all the mandatory fields that are needed in all other related tables? How to handle all those partial payment/shipments contracts? We are using SQL server and Nav4.0

Iqbal_Febriano

You should post them through the journal line, and then you'll see the result in the related ledger entry table. To post the journal you can use a dataport or XMLPort.

bbcai

How to handle the partial shipment/payment transaction? How to know the item details like in sales header and sales line since we only have G/L account code in journal? How the users can check for the outstanding contract item qty to ship?

bbcai

Nobody is able to answer this question...?

itspeter

We were given 3 options as below: -
1.) Not advisible to migrate data. Normally, just enter Opening Balance, and start as fresh.
2.) Minus partial delivery, and balance export over as new Order.
3.) Run parallel, all new Sales goes to Navision, old one remain at old system.

Anybody have better suggestion? :-s

Arhontis

Hi,

It is best that any migration includes only Opening Balance in the G/L, Customers, Vendors and Inventory. Partial Shipments or payment transactions and other such data that interfere with G/L or Inventory should be created by hand wherever needed.

The whole system is too complicated for someone to implement these states and the time of manual data entry will be much less than writing the code to make the same result.