Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 295 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Replicating Data (Nav 5.0 Native)
Steve
Member Posts: 81
Hello Everyone,
I read several posts regarding on replicating data, but most end with "its a large customization" and best practice isn't spoke of.
The issue at hand for a client is as follows:
Nav 5.0 Native DB 1 (location USA) distributor
Nav 5.0 Native DB 2 (location Canada) manufacturer
Both are fully licensed as separate locations / companies.
These two locations are currently exchanging several full documents, partial inventory counts, shipping status and custom table data. Current process is a user generates a text file, attaches to an email and sends to other location where as a different users reverses the process to import and so on. These people also research transmissions errors, lost emails, etc.. The job alone consumes more than 75% of these 2 persons day and is filled with potential user error.
As full header / line documents
1. Sales orders (20%)
2. Purch orders (20%)
3. Custom job orders (60%)
As partial documents / lines
1. Inventory counts
2. Shipping tracking information
3. Several custom tables regarding process and timings.
There goal is a seamless transfer of data between the systems where as no user (manual) steps are required.
I'm looking for ideas on how to accomplish this and really the most effective way to handle this issue.
Currently I have read
1. LS Data Director's
2. Secure FTP - XML files import / export
3. Web services (Nav 2009)
4. ????
Your thoughts? whats better, pro's / con's
Thank you
Steve
I read several posts regarding on replicating data, but most end with "its a large customization" and best practice isn't spoke of.
The issue at hand for a client is as follows:
Nav 5.0 Native DB 1 (location USA) distributor
Nav 5.0 Native DB 2 (location Canada) manufacturer
Both are fully licensed as separate locations / companies.
These two locations are currently exchanging several full documents, partial inventory counts, shipping status and custom table data. Current process is a user generates a text file, attaches to an email and sends to other location where as a different users reverses the process to import and so on. These people also research transmissions errors, lost emails, etc.. The job alone consumes more than 75% of these 2 persons day and is filled with potential user error.
As full header / line documents
1. Sales orders (20%)
2. Purch orders (20%)
3. Custom job orders (60%)
As partial documents / lines
1. Inventory counts
2. Shipping tracking information
3. Several custom tables regarding process and timings.
There goal is a seamless transfer of data between the systems where as no user (manual) steps are required.
I'm looking for ideas on how to accomplish this and really the most effective way to handle this issue.
Currently I have read
1. LS Data Director's
2. Secure FTP - XML files import / export
3. Web services (Nav 2009)
4. ????
Your thoughts? whats better, pro's / con's
Thank you
Steve
Steve
0
Comments
Unlike with the others you have the business logic exposed. Very helpful when validating the data that is coming across.
My Blog - nav.education
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
they are on 5.0 and have to do exe upgrade to use webservices.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Dod you have an examples of this or can you direct me to a good source?
Thanks