Amount Outstanding Not Accurate

1
Hi,

As you can see with my attachment, the Amount Outstanding is not actually the difference between Total Owing and Total Paid. If so, the amount outstanding would be $250 as only $50 has been paid out of the $300 is that owing.

It seems, in my case, the amount owning is pulling from the Total Payments Made + Total Pending - Total Payments Made. I put in two payments (one for $50 that was received and one for $30 that is pending). I have no use for the pending function; however, I'm using this to illustrate the Amount outstanding is not functioning correctly for me. If I use no pending payments, it says the customer owes $0.00.

Thanks in advance,

Ken
Attachments:
Responses (4)
  • Accepted Answer

    Tuesday, January 21 2014, 03:05 PM - #Permalink
    0
    I have figured out how to do this. In the payments section, if the total amount owing is $300, and the customer pays $50, you'll need to not only input the $50 that was paid but the $250 as unpaid. That clears that up. :)
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, January 21 2014, 04:53 PM - #Permalink
    0
    that's correct. the "pending amoun" is to total summatory of pending payments (not the total of the invoice minus the summatory of paid amount)
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 06 2022, 11:22 AM - #Permalink
    0
    This is not practical at all. not how any of my other invoice apps worked, and now I paid for a program that is actually making us a lot of manual effort since we have to now put in payments beforehand else it shows the user owes us 0. But we do not know beforehand what a payment will be. and if they only pay partially we would have to amend that payment and ad another.
    Why not have it work like other apps where outstanding is invoice minus payments submitted as paid. Now we have to go manually and create payments outstanding beforehand for the outstanding to show correctly. This is so not practical. How do I fix it, or what will it cost me for you to change it? Kind regards :-)
    The reply is currently minimized Show
  • Accepted Answer

    Monday, May 09 2022, 11:30 PM - #Permalink
    0
    My solution, a one-liner :-) See image attached.

    The fix! Go edit the file --> /components/com_invoices/views/invoice/tmpl/default.php at about line 363: $amount_outstanding = $total - $subtotal_payments;
    Then whenever there is a pending payment manually entered or not the outstanding amount will at least correctly show the invoice amount minus the payments made.
    I hope this helps :-)
    The reply is currently minimized Show
Your Reply