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.
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
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0This 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? -
Accepted Answer
0My 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 :-)
Your Reply

Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »