Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 385 SQL Performance
- 33 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
Navision 4.0 synchronization
florynx
Member Posts: 81
Hi. I have the following problem:
I have 2 databases with different locales (country specific). The users operate all the transactions in one database and the 2nd database must be synchronized automatically with the 1st and especially the bookkeeping accounts.
To achieve this must detect and write synchronization code in all the CU, tables, forms and report in the 1st database where posting routines are involved or is there a more elegant way to make an interface between the two databases?
thank you
I have 2 databases with different locales (country specific). The users operate all the transactions in one database and the 2nd database must be synchronized automatically with the 1st and especially the bookkeeping accounts.
To achieve this must detect and write synchronization code in all the CU, tables, forms and report in the 1st database where posting routines are involved or is there a more elegant way to make an interface between the two databases?
thank you
0
Comments
These are used for logging.
To use it, you must enable logging T402:"Change Log Setup"."Change Log Activated" = yes and you need it in the license.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
where can I enable logging?
Administration->Application Setup->General->Change Log Setup
After activating it, you have to click the setup button and select the tables and events being logged.
Best Regards
Ufuk
Pargesoft
Is not possible to use the Intercompany Posting for this?
If it's only the G/L Account table you need to sync, you can write some code in the OnInsert, OnModify, OnDelete trigger to export the data, send it to the other company, and import that data. But if it also concerns Entry tables, Posted Documents etc. you'll have to write a lot of code (and you have to write it 2 times: one for exporting and one for importing).