Conflict g/lentry and custleger entry tables transaction no

ahmedba

I use Data Transfer Wizard (Navision) to transfer all data between branches(Databases in my company)
Now I face big proplem when i transfer cust ledger entry table or vendor ledger entry table no data i found proplem.
this proplem is trnsaction no conflict between databases i transfer from it and database i transfere to it
How i solve proplem
EX
branch A transaction no 100
branch B transaction no 100
branch C transaction no 100
All this collect in database D
This meaning when i select transaction no 100 in database D this will select and show all branches
How i but range to every branch to transaction no
branch A transaction no 1-100000
branch B transaction no 200000-2000000
branch C transaction no 3000000
- 300000000
This proplem also face me when i reverse transaction from g/l entry table i see when i reverse transaction more line from more branches not related to this transaction i reverse itand show because it has same number of transaction.
Now how i prevent this conflict
or if any solution will prevent conflict in transaction no
Please if any one help me
thanks

lubost

Hi,

The best way to transfer data (merge) is transfer them to appropriate journals a post journals lines standard way. Navision will create all links automatically.

ahmedba

can i do this pro-grammatically if possible

or you can give me idea

Marije_Brummel

What is the business case that makes you require this?

There is consolidation in NAV, there is also intercompany postings.

Are you looking for some kind of hub and spoke model within NAV?

ahmedba

This solution about in second thread "The best way to transfer data (merge) is transfer them to appropriate journals a post journals lines standard way. Navision will create all links automatically"
this not suitable for me because every branch have separated accounts and posting for each other.
When we make journal in branches it must post because every customer related or near from branch he treat with it.
But after data posted to every branch i need to consolidate all branches in one database
but im afraid from transaction no conflict or interupt