Views

From Wiki

Introduction

This article explains how to download, install and configure the Spanish localization pack.

About the Spain Community Localization Pack

The Spain Community Localization Pack is a pack of modules containing the following extensions to Openbravo ERP:

Once you have installed the localization pack, each of these modules are available to implement independently of each other. For example, you may want to use a Spanish chart of accounts without applying the user interface translation.

Accessing the Spain Community Localization Pack

The Spanish localization pack is a module, which you can access via the central repository. It consists of a file called org.openbravo.localization.spain-1.0.0.obx (.obx is the standard file extension for Openbravo ERP extension modules).

1. Log into Openbravo ERP in the System Administrator role.
2. From the Application Menu, select General Setup > Application > Module Management.
3. Click Add Modules. The list of modules available to install appears.
4. Navigate to the Spanish Localization Pack.
5. Click Install Now.
6. A confirmation box appears. Click Continue to proceed with the installation. The license agreement appears.
7. Click I accept the license agreement.
8. Click Continue. Your selected module appears in the list of installed modules.
9. Click Rebuild now. A new window appears showing the rebuild in progress.
10. When the rebuild is complete, you must choose an option for how to restart Openbravo ERP. You can choose from the following:
    • Restart the servelet container: restarts Tomcat and reloads the application.
    • Reload the context: reloads only the contexts that have changed.
    • Take no action: does not reload any part of the application. Select this option if you want to manually restart Openbravo ERP later.
11. Click Continue.

Configuring the Spain Community Localization Pack

Once you have installed the localization pack, you need to configure the modules that have been installed:

• Configure Openbravo ERP to use the Spanish chart of accounts.
• Set up the accounting alerts.
• Enable the Spanish translation
• Configure the Spanish taxes.

Configuring the chart of accounts

The process for setting up the chart of accounts depends on how your instance of Openbravo ERP has been configured so far:

• If you have not yet set up the clients and organizations for your enterprise, follow these steps.
• If you have already set up the clients and organizations for your enterprise but have not included accounting follow these steps.

Configuring the chart of accounts for a new client

If you have not yet configured the clients and organizations for your enterprise, you can automatically set up the Spanish chart of accounts during the client setup process. Before you begin, make sure that you have installed the Spanish localization pack, rebuilt the system and restarted Openbravo ERP.

1. Log into Openbravo ERP with a systems administrator role.
2. From the Application menu select General Setup > Client > Initial Client Setup.
3. Complete the client information fields as required.
4. Select the include accounting checkbox.
5. In the Reference Data section, select the chart of accounts you require (standard or PYME).
6. Click OK

Configuring the chart of accounts for an existing client

If you have already configured the clients and organizations for your enterprise and want to apply the Spanish chart of accounts, you must import the accounts .csv file that is included in the module, using the import data process.The chart of accounts .csv file is usually placed in the folder /module/spanishLocalizationpack/referenceData within your file system.

Loading the accounts

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, navigate the .csv file you want to import.
4. Click Open.
5. From the Format File menu select Accounting - Accounts.
6. Select the Header First Line checkbox.
7. Details of the accounts to be imported appear in the lower half of the window.
8. Click Process.

Importing the accounts

View larger

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

Configuring accounting alerts

The following alerts are included in the Spain Community Localization Pack:

• G/L Journal in error status
• G/L journal not completed for more than a week.
• Customer without accounting.
• G/L journal in not balanced status.
• Bank statement not completed for more than a week.
• Settlement accounting date not in a period.
• Bank statement in not balanced status
• Purchase invoice not completed for more than one week.
• Cash book without accounting.
• Manual settlement in not balanced status.
• Business partner group without accounting.
• Cash journal in error status.
• Purchase invoice in a closed period.
• Withholding without accounting.
• Purchase invoice in error status
• Sales invoice in a closed period.
• Manual settlement in a closed period.
• Settlement in a closed period.
• Not balaned G/L Journal
• Not Balanced amortization.
• Not balaned payment management
• Not balanced bank statement.
• Not balaned cash journal.
• Not balanced purchase invoice
• Not balanced sales invoice.
• Not balanced manual settlement.
• Not balanced settlement.
• G/L Journal in a closed period.
• Purchase invoice in a not balanced status
• Dynamic accounting report in different schema than parent.
• Amortization in error status.
• Bank statement in error status.
• Account with operands from another account tree.
• Manual settlement accounting date not in a period.
• Payment status not completed for more than a week
• Product category without accounting.
• Settlement in not balanced status.
• Bank account without accounting.
• Manual settlement not completed for more than a week.
• Cash journal not completed for more than a week.
• Bank statement in a closed period.
• Payment status accounting date not in a period.
• Sales invoice not completed for more than a week.
• G/L item without accounting.
• Settlement in error status.
• Product without accounting.
• Vendor without accounting.
• Sales invoice in error status
• Amortization not completed for more than a week.
• Cash journal accounting date not in a period.
• Purchase invoice accounting date not in a period.
• G/L Journal line and header have different acct. schema.
• Cash journal in a closed period.
• Amortization in a closed period.
• Amortization in not balanced status.
• Cash journal in not balanced status.
• Sales invoice in not balanced status.
• Tax without accounting.
• G/L Journal accounting date not in a period.
• Payment status management in error status.
• Payment status management in not balanced status
• Manual settlement in error status.
• Account with operand refering a parent account or itself.
• Bank statement date not in a period.
• Payment status management in a closed period.
• Amortization accounting date not in a period.

Although installing the module installs the alerts, you must activate them and apply them to specific roles. Users will not receive alerts until you apply and activate them.

Enabling accounting alerts

In order to make accounting alerts available, you must install the module for each client and organization within your system.

Enabling alerts for a new client

If you are setting up a new client, you can enable the alerts while you set up the client using the initial client setup process:

1. Log into Openbravo ERP using the Systems Administrator role.
2. From the Application Menu, select General Setup > Client > Initial Client Setup.
3. Complete the details of the client as required.
4. In the Reference Data area, check the Accounting Alerts checkbox.
5. Click OK.

Allocating alerts to roles

1. Log into Openbravo ERP with a client admin role.
2. From the Application menu, select General Setup > Application > Alert
3. Select the Alert Recipient tab.
4. Click New.
5. From the Alert Rule menu, select the alert you want to enable.
6. Select grid view. A list of available alerts appears.
7. Select the alert you want to allocate to a role. The record for the alert appears.
8. Select the Alert Recipient tab.
9. Click New.
10. From the Role menu select the role which will receive the alert.
11. To send alerts to a particular user, select a user from the User / Contact list.
12. Click Save.

Applying the Spanish translation

The translation module is applied at system level, so you do not need to configure it for a particular client. When you log in as a particular role, you can choose the language in which Openbravo ERP operates:

1. Click the Role icon.The User Options window appears.
2. From the Language list select Spanish (Spain).
3. Select any other user options you require, such as Role or Organization.
4. Click the Default checkbox to set your chosen user options as the default for future logins.
5. Click OK. On-screen text now appears in Spanish.

Applying the Spanish taxes

The Spanish localization pack includes the following tax features:

Tax Categories

• Exento
• IVA 16%
• IVA 4%
• IVA 7%

Tax Rates

• Adquisiciones intracomunitarias 16%
• Adquisiciones intracomunitarias 16% (-16%)
• Adquisiciones intracomunitarias 16% (+16%)
• Adquisiciones intracomunitarias 4%
• Adquisiciones intracomunitarias 4% (-4%)
• Adquisiciones intracomunitarias 4% (+4%)
• Adquisiciones intracomunitarias 7%
• Adquisiciones intracomunitarias 7% (-7%)
• Adquisiciones intracomunitarias 7% (+7%)
• Entregas intracomunitarias 16%
• Entregas intracomunitarias 16% (-16%)
• Entregas intracomunitarias 16% (+16%)
• Entregas intracomunitarias 4%
• Entregas intracomunitarias 4% (-4%)
• Entregas intracomunitarias 4% (+4%)
• Entregas intracomunitarias 7%
• Entregas intracomunitarias 7% (-7%)
• Entregas intracomunitarias 7% (+7%)
• Exento Internacional
• Exportaciones definitivas (16%)
• Exportaciones definitivas (4%)
• Exportaciones definitivas (7%)
• Ventas a Canarias, Ceuta y Melilla (16%)
• Ventas a Canarias, Ceuta y Melilla (4%)
• Ventas a Canarias, Ceuta y Melilla (7%)

Enabling Spanish taxes

Taxes are applied at client or organization level. Once you have installed the localization pack you must enable the tax module for the clients or organizations that require it.

The process for setting up the Spanish taxes on how your instance of Openbravo ERP has been configured so far:

• If you have not yet set up the clients and organizations for your enterprise, follow these steps.
• If you have already set up the clients and organizations for your enterprise but have not included accounting follow these steps.

Enabling Spanish taxes for a new client

If you are creating a new client, you can enable Spanish taxes during the Initial Client Setup process:

1. Log into Openbravo ERP with a systems administrator role.
2. From the Application menu select General Setup > Client > Initial Client Setup.
3. Complete the client information fields as required.
4. Select the include accounting checkbox.
5. In the Reference Data section, select the Taxes: configuration for Spain
6. Click OK

Enabling Spanish taxes for an existing client

To enable Spanish taxes for an existing client, you must use the Import Data process:

Loading the taxes

1. Log into Openbravo ERP using the client admin role.
2. From the Application menu, select Master Data Management > Import Data > Import File Loader.
3. Click Browse. From the dialog box that opens, navigate the .csv file you want to import.
4. Click Open.
5. From the Format File menu select Taxes.
6. Select Header First Line.
7. Click OK.
8. Details of the taxes to be imported appear in the lower half of the window.
9. Click Process.

Importing the taxes

1. Log into Openbravo ERP using the Client admin account.
2. From the Application menu, select Master Data Management > Import Data > Import Taxes.
3. Click New.
4. From the Client menu, select your client.
5. In the Name field, type a name for the import process.
6. In the Search key field, type a short expression that you can use for this import process.
7. Click Import Taxes. Openbravo imports the account schema information into the database tables. You can now apply taxes to products and business partners in the normal way.