2,251 Reply by apmuthu

(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

Go to forum: Installation

2,252 Reply by apmuthu

(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?

Go to forum: Accounts Receivable

2,253 Reply by apmuthu

(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?

Go to forum: Accounts Receivable

2,254 Reply by apmuthu

(5 replies, posted in Banking and General Ledger)

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.

Go to forum: Banking and General Ledger

2,255 Reply by apmuthu

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

Go to forum: Reporting

2,256 Reply by apmuthu

(19 replies, posted in Reporting)

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

Go to forum: Reporting

2,257 Reply by apmuthu

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

Go to forum: Jobs wanted/offered, non-free offers

2,258 Reply by apmuthu

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

Go to forum: Setup

2,259 Reply by apmuthu

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

Go to forum: Modules Add-on's

2,260 Reply by apmuthu

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

Go to forum: Modules Add-on's

2,261 Reply by apmuthu

(9 replies, posted in Dimensions)

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

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

Go to forum: Dimensions

2,262 Reply by apmuthu

(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?

Go to forum: Modules Add-on's

2,263 Reply by apmuthu

(9 replies, posted in Dimensions)

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

Go to forum: Dimensions

2,264 Reply by apmuthu

(55 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

2,265 Reply by apmuthu

(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?

Go to forum: Report Bugs here

2,266 Reply by apmuthu

(55 replies, posted in Report Bugs here)

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.

Go to forum: Report Bugs here

2,267 Reply by apmuthu

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

Go to forum: Report Bugs here

2,268 Reply by apmuthu

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

Go to forum: Reporting

2,269 Topic by apmuthu

(0 replies, posted in Accounts Receivable)

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

Go to forum: Accounts Receivable

2,270 Reply by apmuthu

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

Go to forum: Reporting

2,271 Reply by apmuthu

(10 replies, posted in Accounts Payable)

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

Go to forum: Accounts Payable

2,272 Reply by apmuthu

(4 replies, posted in Setup)

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

Go to forum: Setup

2,273 Topic by apmuthu

(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

Go to forum: Setup

2,274 Reply by apmuthu

(23 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

2,275 Reply by apmuthu

(4 replies, posted in Setup)

Currently FA does not have such a filter.

@joe: Another new field in the user's table changeable by the admin or other empowered user roles?

Go to forum: Setup