FrontAccounting forum — Displaying Discount amount on invoice

Re: Displaying Discount amount on invoice

2016-10-24T13:00:33Z

@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

2016-10-24T08:55:33Z

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

2015-09-29T12:32:25Z

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

2015-09-29T09:11:38Z

@carmelr: Superb! Thanks.

Wiki-ed it.

Re: Displaying Discount amount on invoice

2015-09-29T08:40:54Z

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

2015-09-28T18:35:05Z

Thanks for the effort.

Seems there is no easy way around this.

Re: Displaying Discount amount on invoice

2015-09-28T16:59:11Z

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

2015-09-28T16:30:44Z

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

2015-09-28T16:08:10Z

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

2015-09-28T15:52:45Z

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

2015-09-28T14:44:54Z

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

2015-09-28T13:32:00Z

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

2015-09-28T13:17:30Z

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

Displaying Discount amount on invoice

2015-09-28T10:20:50Z

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