Search options (Page 70 of 246)

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)?

Take full P&L (rep707.php) as one report.
Take only Dimension 2 in another report.
Now use the difference

Alternatively, make a temporary modification to the SQL in the report file and invert the logic to get all but dimension 2. $_POST['PARAM_3'] > 0 && isset($_POST['PARAM_9']) && !(isset($_POST['PARAM_10']) will be for the presence of a single dimension.

If you intend to depreciate it as a block, treat them all as one asset - a block of assets rolled into one.

Some hosts require a 755 permission for all files and folders to be visible on the web. This could be some SELinux setting.

The said theme is AdminLTE and is on Github.

PDF docs may look unprofessional if they have others branding on it much like a "Trial" watermark on them or "Printed by Big Printers, Timbuktoo" on your visiting cards.

FA is one of the popular accounting packages for simple usage and the need for sufficient familiarity gained through searching forums / wikis etc before one can use it in an advanced manner and best self-supported. The latter is not for everyone though. It is slowly becoming the ERP of choice for the "poor" company and for those dissatisfied with proprietary expensive ones with enormous data lock-ins and recurring charges.

The journal entry should have been from the wrong sales account to the correct one. This should not affect the allocation of customer's  payments.