Projects:Generic COA/User Manual

Contents 1 Installation Instructions 2 Configuration 2.1 Completing the accounting defaults 2.2 Setting up the Balance Sheet and Income Statement Reports 2.2.1 Balance Sheet 2.2.2 Income Statement (Profit & Loss) 2.3 Fine tune layouts of reports

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.