Thursday, May 23, 2013

Usage of Data migration option in Dynamics NAV 2009

User can use data migration tool for import & export data to tables in Dynamics NAV.
Today i'm going to discuss, how we can use that function to fulfill our day to day business process.

Scenario :- You can give excel template to fill the necessary details to your regular customers instead filling sales order in the NAV system. After that you can import excel file to the NAV system.


Department--> Administration-->Data Migration--> Select table ID 36(Slaes Header)--> Migration--> Migration Fields -->hilight Document Type/Sell-to Customer No./No./Document Date--> OK

Same thing has to do for table ID 37(Sales Line), After that select both lines and , Function --> Export to Excel--> Save the Excel file.
When finish entering data, upload the updated excel files.
Then Migration-->Apply migration data.
When complete all the steeps, your data have been uploaded to NAV system.
This is attractive option to reduce data entering part.