Purchase Invoice Report

mkpjsr

Hi all,

While posting purchase invoice we enter Discount as a separate Line using G/L Account to a ledger called "Discount Received" but I dont want to display this line on Purchase Invoice Report as a line, instead I want to show it after Excise and Tax Amount like this:

Total Excl. Tax
Excise Amount
Tax Anount
============
Total Amount
- Discount
===========
Net Amount

can anybody guide me, how to go for this.

FSmeets

Probably you will have to change that one in the code, since you are not making a difference between line discount and invoice discount.

ssingla

You might have to total the value in some variable and show it in the footer.

mkpjsr

ssingla wrote:

You might have to total the value in some variable and show it in the footer.

ok, but how to restrict the Discount Received line from printing..

crisnicolas

mkpjsr wrote:

ok, but how to restrict the Discount Received line from printing..

Use the SHOWOUTPUT function on the section. Set it to No for the line you don't want to print.

ssingla

Assuming all other lines are for type "Item" you can exclude lines for G/L account. You might also have to consider the invoice rounding line.