Important MySQL4 problem

[C K Wu]

Hi, folks,

While testing Horde adaptation, I come across a problem of running
CK-ERP within a MySQL4.1.11 environment (default for FC4). The Trial
Balance gives a dr/cr imbalance. To check if this problem applies to
your case, follow these simple steps,

Ledger module -> Reports -> 1 - Trial Balance -> [start report
generation] -> [start report generation (2nd time)] -> weird dr column
figures (99.99) will show up and the bottom line will show a dr/cr
imbalance.

To rectify the problem, edit <ck-erp root>/ck-ledger/trialbalance.php.
At around line 70,

$sql.= "SELECT chart_id, 0.00 as dr, sum(amount) as cr FROM ${pre}acc_trans " ;


change '0.00' to '000000000000.00'. Then, using the browser, launch
[http://<your website>/<egw/phpbb/tikiwiki root>/ck-admin/adminmd5.php]
to refresh the script md5 checksums. Subsequently, regenerate the Trial
Balance. The report should return to normal.

The problem seems to be MySQL4 specific. PostgreSQL within FC4 does not
exhibit the same problem. However, this problem will most likely
affect other similar reporting scripts. I'll try to gauge the extent of
this problem within the entire CK-ERP suit of scripts as soon as I can
and come back to you with more details. In the meantime, please avoid
using a MySQL4 database backend (MySQL3 seems to be OK).

Cheers,
CK

PS - I'll probably change adminmd5.php to admin access only in
subsequent releases.

[C K Wu]

Hi, folks,

I have gone thru the reporting scripts. Reports that are affected by
the MySQL4 problem, include,

Ledger: Trial Balance
Accounts Payable: Accounts Payable Aging Report, Vendor Invoice Aging
Report
Accounts Receivable: Accounts Receivable Aging Report, Customer
Invoice Agining Report
POS for Manager: List of Shift end Cash Balances, List of Shift End
(Completed) Cash Balances
Customer Relationship: List of Outstanding Invoices for Customer, List
of Unbilled SO for Customer
Customer Self Service: List of Outstanding Invoices for Customer, List
of Unbilled SO for Customer
Ledger Reports - Trial Balance
Vendor Relationship: List of Outstanding Invoices for Vendor, List of
Unbilled PO for Vendor

Errors with these reports will be rectified in the next release, which
is expected to be available by the end of this month (if the new i18n
scheme does not create too many problems).

Cheers,
CK