Navision 4.0 synchronization

florynx · 2006-08-07

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

kriki · 2006-08-07

You can use "OnGlobalInsert","OnGlobalModify",... of codeunit 1.
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.

florynx · 2006-08-07

kriki wrote:

You can use "OnGlobalInsert","OnGlobalModify",... of codeunit 1.
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.

where can I enable logging?

ufuk · 2006-08-07

If you use 4.0 then;

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

florynx · 2006-08-07

Is this the only solution?
Is not possible to use the Intercompany Posting for this?

florynx · 2006-08-08

Anyone?

Luc_VanDyck · 2006-08-08

I suggest you look at a specialized solution: http://www.databackbone.com/domsite/bac ... endocument

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).

Navision 4.0 synchronization

Comments

Categories