Chart of Accounts Testing Test 3

Summary

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

Since December 2007, the sampledata 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. Mark up the accounts in the database.
5. Import the Chart of Accounts that is going to be tested.
6. Delete the old accounts.
7. Rebuild the accounting.
8. Obtain reports.

1. Switch to the Accounting Test client

Press on this button to change the user role:

Choose the Accounting Test Role:

2. Stop the background process

Go to General Setup > Application > Background Process, and click on deactivate, in the PeriodicAcctServer line:

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, and click on Ok.

4. 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 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.

5. 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.

6. Delete the old accounts

Go again to the database manager software, and execute the next statements:

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

7. Rebuild the accounting

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

Take into account that this process can take a lot of time: more than an hour, in some cases. Once it's finished, check that there is no document pending to be posted. Go to Financial Management > Accounting > Report Not Posted, and check if there is any document not posted:

If there exists any not posted document, go and post it manually.

8. Obtain reports

Obtain now 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-.