Since JIWA financials 6.5.13 does not handle multi company, we have to setup a seperate database in order to handle this situation. By setting up a seperate database, you have the ability to do the following:

1. Maintain Seperate Debtors, Creditors and GL Balances

2. Maintain different currencies in each database

3. Have seperate documents (Invoices/PO/Cheques/Financials reports)

4. Perform country specific financials regulations

Lets assume you have to maintain two country requiremenmts in JIWA. One for Australia and another for PNG. Lets say that your Australian database is fully setup and you need to maintain a similar setup for PNG. Here are the steps you need to perform:

1. Make a copy of your Australian Company JIWA database and restore as a new database on the same server. Use a naming convention that keeps the database together and easily identified

2. Create a connection to the new database from the JIWA client

3. Log in to the New JIWA database and configure the new database with PNG requirements

4. Clear out transactions from the PNG database so that you can define a starting point (Request JIWAClearTransactionsScript.sql from Link Support)

5. Change document layouts if required

6. Take a backup an run some tests – If all ok then restore Pre UAT backup and go-live

Here how you setup company consolidation

1. Identify the Consolidation company (Create a new one if required)

2. Verify the GL account structure of consolidation companies

3. Implement automatic Journal Consolidation and Verify (Contact Link Technologies to implement Web Portal Consolidation utility)

How to perform Monthly Consolidations

Once consolidation is setup, you are now ready to consolidate your databases. Before consolidation, you need to finalise the companies you want to consolidate.

1. Select Consolidate from the portal Consolidation menu. you will get a list of databases and periods that are available for consolidation.

2. Select the database, currency and rate to use for consolidation.

3. Select Process.

4. Review the consolidation journal.

--- END OF POST ---