Skip to main content

Install Amerpsoft ERP

To begin a new Amerpsoft installation and configuration, you should start with the iDempiere installation. The official iDempiere wiki has a page you can visit called Installing iDempiere.

On GitHub, you'll find installation procedures for different platforms that complement the one published on the wiki: Installing Idempiere

Program Sources and Versions​

The project sources are located at:

The following tools and environments are used for compilation:

  • Operating System: Ubuntu 22.04 machine
  • IDE: https://github.com
  • JDK: Java JDK 17 openjdk
  • Database: PostgreSQL 16

The following tools are used for database scripts:

  • DBeaver
  • PgAdmin3 for PostgresSQL

The nomenclature AMERP is used for custom fields and tables. Demography tables are built with the prefix "C_", following the Adempiere model.

iDempiere and Database Version​

iDempiere version 12 (Release 12_2024-12-24) is used with database version 20080428-1232.

You can download the compiled version from the official page:

You can also clone the repository to get the sources:

Supported Language Definitions​

Version 12 is configured by default with English (en_US) and Colombian Spanish (es_CO).

Visit Languages.

To configure the Venezuelan Spanish (es_VE) language, the Community plugins available on GitHub. Languages Sources

You can find instructions to install the Spanish language pack in this source.

There is a brief explanation:

iDempiere supports multiple languages. For more information on language packs, consult the following links:

Spanish localizations (e.g., es_ES, es_VE, es_PY, es_CL) are similar, so existing translations are cloned and differences are adjusted.

Set Spanish es_VE as the system language:

  1. Log in with the system language in English.
  2. Go to the menu: /System Administration/General Rules/System Rules/Language.
  3. In the language window, locate es_ES, es_VE, es_PY or your preferred language (xx_XX).
  4. Check the "System Language" option.
  5. Run the "Language Maintenance" process.

Create the language extension for es_VE:

  • Download the Create-language-from-es-CO-to-es-VE.sql script from the repository.
  • Execute the query in a SQL console (DBeaver for PostgreSQL). You can edit the query for your preferred language.
  • Remember to synchronize terminology.

Manual changes in some translations:

  • Manually translate the labels for regions, municipalities, and parishes in Dictionary/Application Messages.

    • For Venezuela, change to "Estado", "Municipio", "Parroquia".

  • Manually translate the language record:

    • Go to System Administrator/General Rules/System Rules/Language.
    • Modify the "Print Text" field and translate it (e.g., Spanish (Venezuela) for es_VE).

Enable/disable login language:

  • In the /System Administrator/General Rules/System Rules/Language menu, go to the specific language (es_VE).
  • In the "Login Locale" field, check "Login Enabled".

Country Demography Installation​

Visit Extended Editor Plugin.

You can find instructions to install the plugin and Venezuelan Demography and other countries.

There is a brief explanation:

Method A: Starting with the Adempiere_pg.dmp database from version 12. Follow the procedure in the GitHub repository for the plugin installation.

  • Amerpsoft Plugin Editor - Extended Location: This Amerpsoft plugin extends the location field to include demographic concepts beyond country, region, and city (e.g., municipalities and parishes).
  • For more information, consult the DemografiaExtendida_amxeditor.pdf file and the iDempiere wiki on extended location.

Method B: Use the idempiere12_src_baseVE.backup database, which already contains the full demography:

  • Countries (c_country)
  • Country Communities (c_community - NEW)
  • States or Provinces (c_region)
  • Cities (c_city)
  • Municipalities (c_municipality - NEW)
  • Parishes (c_parish - NEW)
  • Zip Codes (c_zipcode - NEW)

The c_location table has been modified to include the c_municipality_id, c_parish_id, and c_zipcode_id fields.

Additional Consideration for Address Formats:

  1. Define the default address for 'System':

    • Log in as the 'System' user (preferably in English).
    • Go to System -> Data -> Utilities -> Location.
    • Configure the main address, especially the region and country.

  2. Define the capture order for address fields:

    • Go to the menu: System -> General Rules -> System Rules -> Country Region and Cities.
    • Modify the 'Capture Sequence' field for the es_VE language.
    • The following sequence is suggested: @CO@ @R@ @C@ @A1@ @A2@ @A3@ @A4@, @P@

LCO Localization Installation​

Visit LCO - Withholding.

There you will find instructions for installing the plugin.

The LCO localization incorporates the management of withholdings. For version 12, the org.amerpsoft.lve.idempiere.lco.withholding_12.0.0.202503181013 plugin must be installed using the FENIX console. The Documentno and Description fields were added to the lco_invoicewithholding table.

Visit LCO Localization.

You can find instructions to install the plugin for Withholding Documents Registration and Printing..

Here is a brief explanation:

Installation procedure:

  1. Install the JAR plugin:

    • Use the Apache Felix web console to install the JAR file.
    • Restart the server.
    • Remember: Update role access, synchronize terminology, and verify the sequence and package.

  2. Verify the package:

    • The package files that should be updated and loaded are AMERPSOFT LCO Withholding (2Pack_7.1.1.zip) and AMERPSOFT LCO Withholding Windows (2Pack_7.1.2.zip).

  3. Add withholding data (Venezuela):

    • Log in as GardenAdmin and use the package file AMERPSOFT LCO Withholding Data.zip.

  4. Create and update document types:

    • Create the document types listed in the AMERPSOFT_Document_Types.xls file.
    • Update existing document types (Invoice, credit memo, debit memo).

  5. Create sequence for the included document type:

    • Verify the sequence of withholding documents.

  6. Import CSV files:

    • Import the LCO_ISIC.csv file and the CSV files for Taxpayer Type, Tax Categories, and Tax Rates.

  7. Adjust accounting by group:

    • Manually adjust and run the database update command.

  8. Withholding rules configuration:

    • Manually create or import the Withholding Categories, Withholding Types, Withholding Calculation, and Withholding Rules.

Once finished, the system will be configured with the following functionalities:

  • Tax rates and categories
  • Withholding categories, types, and rules
  • Updated Vendor and Customer Invoice windows
  • Withholding Invoice windows (IVA and Municipal)
  • Customer Refund Check window