The files are put in appropriate folders in the attachment.
@joe: want to add it into the FA 2.4.x core itself as it only uses the phone and phone2 fields of the crm_contacts table with no other changes?
1,026 09/03/2019 03:08:14 pm
Re: Search Customers, Suppliers by Phones (1 replies, posted in Development)
1,027 09/03/2019 02:49:55 pm
Re: Problem with supplier invoice transaction date (6 replies, posted in Accounts Payable)
The sys_prefs table record for gl_closing_date is set in the function close_transactions() in the file includes/db/audit_train_db.inc.
update_company_prefs(array('gl_closing_date'=> date2sql($todate)));1,028 09/02/2019 01:34:47 pm
Re: Website Transfer. (7 replies, posted in Announcements)
Anyone who wants to follow FA 2.5 can use the unstable branch to fork and work on. We already have a PHP 7 branch that is stuck at 2017-11-06.
1,029 09/01/2019 02:59:19 pm
Re: Handling Access Setup for Version2 of a Module (6 replies, posted in Modules Add-on's)
Wonder if the constants are case sensitive and can contain numbers - SS_CLEARINGINVOICEv2
FA cleverly manages to get new sequential values if existing ones are occupied (105).
105 * 256 (shift left 8) = 38400.
Obviously you have tried to install, remove and re-install the module several times.
Try it on a fresh FA install with no other module and see what comes of it.
1,030 09/01/2019 06:16:58 am
Re: Enter Purchase Order Items In Supplier Units (10 replies, posted in Wish List)
@joe: must this fix be incorporated in the stable version atleast now?
1,031 09/01/2019 06:05:57 am
Re: Handling Access Setup for Version2 of a Module (6 replies, posted in Modules Add-on's)
Version 2 should be a new module (with it's own distinct name) in your case as you want to have both versions concurrently with only a subset using the new version. A separate script in your new version module must independently migrate the security settings as needed or have it set anew in it.
1,032 09/01/2019 06:02:14 am
Re: Prepayment Invoicing (6 replies, posted in Accounts Receivable)
When adhoc amounts are paid into the credit of a customer, then it should be allocated to the appropriate invoice desired. This should be done as Customer Payments instead of just as Journal / Bank entries.
1,033 08/29/2019 06:03:59 pm
Re: Prepaid Sales Order Error: Pre-payment required have to be positive... (25 replies, posted in Accounts Receivable)
Investigate at point of display if the user decimals kicks in.
1,034 08/29/2019 06:02:51 pm
Re: Bug in rep102.php (5 replies, posted in Reporting)
FA 2.5 is the unstable branch of the SF / GitHub repos:
https://github.com/FrontAccountingERP/FA/commits/unstable
Blue Line in https://sourceforge.net/p/frontaccounting/git/commit_browser
My Unofficial Repo: https://github.com/apmuthu/frontac25
1,035 08/29/2019 03:04:07 pm
Re: Prepaid Sales Order Error: Pre-payment required have to be positive... (25 replies, posted in Accounts Receivable)
PHP Version?
Some have rounding errors.
Increase precision to 17 from default 14 in php.ini.
1,036 08/29/2019 02:48:04 pm
Re: Bug in rep102.php (5 replies, posted in Reporting)
Since FA 2.4 is getting trivial fixes, this can go into it and then get pulled in to FA 2.5.
1,037 08/25/2019 03:02:23 pm
Re: Why are database values converted to HTML? (4 replies, posted in Report Bugs here)
Please note that this was done when escaping was really long winded in the old days 10 years or more ago with having to carryover large number of users from PHP 4 and MySQL 3.x.
Also a multitude of languages cause quite some heartache across linux/windows platforms that all this was cobbled together with least pain. The forum is replete with such legacy issues.
Possibly in FA v2.5, better HTML escaping and accommodation of HTML encoding / decoding will be implemented.
Nice to have such experienced users like yourself pitch in. Please study the code as it evolves and make suggestions that hopefully will not break existing users installs.
1,038 08/25/2019 02:56:55 pm
Re: Release 2.4.7 (3 replies, posted in Announcements)
As of 2019-08-19, the FA 2.5 repo has been started as the current unstable branch.
The FA 2.5 is now complemented with it's own unofficial repo.
1,039 08/25/2019 01:26:13 pm
Re: Why are database values converted to HTML? (4 replies, posted in Report Bugs here)
We do not want code to be executable like "Bennet Cole &$var Co" where $var can be a malicious bit of code change.
1,040 08/25/2019 01:23:48 pm
Re: Database Prefix vs No Database Prefix? (4 replies, posted in Setup)
User variables can be used to some extent in MySQL but it does not work for table names.
1,041 08/25/2019 01:22:15 pm
Re: Bug in rep102.php (5 replies, posted in Reporting)
@joe: If such allocations are not accounted for, we need to update the wiki accordingly - or is a fix slated for it in 2.5?
Check the code flow on value of $all in the get_invoices() function in the report.
1,042 08/25/2019 01:21:15 pm
Re: Working on an extension for invoicing and I have questions... (4 replies, posted in FA Modifications)
@joe: any fix needed here or for 2.5?
1,043 08/23/2019 09:53:11 am
Re: Problem with supplier invoice transaction date (6 replies, posted in Accounts Payable)
As SA_MULTIFISCALYEARS has been enabled (logged out and logged in again after clearing browser cache), verify the setting is saved in Setup => Access Setup => Role: System Administrator (Role of logged in user).
The function that allows Suppliers, Customers and Items to be entered in older fiscal years is defined in admin/db/fiscalyears_db.inc is is_date_in_fiscalyears() and is used in the function is_date_in_fiscalyear() defined in includes/date_functions.inc where the first said file is "include"d.
Inspect the variables at that point in Line 204 of the last file stated above. The function user_check_access() is defined in includes/current_user.inc file.
Scope, availability and visibility of the variables and their values will be of use in investigating it. If all is well, then scour the scripts that use these values before "post"ing the updated values to the db.
1,044 08/23/2019 08:33:16 am
Re: Transaction References with Customer Placeholder (5 replies, posted in Accounts Receivable)
@itronics: must this now be added into the core?
1,045 08/23/2019 08:32:59 am
Re: Transaction References with Customer Placeholder (5 replies, posted in Accounts Receivable)
@itronics: must this now be added into the core?
1,046 08/23/2019 08:23:50 am
Re: Database Prefix vs No Database Prefix? (4 replies, posted in Setup)
Restoring from a wrong company's backup will limit / avoid data loss if separate prefixes are used.
Also, you can use multiple databases - one for each company - if there is no limitation on your hosting plan.
If the same mysql server hosts both databases, then getting consolidated reports from both database tables is possible and the table prefixes can help avoid using database name prefixes in the field names.
1,047 08/23/2019 08:17:22 am
Re: Problem with supplier invoice transaction date (6 replies, posted in Accounts Payable)
Switch active fiscal to previous fiscal in Setup => Company Setup temporarily for the change to be done.
1,048 08/23/2019 08:13:44 am
Re: Bank reconciliation and Bank Account Inquiry and Bank reports (6 replies, posted in Banking and General Ledger)
The affected report reporting/rep602.php was last changed in 2016-09-06 and that too for only a column width change. However, it's include files may have changed since then.
Upgrading to FA v2.4.7+ is trivial as there are no real DB changes.
1,049 08/23/2019 08:04:04 am
Re: Supplier's Description of an Item resets to default defined in system. (16 replies, posted in Items and Inventory)
@poncho1234: This may not be tenable this way as the checkbox for Editable Description can be changed independant of the specific transaction at any time. However, if it is implemented by checking f a change in standard description from the one used in the PO, then any inadvertent change there may get reflected in the Supplier Invoice without notice - hence a prudent way was sought in the current implementation where a human re-check is envisaged before finalisation.
1,050 08/19/2019 05:01:00 pm
Re: Some changes in add_supp_invoice to reduce unnecessary query run time (9 replies, posted in FA Modifications)
Forecasting from how many years it took to come in from FA 2.3 to FA 2.4 and the fact that the devs are much older now, take it to be atleast 5 years from when the initial 2.5 branch began. If it is any sooner, thank the advances in coding technologies and that we are now older and wiser ![]()
@kvvaradha: Whatever changes you have in mind to make a start, do let us know here so that it can atleast get into the codebase for those who wish to benefit from it in the meanwhile and form part of FA 2.5 if and when it appears.
Aug 17th 2019 - probably last commit to the 2.4(.7) branch.
Aug 19th 2019 - first commit to merge stable into unstable for 2.5 branch
