Where is it hosted?
1,727 06/01/2018 03:19:41 am
Re: FA REST API (6 replies, posted in Modules Add-on's)
Will it not be better to include the SlimAPI files and do away with composer so as to make it self-contained?
1,728 05/31/2018 04:14:22 pm
Re: Class Vs Category (1 replies, posted in Fixed Assets)
Read the Fixed Assets Wiki.
1,729 05/31/2018 04:05:52 pm
Re: FA REST API (6 replies, posted in Modules Add-on's)
Do let us know if you intend to make it free of composer.
1,730 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,731 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,732 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,733 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,734 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,735 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,736 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,737 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,738 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,739 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,740 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,741 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,742 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,743 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,744 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,745 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,746 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,747 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,748 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,749 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,750 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.
