Is it Possible to consolidate Multi country databases in Nav

sasidharmv

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.

ara3n

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.

sasidharmv

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

The consolidation feature only consolidates general ledger (not sure about the IN version). It doesn't do any sales tax or vat calcuations.

DenSter

sasidharmv wrote:

In US the taxation system is VAT

No there is no VAT in the US

David_Singleton

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 I think they call it GST though,

David_Singleton

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.

DenSter

David Singleton wrote:

DenSter wrote:

No there is no VAT in the US

Yes there is! In that big state you have up North I think they call it GST though,

You mean Canada eh?

kapil4dynamics

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 I think they call it GST though,

You mean Canada eh?

and one more PST too (that is all) . But tax system here is quite simple than US and IN.

canadian_bacon

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

oh it's just a couple of months i have come in Canada :oops: . Thanx for the update.

DenSter

still, no VAT in the US

sasidharmv

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

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.