Skip to main content

Accounting and Financial

Follow the GitHub procedure for the installation of the AMERPSOFT Finance plugin.

Financial Plugin​

The AMERPSOFT Financial plugin integrates with iDempiere's accounting and adds new tasks, processes, and reports. It is the basis for a client's and an organization's initial setup.

Plugin content:

  • Database functions
  • Initial client setup
  • Plugin installation
  • Processes
  • Accounting reports
  • Taxes

Steps to follow:

  1. Install database functions: Run the database function scripts for PostgreSQL or Oracle.
  2. Initial client setup: Prepare the accounting elements and basic data for a demo client.
  3. Install the add-on: Install the plugin via the OSGI console.
  4. Processes: Verify the installed processes.
  5. Accounting reports: Review the accounting reports.
  6. Import financial taxes: Import tax categories and taxes.

Database Functions Installation​

Run the following scripts using an SQL console (DBeaver for PostgreSQL or SQLDeveloper for Oracle):

  • amf_dow2letter.sql
  • amf_month2letter.sql
  • amf_num2letter.sql
  • amf_num2letter1000.sql

Initial Client Setup​

Before installing the plugin, you must have a Business Group (Client) with an appropriate accounting schema and accounting elements. You can use iDempiere's demo client (Garden World), but it is recommended to create a new one with a chart of accounts adapted to your country.

For more information, see the iDempiere wiki on client initial setup.

Follow this procedure using the provided accounting plans:

  • NIIF Chart of Accounts December 2015.csv
  • LPY Chart of Accounts 2024.csv

1. Create a new client:

  • As a system administrator, start the tenant setup process.
  • Enter the values for the tenant and the organization.
  • It is very important that you enter the chart of accounts CSV file in this step.
  • Complete the process until you get final approval, which validates that all default accounts have been created and validated.

2. Import accounts:

  • Log in as the tenant administrator and go to the Import File Loader window.
  • Select the same CSV file you used in the previous step.
  • Select the import format Accounting - Accounts and run the import.
  • You will receive a message with the number of accounts imported.
  • Then, go to the Import Accounts window. The records will be imported, but you may need to delete the first empty record.
  • Run the Import Accounts process, selecting Client and Element.
  • Check the "Import Error Messages" column for any errors.

3. Change the account tree settings:

  • In the "Tree" window, check the "Show Search Key" option.

Financial Plugin Installation​

  1. Install the plugin JAR file:
  • Download the org.amerpsoft.lve.idempiere.financial_12.0.0.202404091015.jar file from the repository.
  • Install it via the Apache Felix web console (OSGI) or any other manual procedure.
  1. Update the packages (2Pack):
  • Download the AMERPSOFT Financial.zip file.
  • Use the Package menu in the application dictionary to import it.
  • Run the Synchronize Terminology, Sequence Check, and Role Access Update processes.
  1. Restart the server:
  • After the previous steps, restart the server.

Financial Processes and Reports​

Important: For the company logo to appear in reports, go to System Administration -> Tenant Rules -> Tenant and, in the "Tenant Info" tab, update the "Logo" and "Report Logo" fields.

AMERPSOFT financial processes:

  • Amfin Process: Accounting Restart
  • Amfin Process: Accounting Re-posting
  • Amfin Process: GLJournal Annual Close

AMERPSOFT financial reports (Jasper):

  • Amfin Account Elements
  • Amfin Trial Balance (by a period or by two dates)
  • Amfin State Financial Balance
  • Amfin State Financial Comprehensive Results

Import AMERPSOFT Financial Taxes​

  1. Import the package:
  • As a system user, use the AMERPSOFT Financial Taxes application dictionary package. This package modifies the C_TaxCategory table to allow tax importation.
  1. Import CSV files:
  • Log in as a tenant user and go to the tax import option.
  • Import the C_TaxCategory CSV file for your localization.
  • Then, import the C_Tax CSV file for your localization.

If necessary, you can create a custom CSV file or enter the categories and taxes manually. It is essential to follow this step in conjunction with the installation of the withholding plugin.