Options

transfer sales data from database to another by dataport

ahmedbaahmedba Member Posts: 424
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

Comments

  • Options
    geordiegeordie Member Posts: 655
    edited 2013-06-26
    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?
  • Options
    ahmedbaahmedba Member Posts: 424
    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
  • Options
    geordiegeordie Member Posts: 655
    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?
  • Options
    ahmedbaahmedba Member Posts: 424
    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
Sign In or Register to comment.