FrontAccounting forum — Displaying Discount amount on invoice

Re: Displaying Discount amount on invoice

null@example.com (apmuthu) — Mon, 24 Oct 2016 13:00:33 +0000

@seahawk: The global variable $no_zero_lines_amount is used to display the zero amount line in reports 107, 109, 110, 111:

                if ($Net != 0.0 || !is_service($myrow2['mb_flag']) || !isset($no_zero_lines_amount) || $no_zero_lines_amount == 0)
                {
..
..

Re: Displaying Discount amount on invoice

null@example.com (seahawk) — Mon, 24 Oct 2016 08:55:33 +0000

In the config file there is also an option on line 74:

/* Do not print zero lines amount of 0.00 in Sales Documents if service item. 1 = do not */
$no_zero_lines_amount = 1;

Re: Displaying Discount amount on invoice

null@example.com (seahawk) — Tue, 29 Sep 2015 12:32:25 +0000

Thanks. Have done something similar but have setup a service item linked to the discount given account in the ledger.

I though there might a a tick mark or display zeros or something that might be easier, but you idea works great as well.

Regards

Re: Displaying Discount amount on invoice

null@example.com (apmuthu) — Tue, 29 Sep 2015 09:11:38 +0000

@carmelr: Superb! Thanks.

Wiki-ed it.

Re: Displaying Discount amount on invoice

null@example.com (carmelr) — Tue, 29 Sep 2015 08:40:54 +0000

The way I do it is to enter the discount on another line and enter a negative amount.

See examples here:
http://cleversolutions.eu/img/Invoice-discount.png
http://cleversolutions.eu/img/Invoice-d … -print.png

Re: Displaying Discount amount on invoice

null@example.com (seahawk) — Mon, 28 Sep 2015 18:35:05 +0000

Thanks for the effort.

Seems there is no easy way around this.

Re: Displaying Discount amount on invoice

null@example.com (apmuthu) — Mon, 28 Sep 2015 16:59:11 +0000

Unfortunately, the values are stored in the tables in a disjoint manner. The full values of amount and tax are stored in #_debtor_trans_details. The "net of discount" values are stored in #_debtor_trans - the last line in the Print Invoice takes it's value for INVOICE TOTAL from here.

You will need a completely different SQL linking the tables appropriately to get what you want. Otherwise, it will need to find a place in the Comments field manually entered which is what I assume you are doing now.!

Re: Displaying Discount amount on invoice

null@example.com (seahawk) — Mon, 28 Sep 2015 16:30:44 +0000

apmuthu wrote:

rep107.php (Print Invoice) does not show the rate and discounts

Thanks

Agree, but what should I change in the rep107 to show the item cost and the 100% discount on the invoice with 0 toal for the line item?

Re: Displaying Discount amount on invoice

null@example.com (apmuthu) — Mon, 28 Sep 2015 16:08:10 +0000

Check the transactions (#_debtor_trans) table to see if it shows up there.

rep107.php (Print Invoice) does not show the rate and discounts
rep112.php (Print Receipts) shows the vales as 0 for left to allocate.
ViewGL Transactions shows the values contra-ed as being amounts before tax!
The View Sales Invoice page shows the amount after tax!

Re: Displaying Discount amount on invoice

null@example.com (seahawk) — Mon, 28 Sep 2015 15:52:45 +0000

I do that, but when you print the invoice (Pdf) file, on the report, it does not display the amount nor the discount

Re: Displaying Discount amount on invoice

null@example.com (apmuthu) — Mon, 28 Sep 2015 14:44:54 +0000

Use the full original value of the ABC Service Item in the invoice with the cost you would normally charge but use 100% as discount.

Re: Displaying Discount amount on invoice

null@example.com (seahawk) — Mon, 28 Sep 2015 13:32:00 +0000

I use a service item for Example ABC; total = 1 ; Price = 30; Discount = 10%; Result = 0

On the invoice only ABC is printed and the rest is blank. Nothing is shown in that line on the invoice. I need the line to show the above information.

regards

Re: Displaying Discount amount on invoice

null@example.com (apmuthu) — Mon, 28 Sep 2015 13:17:30 +0000

Invoice a "0" cost service with it's name indicating "Usual cost $..." ?

Displaying Discount amount on invoice

null@example.com (seahawk) — Mon, 28 Sep 2015 10:20:50 +0000

Sometimes I want to show a service cost on the client invoice and give them a 100% discount, but I need the discount% to display as well as the amount of zero(0) on the invoice.

Have searched the forum but cannot find something

regards