1,701

(6 replies, posted in Modules Add-on's)

Do let us know if you intend to make it free of composer.

1,702

(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.

Check if the error still occurs in a FA 2.4.4+ (GitMaster) install.

1,704

(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.

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!

Post your specifics and the bounty for it and hopefully someone will take it up. Alternatively, learn the ropes.

1,707

(5 replies, posted in Accounts Receivable)

@joe: any filters in the sql(s) that are needed to be tweaked?

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:

Post a mockup of what you want.

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

(5 replies, posted in Reporting)

Choose a valid theme made for the Mobile Browser?
What are these numbers?

FA supports sub-ledger concept.

1,713

(5 replies, posted in Reporting)

Made for FireFox wink

Post versions of both browsers and your FA version too.

1,714

(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>

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

(7 replies, posted in Setup)

Not that I know of.

1,717

(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

(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.

@joe: any ideas / verification?

1,720

(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

(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.

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.

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

(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

(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.