P&L is calculated at the end of the year by taking the balance of all expense and income accounts and stock differentials and then auto inserted. Only the Trial Balance and computed P&L are used during the year in a similar manner. What you want is a hierarchy of P&L accounts in the Accounts Master. You are free to change the nomenclature for the Account Classes, Account Groups and Account heads.

Since most non African FA users are not familiar with the OHADA implementation, I had to look it up and provide some links for others to evaluate and advise quickly.
Look up the FA users list and see if any are from your region willing to assist.

Alternatively, upload an excel sheet of your current OHADA accounts master and their desired classification and provide the link here to assist others to advise.

@joe: Providing a native OHADA Chart would increase the FA footprint into West and Central Africa tremendously.

2,227

(1 replies, posted in Installation)

https://blog.remibergsma.com/2012/07/10/setting-locales-correctly-on-mac-osx-terminal-application/
https://apple.stackexchange.com/questions/245287/how-can-i-install-es-ar-locale-on-osx-el-capitan
https://serverfault.com/questions/453239/is-it-possible-to-install-a-new-locale-on-mac-os-x-server
https://stackoverflow.com/questions/9991603/add-a-locale-in-mac-osx

2,228

(28 replies, posted in Accounts Receivable)

What is the standard procedure to include it in the invoice? Must we edit it like here or in the repXXX file in any different way? Should it be some choice in the company setup as candidates for the sys_prefs table?

2,229

(28 replies, posted in Accounts Receivable)

@rafat: FA now uses Sourceforge's Git and is mirrored on GitHub.

If the price hook exists for your locale, then it would automatically come. Only otherwise will the rest of the function price_in_words be executed when the default for the Invoices is needed to be overridden by my mod.

A more elegant mod version for Line 865 would be:

if (!in_array($document, array(ST_SUPPAYMENT, ST_CUSTPAYMENT, ST_CHEQUE, ST_SALESINVOICE))

The function price_in_words() that finally gets invoked if present is available as a skeleton in lang/new_language_template/locale.inc.

@joe: any reason why the Invoice did not default to the words like the others?

Start from a blank chart master, chart class and chart groups set of tables and manually put in whatever classification you want. You can nest the Group's Accounts as well as desired to get your OHADA CoA.

In your parlance, you mean that your "fiscal result" other than income tax is FA's native P&L account. All the others can be nested in the P&L.

From Wikipedia:

OHADA is a system of corporate law and implementing institutions adopted by seventeen West and Central African nations in 1993 in Port Louis, Mauritius. OHADA is the acronym for the French "Organisation pour l'harmonisation en Afrique du droit des affaires", which translates into English as "Organisation for the Harmonization of Corporate Law in Africa".

ODOO Apps supports OHADA natively and is developed on GitHub, being based on Python.
This French Article may be useful.
Will this CoA meet your needs?
OHADA Accounting Plans

See the wiki for more info.

2,231

(3 replies, posted in Reporting)

Check if you have the OpenSSL extension enabled in your php.ini file and if you uncommented out the dll / so file, restart the webserver.

The report stands corrected and committed into the core now as rep310.php.

2,233

(5 replies, posted in Jobs wanted/offered, non-free offers)

It is advisable to update from FA v2.3.21 to FA 2.3.26 and then choose a theme from there. If you have heavily modified your FA install and / or depend on some extensions, you may need to tweak any theme to suit your needs. If you use any language other than English, the CSS and other column/row spacing may need to be adjusted as well.

There are no DB changes worth mentioning that affect an installation for this upgrade as far as the core is concerned and no extensions that alter the core tables / files are used.

The changed files are attached herein. If you do commission anyone to write a theme for you, it will be good to share it with the community.

2,234

(5 replies, posted in Setup)

MySQL Bugs #13794 TEXT cannot use empty string as default value

(It is) not a bug.
It is caused by the configuration file automatically generated by the configuration tool under Windows.
In the my.ini, sql-mode is set to STRICT_TRANS_TABLES by default, which causes this error.

2,235

(216 replies, posted in Modules Add-on's)

Created and attached an ERD as it stands now.

There are foreign keys such as department_id, pay_rule_id and payslip_no that have no proper linked tables for lookup.

In case the payslip_no should be the primary key, then the id field in that table (0_payslip_detail) can be removed.

There is no linkage with the account_id to any of the other FrontHRM tables.

Where is the emp_id linkage into the 0_payslip_detail table?

Gender can be an enum filed with M, F and O option set.

You can include the ERD into your codebase.

2,236

(216 replies, posted in Modules Add-on's)

@notrinos: Thanks for the info.

The table 0_salary_structure can remove the type field by using the signed nature of the amount field or if it is to be a flag, then an is_deduction field can replace it.

Was this necessary:

ALTER TABLE `0_gl_trans` ADD `payslip_no` INT(11) NOT NULL DEFAULT 0;

in the update.sql?
Could it not be looked up based on transaction date and employee code?
If the core FA table changes are avoided, it will be more portable.

Dimensions are not nestable.
You can create dimensions elements like 201703stt0120, 201703sdss022, etc.

If you wish to track transactions then use the Tag feature.

2,238

(216 replies, posted in Modules Add-on's)

These lines in the README.md:

- Comment out block of codes from lines 215 to 220 of "*admin/inst_module.php*".
..
..
- Uncomment lines 215-220 of "*admin/inst_module.php*".

are no longer required after this commit on 2017-12-15.

Added to the FA24extensions repo.

If your new table 0_payroll_account is intended to have just 1 record, can it not be accommodated in the 0_sys_prefs table?

Dimensions => Dimensions Entry => keep adding several departments....

Bloomberg seems to provide USD based rates only. Will check on Google decimal digits since inverted value is available for reverse rates.

2,241

(23 replies, posted in Report Bugs here)

Is there a weblink / service / CSV available for middle rates for each day - archives of exchange rates - so that when a date range for a currency pair is requested, it can provide rates to populate the FA exchange rates table directly for that entire period. Also for rare significant rate changes, can the last populated rate not be taken instead?

document.write is used only in lines 1438 and 1439 in includes/ui/ui_view.inc.
This affects the js_cache which you may choose to purge from the company folder.

2,243

(23 replies, posted in Report Bugs here)

Better still, populate the exchange rate for the currency desired into the exchange rates table for every day in the year.

2,244

(13 replies, posted in Reporting)

Then if we need to suppress the barcodes in the reports, we need to disable the  'use barcode on stocks' if set in company setup temporarily! Wouldn't it be better to have a parameter in the report request form for this?

Updated the Wiki accordingly.

Pre-Requisites for a Prepaid Order

*  Add a Prepayment type Payment Terms in Sales => Payment Terms page
* Create a Deferred Income Account in the Chart Master under Current Liabilities if one does not exist, say in the Standard CoA's as 2105
* Choose this Deferred Income Account in the Banking and GL Setup page under the same head.

Now we can make a Sales Order with the Payment Terms as Prepayment, accept payments for it and then invoice the Prepaid Order.

Deferred Income Account

As on date, none of the official Charts of Accounts including the Standard ones have a Prepaid Type Payment Term and Deferred Income Account by default.

Deferred revenue is not yet revenue. It is an amount that was received by a company in advance of earning it. The amount unearned (and therefore deferred) as of the date of the financial statements should be reported as a liability. The title of the liability account might be Unearned Revenues or Deferred Revenues.

The Wiki has been updated.
My FA24Mods repo stands committed.

@joe: Please add in the Prepaid Type in the list of available Payment Terms along with a Current Liability type Account 2105 - Deferred Income Account - in all the charts (Standard and official packages).

2,246

(13 replies, posted in Reporting)

This happens when the "Show Pictures" is set to "Yes" in the rep303 (Stock Check Sheets) form.

@Foreign Item Codes cannot have the barcodes that we generate/provide - they must follow what the supplier provides.

2,247

(10 replies, posted in Accounts Payable)

Any Non Cash Payment terms will show the Required Delivery Date field - see attachment.

Looks like FA has this facility by just fixing the Salesman Role's Permissions. See attachment.

2,249

(10 replies, posted in Setup)

The Wiki has pages that list and explain the config.php (Site wide) file and sys_prefs (Company Specific) table settings.

These and various settings are available for the most part from within the FA user interface from the following pages:
1. Setup -> Company Setup
2. Setup -> Display Setup / Preferences
3. GL -> GL Setup

2,250

(23 replies, posted in Report Bugs here)

This version of the Invoice Report script - rep107.php - stands committed in my FA24Mods repo.