Before installing afresh, you will have to empty the database of all it's tables (which you have done) as well besides removing the various files that get re-created on any install:
config.php,
config_db.php,
installed_extensions.php (both in the webroot and in each company# folder) and
lang/installed_languages.inc file.
2,851 07/18/2017 04:58:44 pm
Re: Complete removal and reinstall (1 replies, posted in Installation)
2,852 07/18/2017 04:55:58 pm
Re: Template invoice (1 replies, posted in Reporting)
You will have to re-design the invoice to suit the width of the thermal printer. The invoice file is reporting/rep107.php.
2,853 07/18/2017 01:25:23 am
Re: Bank Statement (3 replies, posted in Reporting)
Plain Vanilla install of Git Master FA 2.4.1 with demo data and Bank Statement has empty PersonID instead of "Goods Received". See Attachment.
@joe: Please provide demo company bank statement from your install if different. The demo data simple does not have the said description in any table other than bank_trans and the data acquisition function does not get it from there.
2,854 07/16/2017 08:35:07 pm
Re: Bank Statement (3 replies, posted in Reporting)
It is available in the Bank Transaction Query.
The Bank Statement Report is in reporting/rep601.php.
The field bank_trans.person_id has the necessary person_id value of "Goods Received" in the attachment.
The report gets the Person_id info from the function get_counterparty_name() defined in admin/db/transactions_db.inc. This function does not reference the bank_trans table at all.
Hence we can assume that all internal allocations like "Goods received" from Purchases into Stock Inventory will not have any entry for the Person ID field in this report. The 'type' is listed as 1 in the bank_trans table for such transactions.
@joe: must this be addressed in the code?
2,855 07/16/2017 08:26:20 pm
Re: Print query with image (7 replies, posted in Reporting)
The actual code inserts can be seen in the attachment.
2,856 07/16/2017 07:44:50 pm
Re: Print query with image (7 replies, posted in Reporting)
Assume you are using FA 2.4.1.
The file gl/view/gl_trans_view.php provides the query view and it has the print link and can be modified by adding after line (for header image):
$credit = $debit = 0;
the line with your header image like:
echo "<center><img src='https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcR_KUCneY0HSb36I6iUoilKd42Kk9RH0ywVvtxlZwhZQ5zVHdDw' width='60%'></center>";
and at the end of the if statement (for footer image):
if ($heading_shown)
the following line with your footer image like:
echo "<center><img src='http://files.photografy-edicoes.webnode.com/200000818-e5968e690c/banner%203.png' width='60%'></center>";
2,857 07/16/2017 01:46:37 am
Re: font report (5 replies, posted in Reporting)
Choose Arial Unicode - ARIALUNI.TTF - it will be available in all windows machines at mostly C:\WINDOWS\FONTS folder.
2,858 07/13/2017 03:17:56 am
Re: font report (5 replies, posted in Reporting)
In the reporting/rep###.php files, use something like:
$rep->fontSize += 2;
and then revert back with
$rep->fontSize -= 2;
2,859 07/11/2017 11:15:00 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
As FA 2.4.1 has just been released officially a few weeks ago, the extensions will need time to be tested for compatibility. My unofficial repo has the individual files only and they will need to be manually installed till they get into the official pkg repo.
There are other issues in getting this module to work in FA 2.4.x FA installs that are being worked upon. @braathwaate's fork of the unofficial FA24 extensions repo has some developments you may wish to partake of.
2,860 07/11/2017 12:26:22 am
Re: Yet another problem with utf-8 (22 replies, posted in Report Bugs here)
RFC 5336 - SMTP Extension for Internationalized Email Addresses.
IMAP
====
if (extension_loaded('imap')) {
....
....
}
2,861 07/10/2017 02:25:47 pm
Re: Print query with image (7 replies, posted in Reporting)
Provide Menu Navigation steps to to get your image. Also provide image for what you need it to be. English screenshot and mockup will be useful.
2,862 07/10/2017 02:17:32 pm
Re: Import Transactions (154 replies, posted in Modules Add-on's)
The popup problem has been sorted out.
All FA 2.4.x extensions are in my unofficial repo. Fork it and get your developers to work on them and submit pull requests to incorporate them in the upstream.
2,863 07/09/2017 09:27:03 am
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
Sub Ledger may be a way out.
2,864 07/09/2017 02:15:48 am
Re: COA with 25 digits (4 replies, posted in FA Modifications)
Scarce screen real-estate will dictate the displayability of the 25 character account code. Enabling Alpha account codes in the config.php may be the solution to large number of account codes.
2,865 07/09/2017 02:13:28 am
Re: reminders in 2.4 (19 replies, posted in Setup)
Hence using the wrapper function user_use_date_picker() obviates the need to globalise $SysPrefs here.
Thanks.
Please update the extensions for FA 2.4.1.
2,866 07/09/2017 02:11:30 am
Re: font report (5 replies, posted in Reporting)
https://frontaccounting.com/punbb/viewtopic.php?id=3688
https://frontaccounting.com/fawiki/index.php?n=Help.InstallUpdateLanugages
https://frontaccounting.com/punbb/viewtopic.php?id=6780
2,867 07/09/2017 02:02:51 am
Re: erorr direct invoice (1 replies, posted in Items and Inventory)
Setup -> Display Setup -> Show Item Codes: (Uncheck).
2,868 07/09/2017 01:58:11 am
Re: osCommerce Order and Customer Import Module (8 replies, posted in Modules Add-on's)
The corrections have been ported to the FA v2.4.1's module osc_orders.
Check the commits on this fork as well.
2,869 07/08/2017 04:16:10 pm
Re: Yet another problem with utf-8 (22 replies, posted in Report Bugs here)
@joe?
2,870 07/08/2017 04:14:35 pm
Re: reminders in 2.4 (19 replies, posted in Setup)
The variable $use_date_picker is not in the config.default.php file in FA 2.4.1+.
2,871 07/08/2017 05:20:33 am
Re: Release 2.4.1 (9 replies, posted in Announcements)
All fixes since release of FA 2.4.1 are attached herewith as of 2017-07-21.
All FA 2.4.1 extensions are at:
https://github.com/apmuthu/FA24extensions
2,872 07/08/2017 05:14:40 am
Re: Vietnamese Translations added to FAMods (1 replies, posted in Translations)
The complete Vietnamese Install Language has been added to FAMods for FA v2.4.1.
2,873 07/08/2017 04:23:04 am
Re: COA with 25 digits (4 replies, posted in FA Modifications)
Approximately 16 bytes are necessary to store 25 decimal digit number (number of bytes length of 10^26 converted to Hex). Hence without changing the field size, you can store and retrieve the nearly 25 digit number when passed through Hex to dec conversion and vice-versa or have a trigger to do so in the database on the fly. USING a higher base than 16 would bring the field width down further.
2,874 07/08/2017 04:16:39 am
Re: Yet another problem with utf-8 (22 replies, posted in Report Bugs here)
From the same link:
You might want to use mb_send_mail(). It uses mail() internally, but encodes subject and body of the message automatically. Again, use with care.
The mb_encode_mimeheader() method is also listed.
2,875 07/07/2017 05:50:34 pm
Re: Yet another problem with utf-8 (22 replies, posted in Report Bugs here)
The db collation (utf8_unicode_ci) is different from the connection collation (utf8mb4_unicode_ci).
Try some url encoding.
Use the quoted string format:
"psicopedagógico"@gmail.com