Transaction Data Migration???

bbcai · 2005-06-06

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 · 2005-06-06

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 · 2005-06-07

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 · 2005-06-10

Nobody is able to answer this question...?

itspeter · 2005-06-10

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 · 2005-06-13

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.

Transaction Data Migration???

Comments

Categories