ERP 2.50:Configuration Manual/Setting up accounting

ERP 2.50:Configuration Manual

ERP 2.50:Configuration Manual/Introduction ERP 2.50:Configuration Manual/Getting started ERP 2.50:Configuration Manual/Modeling your enterprise ERP 2.50:Configuration Manual/Setting up accounting ERP 2.50:Configuration Manual/Accounting reports ERP 2.50:Configuration Manual/Setting up taxes ERP 2.50:Configuration Manual/Tax Payment ERP 2.50:Configuration Manual/Tax reporting ERP 2.50:Configuration Manual/Document types ERP 2.50:Configuration Manual/Roles and users ERP 2.50:Configuration Manual/Business partners ERP 2.50:Configuration Manual/Setting up products ERP 2.50:Configuration Manual/Pricing ERP 2.50:Configuration Manual/Importing data ERP 2.50:Configuration Manual/Procurement ERP 2.50:Configuration Manual/Warehouse management ERP 2.50:Configuration Manual/Assets ERP 2.50:Configuration Manual/Production management ERP 2.50:Configuration Manual/Material requirement (MRP) ERP 2.50:Configuration Manual/Project management ERP 2.50:Configuration Manual/Personalizing Openbravo ERP ERP 2.50:Configuration Manual/Modules Management ERP 2.50:Configuration Manual/Configuration changes that affect the Core module ERP 2.50:Configuration Manual/Appendix

Index

Contents 1 Setting up accounting 1.1 Setting up the account schema 1.2 Setting up accounting manually 1.2.1 Creating the account schema 1.2.2 Creating the accounting elements 1.2.3 Creating the account tree 1.2.4 Uploading the account file 1.2.5 Importing the accounts 1.3 Applying a reference module 1.4 Testing the accounts schema 1.5 Defining the fiscal year and accounting periods 1.5.1 Defining non-business days 1.6 Setting up bank accounts 1.6.1 Setting up a bank 1.6.2 Setting up a bank account 1.7 Setting the opening balance 1.7.1 Creating a G/L Item 1.7.2 Creating accounting year 0001 1.7.3 Opening accounting period 1 1.7.4 Making the manual payment 1.7.5 Creating a bank statement 1.7.6 Creating the General Ledger journal Entry 1.7.7 Creating pending payments (receivables, payables) 1.7.8 Closing accounting period 1 1.8 Setting up a Cashbook 1.9 Negative Accounting 1.10 Disable Background For Group Of Documents 2 Accounting templates 2.1 Installing an accounting template 2.2 Applying the accounting template to an accounting schema table 2.3 Example: amortization of subsidized assets

Setting up accounting

If you intend to use Openbravo ERP for accounting, you must complete the following tasks:

• Set up the account schema.
• Set up the financial calendar.
• Set up client bank accounts.
• Set up the starting balance.

Setting up the account schema

The account schema provides the structure for your accounts in Openbravo ERP. There are two ways to implement an account schema:

• Using only the .csv file
• Using a reference data module

Setting up accounting manually

The easiest way to apply an accounting file is to upload it during the initial client setup process, because all the necessary tasks are automated. However, you can also upload the file after the initial client setup process is complete, using the Import Data function. If you choose to upload the .csv accounting files separately, you must complete the following steps:

1. Create the account schema.
2. Create account elements.
3. Create an account tree: this sets up the tables into which the data will be imported.
4. Upload the accounting files. Openbravo ERP places this data in temporary tables.
5. Import the accounts: Openbravo ERP imports the data into the correct tables.

Creating the account schema

1. Log into Openbravo ERP with the client admin role.
2. From the Application menu, select Financial Management > Accounting > Setup > Accounting Schema.
3. Click New.
4. The Client and Organization fields are populated by default.
5. In the Name field, give the account schema a name.
6. In the Description field, type a brief description of the account schema if required.
7. From the GAAP list, select the accounting rules you want to use. For most enterprises, US GAAP is suitable.
8. From the Currency list, select the currency you want to use for this accounting schema.
9. To allow negative transaction values in transaction reversal, select Allow negative. Clear the checkbox to ensure that debits and credits are reversed with positive values. Note you can override the schema setting at document type level.
10. Click Save.

Creating the accounting elements

After creating the account schema, you must now manually create the five schema elements that are created automatically in the initial setup process. The automated process creates the following elements:

• Account
• Organization
• Business Partner
• Product
• Project

However, you can create additional or different elements to suit your business requirements. The Account and Organization elements are mandatory.

1. Log into Openbravo ERP with the client admin role.
2. From the Application menu, select Financial Management > Accounting > Setup > Accounting Schema.
3. In grid view, select the schema you created in the previous task.
4. In the Name field, type Account.
5. Select the Balanced and Mandatory checkboxes.
6. From the Accounting Element list, select the account schema you created in the previous task.
7. Click Save and New. A new record appears.
8. In the Name field, type Organization.
9. From the Type list, select Organization.
10. Select the Mandatory checkbox.
11. Click Save and New. A new record appears.
12. In the Name field, type Business Partner.
13. From the Type menu, select Bus. Partner.
14. Click Save and New. A new record appears.
15. In the Name field, type Product.
16. From the Type menu, select Product.
17. Click Save and New. A new record appears.
18. In the Name field, type Project.
19. From the Type menu, select Project.
20. Click Save.

Creating the account tree

1. Log into Openbravo ERP using the Client admin account.
2. From the Application menu, select Financial Management > Accounting > Setup > Account Tree > Element
3. Click New.A new account tree record appears:
4. In the Name field, give the account tree a name.
5. From the Type menu, select Account.
6. From the Tree menu, select client name ElementValue (Account, etc.) where client name is the name of your client. For example if the client name is MyCompany the menu option would read MyCompany ElementValue (Account, etc)
7. Click Save.

Uploading the account file

1. Log into Openbravo ERP using the Client admin account.
2. From the Application menu, select Master Data Management > Import Data > Import File Loader.
3. Click Browse. From the dialog box that opens, select the .csv file you want to import.
4. Click Open.
5. From the Format File menu select Accounting - Accounts.
6. If the .csv file has header information (e.g. column headings) as the first line, select Header First Line. Clear the Header First Line checkbox if the .csv file consists only of the accounts data.
7. Click OK.
8. Details of the accounts to be imported appear in the lower half of the window.
9. Click Process.

Importing the accounts

1. Log into Openbravo ERP using the Client admin account.
2. From the Application menu, select Master Data Management > Import Data > Import Account.
3. Click New.
4. From the Client menu, select your client.
5. From the Accounting Element menu, select the name of the account tree that you have just created.
6. In the Name field, type a name for the import process.
7. In the Search key field, type a short expression that you can use for this import process.
8. Click Import Accounts. Openbravo imports the account schema information into the database tables.

Applying a reference module

To install accounts using a reference module downloaded from the Openbravo repository, follow these steps:

1. Log into Openbravo ERP as System Administrator.
2. From the Application menu, select General Setup > Application > Module Management. The Module Management Console displays.
3. Select the Add Modules tab.
4. To search for a particular module, enter your search terms and click Search. Alternatively, to view a full list of available modules, click View All.
5. The list of modules appears. To find out more about each module, click View Details.
6. For the module you want to install, click Install Now. A confirmation window appears with the details of your chosen module.
7. To continue installing the module, click Continue. To abort the installation, click Cancel.
8. The license agreement for the module appears. Select I accept all license agreements to accept the license agreement.
9. Click Continue. A message appears when the installation is complete.
10. Repeat the installation procedure for any further modules that are required.
11. In General Setup > Application > Module Management, select the Installed Modules tab. All the modules currently installed on the system appear in a list.
12. Click Rebuild Now. The Apply Modules window appears, showing the progress of the rebuild.
13. When the rebuilding process is complete, log out of Openbravo ERP.
14. Access the Tomcat server management page. If you are working on the machine where Openbravo ERP is installed, you can access the page by typing http:localhost:8080/manager/html into your web browser. If you are accessing Openbravo ERP from a remote location or through a virtual machine, use the URL http:IP_address/manager/html, where IP_address is the IP address you use to access Openbravo ERP. A password box is displayed.
15. Type the username and password for the Tomcat server. By default these are:
    • Username:admin
    • Password:openbravo
16. Scroll down to the Openbravo context and click Reload.
17. Click OK to confirm that you want to reload the context.
18. Start Openbravo ERP and log in in the usual way.

As well as downloading modules from Openbravo, you can create them in-house or aquire them from other community users. To learn more about the possibilities that modularity offers, see Modularity.

Testing the accounts schema

If you uploaded an accounts schema while creating the client, you can verify that the Accounting Schema import has been correct.

1. From the Application menu, select Financial Management > Accounting > Setup > Accounting Schema.
2. The accounting schema you have uploaded is displayed.

Defining the fiscal year and accounting periods

For accurate accounting it is important to define the start and end of the financial year and specify how the year is divided into periods.

1. From the Application menu, select Financial Management > Setup > Fiscal Calendar.
2. Click New. A new calendar record appears, with the Client field populated by default.
3. In the Organization field, select the organization that will use the calendar. If you want the calendar to apply to all organizations within the client, select *.
4. In the Name field type the name of the new calendar, for example Accounting Calendar
5. In the Description field type a brief description of the calendar if required.
6. To make the calendar applicable immediately, select the Active checkbox.
7. Click Save.
8. Select the Year tab.
9. Click New. A new Year record appears.
10. In the Fiscal Year field, type the name of the fiscal year for example 09/10.
11. Click Save.
12. To automatically create 12 standard accounting periods for the year, click Create Periods. A confirmation box appears to confirm the creation of the periods.
13. Alternatively, to create custom accounting periods, select the Period tab.
14. Click New. A new period record appears.
15. In the Period box type the period number. For example if the period is the first in the year, type '1'.
16. Specify the Start date and End date of the period.
17. Click Save.
18. Continue to add periods until you have defined the whole year.

Defining non-business days

Non-business days can affect when an invoice (either a sales or purchase invoice) is payable. For example, the terms of an invoice can state that it is payable within 30 working days. It is therefore important do set up non-working days correctly so that invoices are paid on time.

1. From the Application menu, select Financial Management > Accounting > Setup > Fiscal Calendar.
2. Select the Non-business Day tab.
3. Click New. A new non-business day record appears.
4. In the name field, specify a name for the non-business day, for example Christmas Day
5. In the Date box, specify a date for the non-business day or select it from the calendar.
6. Click Save.

Setting up bank accounts

Each client and organization can have accounts with more than one bank, or multiple accounts within the same bank. There are two stages to setting up bank accounts:

• Set up the bank.
• Set up the accounts within that bank.

Setting up a bank

1. Log into Openbravo ERP with an Admin role.
2. From the Application menu, select Financial Management > Receivables and Payables > Setup > Bank.
3. Click New.
4. In the Name field, type the name of the bank.
5. To make the bank immediately visible and available for selection, select Active. Alternatively, clear the Active checkbox to deactivate the bank account.
6. In the Location / Address field, click the Address icon . The Location Selector box appears.
7. Type the address and location details for the bank.
8. Click OK to close the Location Selector box and return to the bank record.
9. In the Business Partner field, if you have set up the bank as a business partner, select it from the list. If you intend to use remittances, you must set up the bank as a business partner and select the business partner here.
10. If the bank account number is in a Spanish format, you must specify the following:
    • Bank code
    • Branch code
    • Control digit.
11. If the bank has an INE number, type it in the INE box.
12. If required, type the BIC code in the BIC Code box.
13. Click Save.

Setting up a bank account

1. Log into Openbravo ERP with an Admin role.
2. From the Application menu, select Financial Management > Receivables and Payables > Setup > Bank.
3. In grid view, select the bank where you want to create the account.
4. Select the Bank Account tab.
5. Click New.
6. From the Organization list, select the organization that will use the bank account. Alternatively, select * to make the bank account available to all organizations within the client.
7. From the Currency list select the working currency of the bank account.
8. To make the account visible and available for selection, select Active. Clear the checkbox to deactivate the account.
9. Select only one of the following checkboxes to determine the format of the account number as displayed in Openbravo ERP.
   • Show Spanish: the account format follows the standard for Spanish banking.
   • Show Generic: the account format follows the generic international standard.
   • Show IBAN: the account format follows the IBAN standard
10. From the Account Type list specify whether the account is a checking account or a savings account.
11. In the Partial Account Number field, type the bank account number.
12. In the IBAN Code field, type the IBAN code of the bank account if required.
13. Click Save.

Setting the opening balance

Please notice that, if the advance payables and receivables module is installed, there is no need to do all this stuff, but just setting the initial balance when creating the financial account [1]

Because in most cases, the business is already up and running at the time Openbravo ERP is implemented, the next stage of configuration is to set up the opening balance. The opening balance acts as a snapshot of your current financial situation on which you can base accounting in Openbravo ERP as you begin to post transactions.

Creating an opening balance in Openbravo ERP has two steps:

1. Posting an opening entry in the General Ledger to reflect the total balance.
2. Breaking down the balance into its component transactions for management and information purposes. These transactions are not posted, because they form part of an already posted total.

Once you have set up your bank accounts, the next step is to bring the account balance in Openbravo ERP into line with your external accounts. To set up the current balance you need to complete the following steps:

• Create a GL Item
• Create an accounting year 0001 with a single accounting period.
• Create a manual payment representing the account balance.
• Create a bank statement showing the starting balance.
• Create a general ledger payment for the starting balance.
• Permanently close the accounting period in year 0001.

As part of the manual settlement process, you will also be asked to specify a business partner. The particular business partner is not important to the task, but you will still need to set up a business partner because the field is mandatory. If you prefer, you can set up a dummy business partner purely for the purpose of setting up the starting balance.

Creating a G/L Item

G/L Items enable you to specify the accounts to which particular transactions will be posted, so that the person posting them does not have to understand the accounting structure. For example, you could set up a G/L Item called Stationery which the purchasing clerk could use for all purchases of stationery, without having to know the correct accounts to post to.

For the purposes of setting up a starting balance, it does not matter which G/L item you use. If you prefer, you can set up a dummy G/L item purely for use in setting up the starting balance.

1. Log into Openbravo ERP with the client admin role.
2. From the Application menu, select Financial Management > Accounting > Setup > GL Item.
3. Click New.
4. From the Client menu, select your client.
5. From the Organization menu, select *
6. Select the Active checkbox.
7. In the Name field, give the GL item a name.
8. Click Save.
9. Select the Accounting tab.
10. Click New.
11. The Client, Organization, Name and Account Schema fields are populated automatically.
12. From the GLitem debitaccount list, select any account.
13. From the GLitem creditaccount list, select any account.
14. Click Save.

G/L Items also enable you to specify G/L items which are going to be just enable while entering in the system sales/purchase invoices do not related to product/services but to "ledger accounts" through the corresponding "G/L item", that it a "financial invoice". For example, you could set up a G/L item called Electricity and select that G/L item while creating and posting later on a purchase invoice coming from a Company's vendor. In this case it also happens that the person entering and posting this kind of "financial invoices" does not have to understand the accounting structure behind.

1. Log into Openbravo ERP with the client admin role.
2. From the Application menu, select Financial Management > Accounting > Setup > GL Item.
3. Click New.
4. From the Client menu, select your client.
5. From the Organization menu, select *
6. Select the Active checkbox.
7. In the Name field, give the GL item a name.
8. Select the field Enable in Financial Invoices as "yes"
9. Select a Tax Category in the field Tax Category
10. Click Save.
11. Select the Accounting tab.
12. Click New.
13. The Client, Organization, Name and Account Schema fields are populated automatically.
14. From the GLitem debitaccount list, select any account.
15. From the GLitem creditaccount list, select any account.
16. Click Save.

The system will show up that G/L item while entering a purchase invoice so there is no need to enter in the purchase line a product but just a G/L item.

Creating accounting year 0001

Creating an accounting year of 0001 means that you can create the initial balance as a one-off payment, without the danger of subsequent payments into that year disrupting the accounts.

1. Log into Openbravo ERP with a client Admin role.
2. From the Application menu, select Financial Management > Accounting > Setup > Fiscal Calendar.
3. In grid view, select the client's financial calendar.
4. Select the Year tab.
5. Click New.
6. From the Organization list, select *.
7. In the Fiscal Year field, type 0001.
8. In the Description field, type a description of the fiscal year, for example Initial Balance.
9. Click Save.
10. Select the Period tab.
11. Click New.
12. In the Period no. field type 1.
13. In the Starting date field, type 01-01-0001.
14. In the Ending date field, type 01-01-0001.
15. From the Period type list, select Standard calendar period.
16. Click Save.

Opening accounting period 1

Once you have created accounting period 1 in accounting year 0001, open the period for manual settlements and bank statements.

1. From the Application menu, select Financial Management > Accounting > Transactions > Open / Close Period Control.
2. Click New.
3. From the Organization menu, select an organization.
4. From the Year list, select year 0001.
5. From the Until Period No., select 1.
6. From the Document Category list, select Settlement Manual.
7. From the Period Action list, select Open.
8. In the Description box type a brief note, for example Open period 1 for initial balance.
9. Click Save.
10. Click Open / Close All. The Open / Close all Base Documents window appears.
11. Click OK. Period 1 is opened.

To open period 1 for bank statements, repeat the process, but from the Document Category list select Bank Statement.

Making the manual payment

1. Log into Openbravo ERP with a client Admin role.
2. From the Application menu, select Financial Management > Receivables and payables > Transactions > Manual Settlement.
3. Click New.
4. From the Organization tab, select an organization.
5. From the Currency list, select the currency in which you want to make the manual payment.
6. In the Transaction date field, type 01-01-0001
7. In the Accounting date field, type 01-01-0001.
8. In the Description field, type a brief description of the manual payment if required, for example Initial balance
9. Click Save.
10. Select the Create Payment tab.
11. Click New.
12. From the Form of payment list, select Bank Deposit.
13. From the Business partner list, select any business partner.
14. From the Bank Account list select the bank account whose balance is being used for the starting balance.
15. From the Status list, select Received.
16. Select the Balance Payment tab.
17. Click New.
18. From the GL Item list, select any option.
19. In the Credit Amount field, type the starting balance of the bank account.
20. Click Save.

Creating a bank statement

1. From the Application menu, select Financial Management > Receivables and Payables >Transactions > Bank Statement.
2. Click New.
3. Select the organization that the bank statement applies to. To apply the bank statement to all organizations within the client, select *.
4. From the Bank Account list, select the bank from which the statement has been issued.
5. In the Description field, type a brief description of the bank statement if required.
6. In the Transaction Date field type the date of the bank statement.
7. To make the statement visible and available for selection, select the Active checkbox.
8. Select the Manual checkbox.
9. In the Beginning Balance box, type 0 (zero).
10. Click Save.
11. Select the Lines tab.
12. In the Effective Date and Accounting Date fields, type 01-01-0001.
13. In the Statement Amount field, type the amount of the as a manual settlement.
14. Leave the Payment and G/L Item fields blank.
15. Click Save.

Creating the General Ledger journal Entry

1. From the Application menu, select Financial Management > Accounting > Transactions > G/L Journal.
2. Click New.
3. In the Description field, type a brief description if required, for example Initial balance.
4. From the G/L Category list, select Manual.
5. In the Document date field, type 01-01-0001.
6. In the Accounting date field type 01-01-0001
7. From the Period list, select the accounting period 1 that you have just opened.
8. In the Control Amount field, type the initial balance. This should be the same as the manual settlement created previously.
9. Click Save.

Creating pending payments (receivables, payables)

1. Log into Openbravo ERP with a client Admin role.
2. From the Application menu, select Financial Management > Receivables and payables > Transactions > Manual Settlement.
3. Click New.

1. From the Organization tab, select an organization.
2. From the Currency list, select the currency in which you want to create the manual payment.
3. In the Description field, type a brief description of the manual payment if required, for example Pending receivable payment
4. Click Save.
5. Select the Create Payment tab.

1. Click New.
2. In the Due date field, type the day supposed you will collect that payment
3. From the Form of payment list, select your choice.
4. From the Business partner list, select the business partner related to the payment.
5. From the Bank Account list select the bank account supposed to collect/pay the payment.
6. In the Amount field, type the amount of the payment
7. Click on the Receipt check if its a receivable, or don't click it if it is a payable.
8. Select the Balance Payment tab.

1. Click New.
2. From the GL Item list, select desired option.
3. If it is a receivable type the amount in the Credit Amount field, if it is a payable type the amount in the Debit Amount field.
4. Click Save and process the manual settlement.

Closing accounting period 1

Once you have created the manual settlement, bank statement and General Ledger entry, the final step is to permanently close accounting period 1 for bank statements and manual settlements.

1. From the Application menu, select Financial Management > Accounting > Transactions > Open / Close Period Control.
2. Click New.
3. From the Organization menu, select an organization.
4. From the Year list, select year 0001.
5. From the Until Period No., select 1.
6. From the Document Category list, select Settlement Manual.
7. From the Period Action list, select Permanently Close Period.
8. In the Description box type a brief note, for example Open period 1 for initial balance.
9. Click Save.
10. Click Open / Close All. Period 1 is closed.

To close period 1 for bank statements, repeat the process, but from the Document Category list select Bank Statement.

Setting up a Cashbook

The cashbook records the flow of money in and out of your company. For larger companies, organizations can have separate cashbooks. To set up a cash book:

1. Log into Openbravo ERP with a client admin role.
2. From the Application menu, select Financial Management > Receivables and Payables > Setup > Cashbook.
3. Click New.
4. Select the organization that the cashbook belongs to. Each organization can have its own cashbook or multiple cashbooks. If the cashbook applies at client level, select *.
5. In the Name field, type the name of the cashbook.
6. In the Description field, type a brief description of the cashbook if required.
7. To make the cashbook visible and available for selection, select the Active checkbox. Clear the checkbox to deactivate the checkbox.
8. Click Save.

Negative Accounting

Negative accounting affects the way that reversals are accounted, and is set up as part of the accounting schema. When you reverse a transaction you can use either negative or positive values. For example, if a sales invoice document generates the following transactions lines:

GL	Line Type	Debit	Credit
Debtor	Sales Invoice	1,000	0
Revenue	Sales Invoice	0	1,000

If the Allow Negative option is selected, when the transaction is reversed, the system will allow the creation of the following negative transaction lines. Using negative lines for reversals is sometimes called storno accounting.

GL	Line Type	Debit	Credit
Debtor	Sales Invoice	-1,000	0
Revenue	Sales Invoice	0	-1,000

However, in some countries, negative entries are not accepted by auditors, in which case the correct way to reverse the transaction would be as follows:

GL	Line Type	Debit	Credit
Debtor	Sales Invoice	0	1,000
Revenue	Sales Invoice	1,000	0

Negative transaction lines are considered best practice in some countries, particularly in Central and Eastern Europe. These include (but are not limited to):

• Czech Republic
• Poland
• Romania
• Russia
• Slovakia
• Ukraine

In most countries negative transaction lines are not looked upon favorably by auditors and the expectation is that transactions are reversed using contra accounting. These countries include (but are not limited to):

• Spain
• United Kingdom
• United States

Because both types of transaction reversal are legitimate (in the correct accounting context), you can configure Openbravo ERP to suit your locale and preference.

The default behavior of reversing transactions is controlled by the accounting schema. For countries where transaction reversal using negative values is not normally used, make sure that the Allow negative option in Financial Management > Accounting > Setup > Accounting Schema not selected.

However, you can also override the schema behaviour at document type level, for example to allow negative accounting for particular accounting documents. This gives complete control to the implementer in defining the transaction reversal behaviour for each combination of schema and document type.

Note: in earlier versions of Openbravo ERP negative transactions were enabled by default.Users upgrading to Openbravo 2.50 from earlier versions will find the Allow negative option selected. It is recommended that you consider reconfiguring their systems to take advantage of the increased options for managing transaction reversals. In Openbravo ERP 2.50 the default behavior is to not allow negative transactions. In new implementations of Openbravo ERP, the Allow Negative option is deselected by default. This means that the default behavior for transaction reversal will be to use contra accounting, i.e., to disallow negative transactions unless they are specifically enabled at a schema or document level.

See an example of reverse transaction using Openbravo ERP in this blog post.

Disable Background For Group Of Documents

Groups of documents can be disabled for accounting by deactivating its table entry inside Financial Management > Accounting > Setup > Accounting Schema > Accounting Schema Tables. That will result in all the documents associated to that table not to be posted. From 2.50 MP22 on, groups of documents can as well be deactivated for background posting. Using "Disable for Background" flag we can disable a group of documents inside Financial Management > Accounting > Setup > Accounting Schema > Accounting Schema Tables. That way system will not post them automatically but user can do manual posting for those documents.

Accounting templates

Accounting templates enable you to override established accounting behaviour at organization or at document level by installing an extension module. You could use an accounting template to extend the default accounting behaviour used to post depreciation of assets in order to post both the asset depreciation and the corresponding amortization of a grant used in acquiring that asset. You can download and install an accounting template from the central repository in the same way as other modules, and then implement it at system level. Once you have implemented the template you can assign it to specific accounting schema tables or documents. Accounting templates can also include additional windows, tabs and fields, just like any other module.

Accounting templates are available from version 2.50 MP1 onwards

Installing an accounting template

1. Log into Openbravo with a Systems Administrator role.
2. From the Application menu, select General Setup > Application > Module Management.
3. Click Add Modules.
4. Either navigate to the module you require from the central repository or click Browse File System if the template is stored on your computer. Take note of the java package name of the module.
5. Click Install Now.
6. Accept the license agreement and click Continue.
7. When the installation process has finished, click Rebuild Now to rebuild your system.
8. When the system has rebuilt, follow the on-screen instructions to restart the Tomcat server.

You can check that the module has been installed and is available in Financial Management > Accounting > Setup > Accounting Templates.

Applying the accounting template to an accounting schema table

Once you have installed the template, you must apply it to the appropriate schema tables:

1. Log into Openbravo ERP with a client admin role.
2. From the Application menu, select Financial Management > Accounting > Setup > Accounting Schema
3. Select the Account Schema Tables tab.
4. In grid view, select the schema table you require.
5. From the Accounting template list, select the accounting template you want to apply to the account schema table.
6. Click Save.
7. Repeat the process to apply the accounting template to further schema tables.

Example: amortization of subsidized assets

The AmortizationSubsidy accounting template enables more accurate accounting when dealing with the amortization of a subsidy associated with an assets. For example, if government subsidy is available for the purchase of IT equipment, the AmortizationSubsidy module enables you to create to create amortization postings at the same time that the corresponding depreciation transaction is created.

Without implementing the new account template, depreciation of an asset would follow the following workflow:

1. Log into Openbravo ERP with a client admin role.
2. From the Application menu, select Financial management > Assets
3. Click New.
4. Select the Depreciate checkbox.
5. Set the annual depreciation to 10%
6. In the Purchase date field, specify a purchase date.
7. In the Depreciation start date field, specify the same date as the purchase date.
8. In the Asset value field, set the asset value to 5000EUR.
9. Click Create Amortization.
10. From the Application menu, select Financial Management > Assets > Amortization
11. Double-click the depreciation record you have just created.
12. Process the amortization and post it. The accounting entry is as follows:

Account No	NAME	DEBIT	CREDIT
68200	Amortización del inmovilizado material	500.00	-
28290	Amortización acumulada de otro in(...)	-	500.00

Now, install the AmortizationSubsidy accounting template (remember you must be logged in as System Administrator to install modules).

1. From the Application menu, select Financial Management > Accounting > Setup > Accounting Schema
2. Select the Account Schema Tables tab.
3. Select the FinancialMgmtAmortization table.
4. From the Accounting Template list, select AmortizationSubsidy.
5. Click Save.
6. From the Application menu, select Financial Management > Assets > Subsidizer Entity
7. Click New.
8. In the Search key field, type subsid.entity1.
9. In the Name field, type subsid.entity1.
10. Click Save.
11. Select the Accounting tab.
12. In the Subsidy and Subsidy Revenue fields, select Account 13200.
13. Click Save.
14. From the Application menu, select Financial Management > Assets
15. Click New
16. Fill in the fields as follows:
    • Asset: asset1
    • Subsidizer Entity: subsid.entity1
    • Percentage Due: 50 %
17. Click Save.
18. From the Application menu, select Financial Management > Assets > Amortization.
19. In grid view, double click on the amortization record you have just created.
20. Click Unpost.
21. Click Post. The account posting is as follows:

AccNo.	NAME	DEBIT	CREDIT
68200	Amortización del inmovilizado material	500.00	-
28290	Amortización acumulada de otro in(...)	-	500.00
13200	Ingresos derivados de derechos so(...)	250.00	-
13200	Ingresos derivados de derechos so(...)	-	250.00

The subsidy has been taken into account in the amortization calculations.

---

ERP 2.50:Configuration Manual/Modeling your enterprise | ERP 2.50:Configuration Manual/Accounting reports