2,201 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,202 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,203 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,204 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,205 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,206 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,207 Reply by apmuthu

(9 replies, posted in Dimensions)

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

Go to forum: Dimensions

2,208 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,209 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,210 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,211 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,212 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,213 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,214 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,215 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,216 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,217 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,218 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,219 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

2,220 Reply by apmuthu

(21 replies, posted in Reporting)

State which report (Navigation sequence / repXXX.php number) that you want customised.

Go to forum: Reporting

2,221 Reply by apmuthu

(13 replies, posted in Reporting)

Use the FA Master 2.4.3+ as it stands included in the core now. If you already have a v2.4.3 install, then update it with the changed files since release from the Announcements post for the release.

Go to forum: Reporting

2,222 Reply by apmuthu

(55 replies, posted in Report Bugs here)

Then Google must be playing random tricks for your IP range....
Their search results have become very diluted in the last 6 months or so.
Time for a brand new human vetted one sans corporate control.
I will revert when I ave a new test OpenVZ install ready.
You can PM me a temporary PPTP VPN for your ISP for me to test.

Go to forum: Report Bugs here

2,223 Reply by apmuthu

(24 replies, posted in Accounts Receivable)

When days = -1 and the day of the last sent date is 29, 30 and 31 which are part of valid dates after computation of $next if they become the last day of that month, this is what is desirable. If however, those $next dates are not valid, then they should be pushed to the last day of that month. The Karnaugh map of this logic on reduction just means irrespective of the day part of the last sent date, just push it to the last day of the computed $next date. he question is that how is the computation of the $next date to be undertaken for edge conditions. The "-1" according to the wiki is just a token to indicate the last date of the previous month as the $next date - so what is the logic needed to code it that way so that it will not have to rely on hindsight.

Go to forum: Accounts Receivable

2,224 Reply by apmuthu

(23 replies, posted in Report Bugs here)

The customer filter remains so even in my code but does that determine the currency as well? Anyone using the filters, be it customer and / or currency will know what to expect of the results of the output subset. The changes in the code here will not affect any other report as it is localised only.

Yes, it is not a big deal. We can leave it as is and the code here can be used at will by those who need it - maybe I will put it in my FA24Mods.....

Go to forum: Report Bugs here

2,225 Reply by apmuthu

(23 replies, posted in Report Bugs here)

There is no major change to this file. Just a currency filter in the where statement and an extra table join for it and that too only when the currency is chosen.

Go to forum: Report Bugs here