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

I have the same question (0)

All responses (9)

Answers (1)

c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

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

Was this reply helpful? Yes No
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

I wouldn't tell you until you verify my last reply in which I suggest you a correct table. :P~ LOL

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

Create a new additional footer and place a trade discount field there so it would print something like that.

Was this reply helpful? Yes No
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report
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

Was this reply helpful? Yes No
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Almas Mahfooz 11,009 User Group Leader on at

Like (1)

Report

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.

Was this reply helpful? Yes No
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

thx u so much :)

Was this reply helpful? Yes No