Chart of Accounts Testing Test 3

Summary

This document explains how to test a chart of accounts in Openbravo. It is the same test that is available in sourceforge*, but without executing all the actions required in the document.

Since December 2007, the sample data in the trunk contains a new client (different from Big Bazaar) that contains all the accounting data necessary to perform the 3rd test for a chart of accounts.

Testing a Chart of Accounts

The steps to perform the test are:

1. Switch to the Accounting Test client.
2. Stop the background process.
3. Reset all the accounting.
4. Choose whether shipments generate accounting or not.
5. Mark up the accounts in the database.
6. Import the Chart of Accounts that is going to be tested.
7. Delete the old accounts.
8. Rebuild the accounting.
9. Obtain reports.

1. Switch to the "Account Test" client

Click the User Preferences Button at the top left hand corner of the screen.

Choose the Accounting Test Role.

2. Stop the background process

Go to General Setup>Process Scheduling>Process Request>Process Request, stop the accounting background process.

3. Reset all the accounting

Go to Financial Management > Accounting > Transactions > Reset Accounting.

Choose the Accounting Test client, no table.

Check the Delete Existing Accounting Entries checkbox.

Click on OK.

4. Choose whether shipments generate accounting or not

If the chart of accounts is not configured for shipments to generate accounting, then go to Financial Management>Accounting>Setup>Accounting Schema>Accounting Schema>Account Schema Tables, choose the row of the MaterialMgmtShipmentInOut table, and deactivate the Active checkbox.

5. Mark up the accounts in the database

Go to the database manager software (TOAD, in example), and execute the next sentences:

update c_elementvalue set value = 'xx' || value where ad_client_id = '1000001'

delete from c_elementvalue_operand

• Note that we are writing directly the ad_client_id number. If you want to import a chart of accounts for a client different from "Accounting Test", then you must use its ad_client_id.

6. Import the Chart of Accounts that is going to be tested

Go to Master Data Management > Import Data > Import File Loader, choose your .csv Chart Of Accounts file, Format File: Accounting Accounts and, if proceed, check Header First Line. Then click on OK for watching a preview of the chart of accounts to be imported, or on Proceed.

Then go to Master Data Management > Import Data > Import Account, and click on the Import Accounts button:

Uncheck Create New Combination, and click on OK.

7. Delete the old accounts

Go back to the database manager software, and execute the following statements:

delete from c_elementvalue where value like 'xx%' and ad_client_id = '1000001'

8. Rebuild the accounting

Go to Financial Management > Accounting > Transactions > GL Posting by DB Tables. Choose no table, and click on Ok:

Note: this process can take a lot of time – more than an hour, in some cases.

Once the process is finished, check that there are no documents pending to be posted.

Go to Financial Management > Accounting > Analysis Tools > Not Posted Transaction Report, and check if there are any documents that are not posted:

If any not posted documents still exist, go and post them manually.

9. Obtain reports

Now get the general ledger journal, general ledger report, the Balance Sheet, and the Income Statement Report and the Balance in the General Accounting Report option. Check them to see if the balance report is balanced, the amounts of the accounts are correct, etc.

* The last version of that document is the 1.4. In this version, we differentiate if only the invoices generates accounting -as in the Spanish case-, or if the goods shipments also generates accounting -as in the US case-.