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

thanks a lot, I will try it.

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 */

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

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.