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.
2,252 12/18/2017 07:18:37 am
Re: Inventory purchasing transaction based report (19 replies, posted in Reporting)
2,253 12/18/2017 01:57:51 am
Re: New Theme (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,254 12/17/2017 05:28:13 pm
Re: DB Schema anomalies (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,255 12/17/2017 04:06:46 pm
Re: Payroll & Human Resource Management. (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,256 12/17/2017 03:36:23 pm
Re: Payroll & Human Resource Management. (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.
2,257 12/17/2017 02:47:32 pm
Re: how to increase dimension levels more than two (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.
2,258 12/17/2017 02:22:59 pm
Re: Payroll & Human Resource Management. (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?
2,259 12/17/2017 02:15:52 pm
Re: how to increase dimension levels more than two (9 replies, posted in Dimensions)
Dimensions => Dimensions Entry => keep adding several departments....
2,260 12/17/2017 04:53:33 am
Re: FA2.4.2 error getting exchange rate from Google (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.
2,261 12/17/2017 04:48:44 am
Re: Print Invoice Bug (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?
2,262 12/16/2017 06:46:01 pm
Re: FA2.4.2 error getting exchange rate from Google (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.
2,263 12/16/2017 06:40:16 pm
Re: Print Invoice Bug (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,264 12/16/2017 06:38:23 pm
Re: BarCode (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.
2,265 12/16/2017 03:05:13 pm
Topic: Prepaid Sales Order - update all charts (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).
2,266 12/16/2017 01:21:50 pm
Re: BarCode (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,267 12/16/2017 01:15:13 pm
Re: Required Delivery Date (10 replies, posted in Accounts Payable)
Any Non Cash Payment terms will show the Required Delivery Date field - see attachment.
2,268 12/16/2017 01:10:36 pm
Re: How to restrict a user changing default "Deliver from Location" (4 replies, posted in Setup)
Looks like FA has this facility by just fixing the Salesman Role's Permissions. See attachment.
2,269 12/16/2017 06:40:18 am
Topic: Config Setup Options (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,270 12/16/2017 03:12:03 am
Re: Print Invoice Bug (23 replies, posted in Report Bugs here)
This version of the Invoice Report script - rep107.php - stands committed in my FA24Mods repo.
2,271 12/16/2017 02:57:50 am
Re: How to restrict a user changing default "Deliver from Location" (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?
2,272 12/16/2017 02:51:25 am
Re: new report (21 replies, posted in Reporting)
State which report (Navigation sequence / repXXX.php number) that you want customised.
2,273 12/16/2017 02:50:10 am
Re: BarCode (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.
2,274 12/16/2017 02:45:24 am
Re: FA2.4.2 error getting exchange rate from Google (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.
2,275 12/16/2017 02:40:50 am
Re: Whats happened with Recurrent invoices? (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.