Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
automate Import 1000 sales credit memo in navision 2009 r2
Naaz_nav
Member Posts: 34
Hi,
One of my client wants to automate the sales credit memo imported in navision. They have this csv file which will be imported.
I searched this forum,& i got two options
1.Data migration tool-I ma not aware as how to run this & how to import this.Will this approach be ok??
2.Creation of dataport-I craeted a buffer table with some fields as sales line & imported the csv file contets in the table & need to validate the fields & then created a sales credit memo header & sales credit line.
As of now i m just trying to create a single credit memo.& it gets created successfully.bUt i have some questions.
Is this approach is right?What columns i will need in the csv file how i would come to know wat lines belong to what header.
also,i searched the forum & they said that we can call callfieldvalidate.But it should be in some order.Can Someone guide me as how do i go abt validation.Lets assume the field is not validated Then the import will stop.How can i catch the error log.This will eat up my two tables.1st buffer table & second for error log.Kindly guide me as how i can automate import of sales credut memo in navision 2009 r2.
Kinldy help
One of my client wants to automate the sales credit memo imported in navision. They have this csv file which will be imported.
I searched this forum,& i got two options
1.Data migration tool-I ma not aware as how to run this & how to import this.Will this approach be ok??
2.Creation of dataport-I craeted a buffer table with some fields as sales line & imported the csv file contets in the table & need to validate the fields & then created a sales credit memo header & sales credit line.
As of now i m just trying to create a single credit memo.& it gets created successfully.bUt i have some questions.
Is this approach is right?What columns i will need in the csv file how i would come to know wat lines belong to what header.
also,i searched the forum & they said that we can call callfieldvalidate.But it should be in some order.Can Someone guide me as how do i go abt validation.Lets assume the field is not validated Then the import will stop.How can i catch the error log.This will eat up my two tables.1st buffer table & second for error log.Kindly guide me as how i can automate import of sales credut memo in navision 2009 r2.
Kinldy help
0