Search options (Page 65 of 200)

I guess you are using a MySql release greater than 5.6. These versions have been more restrict in handling SQL.
Please try to downgrade your MySql to 5.5 or less.

We are investigating this in the meantime.

Joe

It seemed not to be a good idea to change the '0000-00-00' to '1001-01-01'. Please replace the value back to '0000-00-00' again.

Then go into phpMyAdmin for your database and enter (in the SQL form):

SET sql_mode = '';

using SELECT @@sql_mode; should report an empty value.

Then retry your operation and see if this helps.

Please report back. Thanks in advance.

/Joe

Newer versions of MySql don't like the value '0000-00-00' as default values. We are looking into this.
In the meantime you can load your account sql file into an editor. Make a replace of all the '0000-00-00' values with '1001-01-01'. Save your sql file and make another try. It should now work.

Joe

Good that you solved it. I will have a talk with our chief developer, Janusz, regarding this.

/Joe

A solution is to run the English translation in Utf8 instead of iso-8859-1.

I guess you can change that in the language install /activate.

You may also need to change the mysql setup as well.

Maybe someone can give more advice.

Joe

Use the account Groups for this.

Create Account Groups 311, 3111.
Let 3111 be a subgroup of 311

Create Account 3111_HCM and use the 3111 Account Group.
Create Account 3111_hanoi and use the 3111 Account Group.

You can even build it a level more, but the more levels the more difficult it is to read the P&L Statement.

/Joe

Yes you can rearrange the classes and groups.

Please read about this in the wiki.

Joe

It is not in the payment form, but in the Supplier and Purchasing Reports.

We have a journal entry form in the Banking and General Ledger setup.

Joe

@apmuthu

For these simple queries, there are no performance advantages using INNER JOIN in MySql. The WHERE clause is easier to read for not so experienced users.

/Joe

Just copy the existing Customer report (rep103.php) from the /reporting folder to the /company/X/reporting folder where X is the company number.

Then start modify this copied report.

Joe

I guess the easiest way for you is to copy the existing Customer Report from /reporting to /Company/X/reporting and modify/add the info you want. That way you don't interphere with the existing report. FA Always tries to find a local report in the Company folder Before using the reports in /reporting folder.

/Joe

Another thing. When you do a sales invoice, the shipping cost would never include a COGS account.
The shipping here is for outgoing compensation for the shipping costs that have been entered another way.

Please talk to a local accountant regarding these issues.

Joe