Invoice Formatting (add discount field)

(0) Share

Report

Posted on by c4c4571f00c7433e841...

1,110

I want to show trade discount on invoice form, above tax analysis , I want to show trade discount amount above tax analysis (because tax is being calculated after discount). but trade discount is not in table in report writer's sales document temp. plz guide me....

*This post is locked for comments

All responses (9)

Answers (1)

c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

RE: Invoice Formatting (add discount field)

thx u so much :)
Verified answer

Almas Mahfooz 11,006 User Group Leader on at

Like (1)

Report

RE: Invoice Formatting (add discount field)

In this case you have to create two conditional fields one for showing trade discount amount and one for showing label.

something like this as below for example.
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

RE: Invoice Formatting (add discount field)

one more thing, if there is no discount, then trade discount label and its value field should be suppressed.
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report
RE: Invoice Formatting (add discount field)

tables are:

sales document temp : picking fields in body section of report :

Field12_A => Shipped

UOM => UOM

Field12_D => Item#

Field12_E => Description

Field12_G=> Unit Price

Field12_H => Ext Price

this all in body section of report, and tax analysis also picking in same fields in the body section from mentioned table.

Now Trade discount is in table "sales transaction work" , if I create a new section, then (as tax analysis is also coming in the body section of report) trade discount section displayed after body (after tax analysis) but I have to show it before tax (tax is being calculated after trade deduction).

calculation, results are correct, only the format of report should be in sequence like :

actual price (unit , ext price)

trade discount

tax analysis
Suggested answer

Almas Mahfooz 11,006 User Group Leader on at

Like (0)

Report

RE: Invoice Formatting (add discount field)

Create a new additional footer and place a trade discount field there so it would print something like that.
Almas Mahfooz 11,006 User Group Leader on at

Like (0)

Report

RE: Invoice Formatting (add discount field)

I wouldn't tell you until you verify my last reply in which I suggest you a correct table. :P~ LOL
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

RE: Invoice Formatting (add discount field)

It starts repeating for every tax line detail, how to avoid it from repeating ?? (trade discount should be printed only 1 time for one item, as in this invoice only one item, but tax details lines are multiple) i want to display trade discount above tax details because tax is being calculated after deducting discount from ext. price. now how to print discount one time only ? if i put in body portion, then it start repeating, and if i create a new section then it printed after tax details
Suggested answer

Almas Mahfooz 11,006 User Group Leader on at

Like (0)

Report

RE: Invoice Formatting (add discount field)

you can find that field in 'Sales Transaction Amount Work' table. Trade Discount Amount field, and this table is available on report.
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

RE: Invoice Formatting (add discount field)