transfer sales data from database to another by dataport

ahmedba

Hi my company has more branches and i have two databases A,B i want two databases asynchronously updated sales data so that i using data port in dynamic nav 2009

this data port consist from this tables as following :

DataItem Name

Customer

Item

Location

Sales Header

Sales Line

Sales Shipment Header

Sales Shipment Line

Return Shipment Header

Return Shipment Line

Sales Invoice Header

Sales Invoice Line

Sales Cr.Memo Header

Sales Cr.Memo Line

Cust. Invoice Disc.

Cust. Ledger Entry

Detailed Cust. Ledg. Entry

1- Are this idea will make conflict in data

2- Are there are any tables remaining and arrangement is OK

thanks

please help me

geordie

ahmedba wrote:

1- Are this idea will make conflict in data

I wonder if the VAT Business setup and VAT Posting setup are the same between the two databases: in case those tables should be added at the list, if you want to achieve coherent VAT calculation on documents.

Chart of accounts are synchronized? Dimensions?

ahmedba

I don't using vat in company or in my company but i using dimension and chart of account
are this only remaining :
g/l account
g/l entry
dimension
ARE THIS ONLY REMAINING or there are another tables

geordie

ahmedba wrote:

I don't using vat in company or in my company but i using dimension and chart of account
are this only remaining :
g/l account
g/l entry
dimension
ARE THIS ONLY REMAINING or there are another tables

Please add also:

- Document Dimension
- Posted Document Dimension
- Ledger Entry Dimension

Do you want to synchronize also item entries?

ahmedba

if i asyncronus item also i will use
item ledger entry table
and
value entry table
but i have some question if possible help me in reply
1-are data will conflict if i using data port to import and export data
2-when i using data port to transafer sales data it accept all tables data as following :
sales header
sales line
sales shipment header
sales shipment line
sales invoice header
sales invoice line
but not ask me about item table why although codes item using in sales not found in database i import to it
3-auto update and auto save is yes
are auto replace also must be yes
4- if cust ledger entry has transaction no 100 and database i import to it also has transaction no 100 in cust ledger entry table(meaning if transaction no field exist in database i transfer to it are this will make proplem)
are this will make conflict
I m sorry to ask all these questions but if possible can any one help me
thanks