0
Hi - the amount outstanding in the available token field shows: {amount_outstanding} Total amount left to pay (Invoice total - sum of payments).

We did a test. Created an invoice and made a 50% payment on it. On the invoice the amount outstanding shows 0 (no changes made on the invoice template).

The token field shows Invoice Total (ie 1000) - Sum of payments (ie 500) which should equal 500.

I read the other post on it but that will create confusion as an invoice has a total to be paid on it. When a client pays a portion that needs to be shown as well as the outstanding amount still owed. If another "payment" needs to be created it will open up endless possibilities for a lot of errors as people might enter the wrong amount, leave out a zero, allocate to the wrong invoice, etc.

Is there a token which works this out exactly that can be added to the invoice template? (in short invoice amount minus any payments made equals total amount outstanding). Thanks.
Responses (6)
  • Accepted Answer

    Thursday, September 25 2014, 08:40 PM - #Permalink
    0
    hello,

    no, the amount outstanding token is the SUM OF ALL UNPAID PAYMENTS. not the invoice total - payments paid.

    do you know what I mean?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, September 25 2014, 08:58 PM - #Permalink
    0
    Yes but that does not make sense.

    If I understand you correctly, I need to create an invoice. From there then I need to create a payment when I receive money AND another payment for the outstanding amount?
    The reply is currently minimized Show
  • Accepted Answer

    Friday, September 26 2014, 04:56 PM - #Permalink
    0
    to mark some amount as paid, there needs to be a payment. the user is not able to pay the amount outstanding if there's no payment associated with it...
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, September 30 2014, 06:45 PM - #Permalink
    0
    Hi - thank you. Worked out a process that will fit with the business. Understand the payment options better now.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, May 06 2022, 11:16 AM - #Permalink
    0
    This is SOOO stupid! Now I have to make out a payment beforehand and if I don't but I have an invoice made out, the outstanding is 0.
    Now I have hundreds of students who I invoice for a course for the year for say R50 000. but immediately say they do not owe anything. outstanding is 0. Now I have to go and make 10 payments of R5000 each and hope they all pay each month. And if they do then I have to go tick off that payment. Now they only make part payment of payment, and I now have to go manually adjust every single payment. This is a huge manual work and I fired a person because of it. and now realised why she could not manage. One should not have to go and manually add a payment beforehand for it to show a client have an outstanding balance. This is so wrong. It should be invoice - payments added. We use a CSV payments file we get each month that we want to import againts an invoice, without having to struggle to create a lot of payments manually beforehand, since we do not know how many payments and the accurate amount beforhand. Excuse me i do not mean to sound rude. I am not, I am just very frustrated that the invoice manager is not working as normal other invoice managers we used to work with, and now I paid for this and it is not working very functional or practical. What will it cost me to get it ammended?
    The reply is currently minimized Show
  • Accepted Answer

    Monday, May 09 2022, 11:29 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