Projects:Generic COA/User Manual
Contents |
Installation Instructions
To install this module, log into Openbravo as a System Administrator and open the Module Management window. You can then search the module in the Add Module window using the name Generic Chart of Accounts and following the guided installation and build flow.
After installation, the Generic Chart of Accounts will be available for selection during Initial Client Setup and Initial Organization Setup. Please refer to these instructions for more details.
Configuration
After having created an organization with this chart of accounts, you will have in your system an accounting schema that references it. To complete the configuration you need to take the following two additional steps:
- Complete the accounting defaults
- Setup the balance sheet and income statement reports
- Fine tune layout of reports
Completing the accounting defaults
To complete the accounting defaults.
- Log into Openbravo as your client administrator
- Navigate to the Accounting Schema window and open the Defaults tab
- Complete the defaults by populating the following accounts:
- Product Revenue Return: 4200
- Product COGS Return: 5200
- Inventory Revaluation: 6712
Setting up the Balance Sheet and Income Statement Reports
Balance Sheet
To configure the Balance Sheet report:
- Log into Openbravo as your client administrator
- Navigate to the Balance Sheet and P&L Structure Setup window
- Create a record for your accounting schema with the following attributes:
- Organization: choose the legal entity to which this accounting schema applies
- Accounting Schema: select your accounting schema
- Name: Balance Sheet
- Report Type: Point In Time
- Balance: Yes
- Create a child record in the Grouping Category tab
- Line No: 10
- Name: Balance Sheet
- Create a child record in the Node tab
- Line No: 10
- Account Element: B - Balance Sheet
- Name: Balance Sheet
Income Statement (Profit & Loss)
To configure the Income Statement report:
- Log into Openbravo as your client administrator
- Navigate to the Balance Sheet and P&L Structure Setup window
- Create a record for your accounting schema with the following attributes:
- Organization: choose the legal entity to which this accounting schema applies
- Accounting Schema: select your accounting schemaBalance Sheet
- Name: Profit & Loss
- Report Type: Periodic
- Balance: No
- Create a child record in the Grouping Category tab
- Line No: 10
- Name: Profit & Loss
- Create a child record in the Node tab
- Line No: 10
- Account Element: P&L - Profit & Loss
- Name: Profit & Loss
Fine tune layouts of reports
In order to obtain a properly formatted balance sheet report, the following change is recommended:
- Log into Openbravo as your client administrator
- Navigate to the Account Tree window
- Select your chart of account and open the Element tab
- Query account 3005 (Equity) and set Element Shown = No.