• From: Oman, Muscat
  • Registered: 10/10/2020
  • Posts: 39

Topic: Display payment information in the printed invoice

I would suggest displaying the amount paid and a paid stamp if its fully paid, in the PDF printed Customer Invoice.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Display payment information in the printed invoice

What happens when the payment is edited to show it as being only partially paid.... Better still do it offline manually!

apmuthu's Website

  • From: Oman, Muscat
  • Registered: 10/10/2020
  • Posts: 39

Re: Display payment information in the printed invoice

Thank you for your quick response,

I still think that there must be a solution for this issue, as the other accounting systems shows the total amount, the amount paid and the remaining amount in the generated invoice. This will facilitate the work as the user sends the invoice to the customer mail directly through the system and this is an excellent feature.

  • From: Saudi Arabia
  • Registered: 12/06/2016
  • Posts: 10

Re: Display payment information in the printed invoice

If you need only the total allocated amount and the balance to be printed on the Sales invoice, it can be done by updating  rep107.php file with a few line of code.

  • From: Oman, Muscat
  • Registered: 10/10/2020
  • Posts: 39

Re: Display payment information in the printed invoice

Dear Samsa

Thank you for your contribution, Can you please help in this matter

  • From: Saudi Arabia
  • Registered: 12/06/2016
  • Posts: 10

Re: Display payment information in the printed invoice

Hi Said,

Here is the steps to be followed:
open the reporting/rep107.php file for editing
insert the below code at the bottom of this file, usually on line # 301 in editor before the coding to display e-mail. That's all and hope it works.

/*to display payment/allocation on invoice*/
            $DisplayBalance = number_format2($sign*($myrow["ov_freight"] + $myrow["ov_gst"] +
                $myrow["ov_amount"]+$myrow["ov_freight_tax"] - $myrow['alloc']),$dec);
            $rep->NewLine(2);
            $rep->TextCol(3, 6, _("ALLOCATED"));
            $rep->TextCol(6, 7, number_format2($myrow['alloc'],$dec));
            $rep->NewLine();
            $rep->TextCol(3, 6, _("INV BALANCE"));
            $rep->TextCol(6, 7, $DisplayBalance, -2);
/* code ends here */
  • From: Oman, Muscat
  • Registered: 10/10/2020
  • Posts: 39

Re: Display payment information in the printed invoice

Dear Samsa

thanks a lot, I will try it.

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Display payment information in the printed invoice

It works,
And is supported by receipts as well..
Although I don't need this on my invoices (as the receipts do the same functionality) it seems  it helps others with their business.
Well done.

rafat's Website

  • From: Nigeria
  • Registered: 09/08/2007
  • Posts: 124

Re: Display payment information in the printed invoice

Hello @ samsa,

Thanks so much for the modification you helped with in the invoice reporting.

Please I will need just a line input in it. The customers I have they always want to see their outstanding Balance in their new Invoice so that they know the exact amount they are owing. Something Like this

Sum Total                    =       5,000.00
Outstanding Balance   =   251,000.00
Total Amount               =   256,000.00
Allocated                     =   100,000.00
Total Balance              =    156,000.00

Please make the spacing uniform so it can also contain the usual number of lines for product inputs

Please kindly help out.

Thanks in advance

Popsicles12