Search options (Page 68 of 245)

Post a mockup of what you want.

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

Made for FireFox

Post versions of both browsers and your FA version too.

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.

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.

@joe: any ideas / verification?

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.

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.

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.

That is the date on which the invoice was created. It is not the financial year date.
If you want the "printed on" date, then just add that line to the footer of the invoice as stated in the wiki.

The invoice data is the legal on on which it is accepted to get into the books of account and not the printed on date which can be done any number of times anytime.

Do you mean prefixing the Account Number to the Account Name in search results?

Have a look at the attachment in my previous post. The Invoice Sales Date is used in 2 places. I do not see any Financial Year Date. Which version of FA are you using and what versions of PHP / MySQL and Platform (Windows/Linux)?