Most browsers use CTRL +/- to adjust display font size. All reports have font settings tied to column widths.
1,026 07/27/2019 03:31:18 am
Re: Arabic and other RTL ( Right to Left) languages User Interface (42 replies, posted in Translations)
1,027 07/21/2019 03:22:46 am
Re: Cannot login - extensions.php & config.php never created (3 replies, posted in Installation)
Since you are running bleeding edge PHP/MySQL, turn on debug / error_reporting and check why you are unable to install. Alternatively, run on debian 7 and then port the FA webroot and sql into debian 9.
1,028 07/20/2019 05:33:02 pm
Re: Cannot login - extensions.php & config.php never created (3 replies, posted in Installation)
Folders 755
Files 644
The missing files generally get created during installation along with some other files.
1,029 07/16/2019 03:53:56 am
Re: Date Picker close when clicked outside of the datepicker (6 replies, posted in FA Modifications)
Bootstrap implementation may have other working scripts for datepicker.
1,030 07/12/2019 03:50:42 pm
Re: Transaction References with Customer Placeholder (5 replies, posted in Accounts Receivable)
The said line 479 is:
$ref = $Refs->get_next($_SESSION['Items']->trans_type, null, array('date' => Today()));Where in it should it be added?
Any generic way to have this feature without manual intervention?
1,031 07/10/2019 03:26:28 pm
Re: Email Not Sending (1 replies, posted in Report Bugs here)
Has your hosting company recently upgraded their PHP version?
Here a few posts that address mail sending:
https://frontaccounting.com/punbb/viewtopic.php?id=6856
https://frontaccounting.com/punbb/viewtopic.php?id=5960
https://frontaccounting.com/punbb/viewtopic.php?id=5963
Some email service providers and their SMTPs now prevent insecure ports and certain attachment types.
1,032 07/09/2019 02:24:19 pm
Re: Arabic and other RTL ( Right to Left) languages User Interface (42 replies, posted in Translations)
Have a look at the translation strings in includes/dashboard.inc - these strings are in the .po file available for translation. Compare with the English versions and match the translations.
Another file of interest is reporting/includes/class.graphic.inc that is included in admin/dashboard.php.
1,033 07/09/2019 02:16:39 pm
Re: FrontAccounting Extensions Step-by-Step (2 replies, posted in Modules Add-on's)
Check out this post.
1,034 07/09/2019 02:00:32 pm
Re: Cannot download repo index file. error 2.4.6 (10 replies, posted in Report Bugs here)
Check if OpenSSL is available in your php.ini.
1,035 07/09/2019 01:59:55 pm
Re: Ways to manage real-life manufacturing scenario (4 replies, posted in Manufactoring)
The standard ratio based minimum output observed to be needed would be what the BoM would start with. Any additional issues to the manufacturing is available in the application and the actual output too may be slightly different from the envisaged output which too is manageable in FA.
1,036 07/07/2019 05:00:54 pm
Re: help HR module not working (2 replies, posted in Modules Add-on's)
Ask in this post if it is @notrinos's FrontHRM you are referring to.
Logout, clear cache and then login to the target company.
1,037 07/06/2019 03:03:40 pm
Re: Version 2.4.7: Purchases - Direct Supplier Invoice not processing (6 replies, posted in Report Bugs here)
@joe: Can we not make the field take no more than the field size in the table definition?
1,038 07/06/2019 02:24:22 pm
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
Actually the shortcuts existed in my Git Repo for your v2.4-1.
Why did the following files get removed in your GitHub Repo now:
manage/salaryscale.php
includes/db/salary_scale_db.inc
includes/ui/salary_scale_ui.incThe _init folder in modules generally do not have any index.php file but has a files file and stands updated in my repo.
View Icon Buttons do not work for Attachments.
1,039 07/06/2019 07:24:11 am
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
The pay_element table seems to be orphaned. The v1 pay_detail table is now in the plural, ie., pay_detalis.
The ERD is attached. Field names and orders, indexes and other optimisations may be in order.
1,040 07/06/2019 05:05:11 am
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
Why has the "&" keyboard shortcuts been removed in your new version in the hooks.php file?
1,041 07/04/2019 08:23:42 am
Re: Planned changes in stock_moves table structure in FA 2.5 (6 replies, posted in Development)
The said function update_stock_move() in Post #3 above is not used in any of the known extensions either now.
1,042 07/03/2019 03:55:30 am
Re: CPanel Installatron skipped versions on upgrade (5 replies, posted in Installation)
After the $xr_providers array declaration in config.php see that the line below is appropriately assigned like:
$dflt_xr_provider = 0;You can also upload the post release FA files in the announcement post. Some folders will need write permissions for the webserver user in case you get permission denied errors.
1,043 07/02/2019 05:50:44 pm
Re: Upgrade from FA 2.3.2 (5 replies, posted in Installation)
The slow response, inordinate delay and timeout is perhaps your indexes have not been set as needed and redundant indexes need to be removed. Define "Large" database - backup size for 1 year and how many years data remain open? php.ini file can be tweaked to increase the timeout.
Commercial support is available from many forum users and you can also approach those on the Support list.
1,044 07/02/2019 06:33:15 am
Re: CPanel Installatron skipped versions on upgrade (5 replies, posted in Installation)
The missing sys_prefs table records can be put in in any order and their sane default values can be found in the sql/en_US-new.sql file.
The config.php file can be compared with the new config.default.php file and the missing entries put into the former.
1,045 07/01/2019 05:11:08 pm
Re: Bank Statement Report (13 replies, posted in Reporting)
The first two parts are only re-phrased.
Ordinarily there should be no duplicates.
Besides, the tables referred to in each select are different.
But... it is possible that more than one record across the selects may refer to the same transaction causing duplicates.
1,046 07/01/2019 04:02:54 pm
Re: Bank Statement Report (13 replies, posted in Reporting)
There may be duplicate lines - maybe a DISTINCT is needed somewhere. Try to make the INNER JOIN using an ON statement rather than in WHERE like:
case ST_BANKPAYMENT :
case ST_BANKDEPOSIT :
$sql = "SELECT trans.debtor_no as person_id,
CONVERT(debtor.name using utf8) as name
FROM ".TB_PREF."debtor_trans trans INNER JOIN ".TB_PREF."debtors_master debtor USING (debtor_no)
WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
."
UNION
SELECT trans.supplier_id as person_id,
CONVERT(supp.supp_name using utf8) as name
FROM ".TB_PREF."supp_trans trans INNER JOIN ".TB_PREF."suppliers supp USING (supplier_id)
WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
."
UNION
SELECT IF (person_type_id=0, 0 ,NULL) as person_id,
IF (person_type_id=0, CONVERT(person_id using utf8),NULL) as name
FROM ".TB_PREF."bank_trans
WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type)
;
break;1,047 06/30/2019 01:49:40 pm
Re: Release 2.5. (10 replies, posted in Development)
Keeping a sys_prefs variable for the specific company's default theme choice too will be available only after login to the specific company.
Using the matched last logged in IP may suffice if fixed IPs (or net block) at the client side are there.
1,048 06/30/2019 01:44:58 pm
Re: CPanel Installatron skipped versions on upgrade (5 replies, posted in Installation)
From FA 2.4.4 to 2.4.7:
* FTP the new files
* Put in the missing sys_prefs table records
print_dialog_direct
ref_no_auto_increase
* Update the config.php file
- there are no db changes.
Don't forget to update to the latest changes after the release of FA 2.4.7 too.
The install.html and update.html files have been removed.
The files in the "install" folder will need to be deleted.
1,049 06/29/2019 02:36:46 pm
Re: Upgrade from FA 2.3.2 (5 replies, posted in Installation)
Make a separate sandbox of FA 2.3.26 first. Check if your customized connector works with it or see if it can be tweaked to achieve it.
Are there any FA files that were changed as part of the tweaking?
Are those changes now accommodated in the current FA versions?
Upgrading from FA 2.3.6 to FA 2.4.7+ should be okay if you wish to retain the old document numbering system.
Create a new sandbox for FA 2.4.7+ and see if your connector now works with and make waht tweaks are necessary to make it work.
Manually inducting in all the FA 2.3.2 data into FA 2.4.7 will be tedious but is best preferred if you have the technical skillset (DB/PHP) or have someone to assist you with it - post your bounty in the Jobs board and see who bites.
Don't fix it if it ain't broke.
1,050 06/29/2019 02:31:59 pm
Re: When purchasing an item, how to choose the cheapest supplier? (9 replies, posted in Accounts Payable)
Then, FA would need some automatic means of assimilating the current purchasing price whenever it changes from the vendor end. Something like the daily Exchange rates!