Is it Possible to consolidate Multi country databases in Nav

sasidharmv
sasidharmv Member Posts: 28
edited 2009-05-21 in NAV/Navision Classic Client
Hi All,

My client is having office at US and india and using US databsae in Us and Indian Database in india. Is it possible to consolidate both the databases and prepare financial statements? If so please give solution for this scenario.

Regards.
Sasidhar.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Consolidation is part of std nav. You need to create a new company. You can create it in US db or in India, depending on the person who is doing the consolidation. Then follow the consolidation manual on how to setup the GL account in the consolidated company and then import the GL entries from both companies into this new company and run your financial statement.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • sasidharmv
    sasidharmv Member Posts: 28
    Hi,
    Thanks for the information. But, country wide database is difference is there. In US the taxation system is VAT. But in India VAT some places some places Sales tax and other taxes like FBT, TDS, TCS etc are there. So how to consolidate these issues.

    Thanks and regards.
    Sasidhar.
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    The consolidation feature only consolidates general ledger (not sure about the IN version). It doesn't do any sales tax or vat calcuations.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • DenSter
    DenSter Member Posts: 8,307
    sasidharmv wrote:
    In US the taxation system is VAT
    No there is no VAT in the US
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • David_Singleton
    David_Singleton Member Posts: 5,479
    DenSter wrote:
    sasidharmv wrote:
    In US the taxation system is VAT
    No there is no VAT in the US

    Yes there is! In that big state you have up North :mrgreen: I think they call it GST though,
    David Singleton
  • David_Singleton
    David_Singleton Member Posts: 5,479
    sasidharmv wrote:
    Hi All,

    My client is having office at US and india and using US databsae in Us and Indian Database in india. Is it possible to consolidate both the databases and prepare financial statements? If so please give solution for this scenario.

    Regards.
    Sasidhar.

    I think you need to define what you think consolidation means.
    David Singleton
  • DenSter
    DenSter Member Posts: 8,307
    David Singleton wrote:
    DenSter wrote:
    No there is no VAT in the US
    Yes there is! In that big state you have up North :mrgreen: I think they call it GST though,
    You mean Canada eh? :mrgreen:
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    DenSter wrote:
    David Singleton wrote:
    DenSter wrote:
    No there is no VAT in the US
    Yes there is! In that big state you have up North :mrgreen: I think they call it GST though,
    You mean Canada eh? :mrgreen:

    and one more PST too (that is all) :lol: . But tax system here is quite simple than US and IN.
    Kapil Khanna
  • canadian_bacon
    canadian_bacon Member Posts: 91
    Actually, we have GST and PST and HST and QST, depending on which province you live in. And QST is based on the subtotal AND GST. No wonder we have universal health care, eh?
  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    oh it's just a couple of months i have come in Canada :oops: . Thanx for the update.
    Kapil Khanna
  • DenSter
    DenSter Member Posts: 8,307
    still, no VAT in the US
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • sasidharmv
    sasidharmv Member Posts: 28
    Hi all,

    Thanks for the information. But, i couldn't get the answer for my original problem. Is it possible to integrate two databases not companies. ex. We have Company A which is a parent company is in India and using Indian version(Based on the Indian scenario), Another company B which in US which is using navision of US version(Based on the US scenario). Now i want to see the analysis reports and transactions of both the companies at a single point. Is it possible or not?

    Thanks for your information in advance.

    Sasidhar.
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    Yes you can. Use the Consolidation feature.

    When you consolidate, you consolidate the G/L accounts into a consolidated company. Sales tax and VAT accounts will be consolidated as well.

    Since you do not process any orders in the consolidated company, you do not need to setup sales tax or VAT.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

Categories