This was quite complicated to fix, due to special handling before we had the option to enter direct to AR/AP accounts in Journal Entry.

The files can be downloaded from the Git Repo:

rep108.php

customers_db.inc

Joe

Joe

I recorded one AR and AP for a customer through JE. Compare images below

rep101

rep108

There is some problem in Aged Customer Analysis also have a look

Aged Customer Analysis

Similarly we need to screen out the affects in Supplier Balances and Supplier Aged Analysis and If any other area, inquiry or report being affected by JE Transactions for Customers and Suppliers.

Regards

Now I see the error. Why didn't I do that before

On the customer side the AR was updated with a minus amount. Changed to a positive amount and it seems to work.

The repo has been updated. You can download the corrected file here.

/Joe

Please check some screen shots below

Customer Balances Before JE Transaction

JE Transaction

Customer Balances after JE

You will find that the JE Transaction is appearing on the Credit Side Not on Debit Side because in Code no proper condition defined to handle Customer Debit Or Credit Transactions through JE.

This Problem is also in rep108.

I guess not yet checked that Suppliers Balances must be affecting due to same logical bug.

Hope this helps to understand.

You can login here to check further

fa.boxygen.biz/fa24

id: demo
pass: password

Thanks

I have now testet the Journal Entries on the Account Receivable, and I see no errors.
Depending on how the JE are entered it will mirror correctly in the Accounts Receivable.
If you still think there is an error, then please give me the booked JE, so I can try to reproduce this.

/Joe

Joe

The following code is not sufficient to handle the transactions through Journal Entry

if ($myrow2['type'] == ST_SALESINVOICE || $myrow2['type'] == ST_BANKPAYMENT)
                $rep->TextCol(4, 5,    $DisplayTotal, -2);
            else
                $rep->TextCol(5, 6,    $DisplayTotal, -2);

Secondly one more thing is that If we Debit the Customer through JE then it appears in the ov_amount column in debtor_trans table as -ve value while if we credit the customer through JE the value appears as +ve value.

Except from the JE all values from any other transaction whether charges or credits appear as +ve value.

rep101 is also affected through JE Transactions. Debit is appearing on Credit Side and Credit is appearing on Debit Side.