Do let us know if you intend to make it free of composer.
1,702 05/31/2018 12:56:50 am
Re: Release 2.4.4 (4 replies, posted in Announcements)
For those intending to upgrade from FA v2.4.2 directly to FA v2.4.4, the changed files zip is attached herewith. The FA 2.4.4 post release fixes will have to be added on separately afterwards from previous post. Take note of DB changes in the charts of accounts and those that pertain to fixes in the addon modules apart from the new entries in the config.inc.php (refer config.default.php changes) / sys_prefs table entries.
1,703 05/30/2018 02:04:14 pm
Re: Error in inventory valuation report (45 replies, posted in Report Bugs here)
Check if the error still occurs in a FA 2.4.4+ (GitMaster) install.
1,704 05/30/2018 02:00:16 pm
Re: Release 2.4.3 (9 replies, posted in Announcements)
Place the files from the 2.4.2 to 2.4.3 changed files in a folder. Now overwrite them with the files from the 2.4.3 to 2.4.4 changed files and then take the files from the Post 2.4.4 release changed file set and overwrite as well. Now you will have the complete set of files that are needed to bring your FA v2,4,2 up-to-date with Git Master codebase that you can use to overwrite your FA 2.4.2 install with. Any changes in the standard chart sqls can be ported to each of your companies. Mostly records in the sys_prefs table.
Refer this post.
1,705 05/27/2018 11:19:35 am
Re: Approval System for GL Postings Demo and SourceCode (30 replies, posted in FA Modifications)
Do not forget to consider that the document number will be checked only in the core tables and not in the extra tables. You may land up accumulating "yet to be approved" entries in the new table - possibly all with the same document number!
1,706 05/27/2018 03:32:21 am
Re: Opencart sync / integration to FrontAccounting (6 replies, posted in Jobs wanted/offered, non-free offers)
Post your specifics and the bounty for it and hopefully someone will take it up. Alternatively, learn the ropes.
1,707 05/26/2018 04:35:07 pm
Re: Unable to cancel a sales order (5 replies, posted in Accounts Receivable)
@joe: any filters in the sql(s) that are needed to be tweaked?
1,708 05/25/2018 02:07:34 am
Re: Update google url for currency converter (13 replies, posted in Report Bugs here)
For those using FA 2.3.x - this will need to be backported.
Looks like this has been so for a couple of months atleast:
1,709 05/25/2018 02:05:45 am
Re: Where do I find Report items stagnant & Report the best-selling items (6 replies, posted in Reporting)
Post a mockup of what you want.
1,710 05/24/2018 04:09:28 am
Re: Where do I find Report items stagnant & Report the best-selling items (6 replies, posted in Reporting)
Create an SQL for it and then add an icon to one of the listings or make a custom report. May be present in some dashboard widgets.
1,711 05/24/2018 04:07:25 am
Re: invoice template adding more info (5 replies, posted in Reporting)
Choose a valid theme made for the Mobile Browser?
What are these numbers?
1,712 05/23/2018 04:37:08 am
Re: How to manage personal expenses with budget? (2 replies, posted in Banking and General Ledger)
FA supports sub-ledger concept.
1,713 05/22/2018 05:34:15 pm
Re: invoice template adding more info (5 replies, posted in Reporting)
Made for FireFox
Post versions of both browsers and your FA version too.
1,714 05/21/2018 01:32:53 pm
Re: Load denied by X-Frame-Options (1 replies, posted in Installation)
Thanks @PaulShipley.
Apache 2.4 config for https:
<virtualhost *:443>
ServerName fa24.local
DocumentRoot "C:\Users\shipl\htdocs\fa24"
<directory "C:\Users\shipl\htdocs\fa24">
Options Indexes FollowSymLinks Includes ExecCGI
AllowOverride All
Require all granted
SSLRequireSSL
</directory>
Header always set X-Frame-Options SAMEORIGIN
SSLEngine on
SSLCertificateFile "C:\Apps\xampp\apache\conf\ssl.crt\fa-selfsigned.crt"
SSLCertificateKeyFile "C:\Apps\xampp\apache\conf\ssl.key\fa-selfsigned.key"
</virtualhost>
1,715 05/20/2018 07:50:55 pm
Re: Approval System for GL Postings Demo and SourceCode (30 replies, posted in FA Modifications)
To make it easy for integration in FA, provide the changed files alone or the diff file.
Also you made changes to the database schema / records (sys_prefs)? There is an extra flag field in the users table called "allow_direct_posting" and db version bumped to v2.4.2 in version.php but not changed in the sql files.
You have also added another user function get_user_real_name().
@joe: nice addition to FA - please check it out. It certainly affects the "DB Schema Freeze" policy.
1,716 05/19/2018 12:36:27 pm
Re: Restrict user from editing own entries (7 replies, posted in Setup)
Not that I know of.
1,717 05/19/2018 12:34:43 pm
Re: Setup DB Connection Error (37 replies, posted in Installation)
If the db was created earlier and assigned to the specific FA user, then the grant permission is not needed. It is quite insecure too.
1,718 05/18/2018 03:40:06 pm
Re: Account Number (6 replies, posted in Wish List)
A simple php file can be created to interface with your PBX, extract the caller id, lookup FA crm files for the contact's number and extract the customer id and then call up the ledger folio record for the customer using the appropriate FA link with it in the URL. That way a pop up will get triggered when a call is answered (eg., AsteriskPBX). For vTigerCRM, this is done in my vTiger repo on GitHub for interfacing with AsteriskPBX.
1,719 05/18/2018 03:35:38 pm
Re: Aged Customer Analysis vs Customer Balance (Same Period) (5 replies, posted in Accounts Receivable)
@joe: any ideas / verification?
1,720 05/18/2018 03:33:59 pm
Re: Migration from Sage to FrontAccounting (5 replies, posted in Setup)
CSV / Excel data can be parsed into MySQL.
To make sense of any application working with any db, take a sql backup of the schema, data and then make one transaction of each type in turn taking backups of the data each time and study the differences and you will then discern which table/fields have been affected (insert/update/delete). Then build an ERD from it.
1,721 05/18/2018 03:29:39 pm
Re: Setup DB Connection Error (37 replies, posted in Installation)
It appears that your MySQL server is running on one collation/character set and your client connection is running on another whilst your action FA connection is trying to change the connection characteristics.
ALTER DATABASE <database_name> CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Refer article.
Your connection appears to be anonymous and not from a specific user with password.
1,722 05/17/2018 02:43:05 pm
Re: Aged Customer Analysis vs Customer Balance (Same Period) (5 replies, posted in Accounts Receivable)
FA 2.4.3 was released on 2017-11-10. Since then there have been several updates and it is possible that one or more of them may fix your issue even if it is not the repXXX file itself but it's dependencies.
The Aged Customer Analysis report is in reporting/rep102.php.
The said report file was last changed on 2017-03-18 and hence look for the functions and includes it uses and see if any changes in them would fix your issue.
1,723 05/17/2018 02:34:13 pm
Re: Add new column in for direct invoice (1 replies, posted in FA Modifications)
Which table did you add the extra columns?
Have you modified the necessary SQL to include your new fields in the functions used to extract the line items referred to?
Do they bear the same name as fields in other related tables?
Make sure you provide all version details of all pertinent items - FA, PHP, MySQL, Platform, etc.
Post a bounty in the Job offers board and see if anyone is willing to assist.
1,724 05/17/2018 07:54:43 am
Re: No access to one of several companies (3 replies, posted in Installation)
It is possible that your password may have changed. All passwords are MD5 hash of the plain text password stored in the users table.
1,725 05/17/2018 07:53:35 am
Re: Current date on invoices (7 replies, posted in Setup)
Which version of FA are you using and what versions of PHP / MySQL and Platform (Windows/Linux)? Unless you provide this info, we cannot fathom where the problem lies. It is possible that some reports had errors during it's evolution.
The said date 02-12-2018 happens to be the date on which the invoice was issued (and not the date they had it delivered / ordered). The date when they "purchased" the products will mean different connotations to different points of view.