Hi ,
I need to modify a std sales invoice report to show the lines with an additional line below it in case there is discount applied to that line.
As shown below item1 has a discount of 10 and hence discountabc was applied with value 15 .(salesline.disvalue = 15)
Total = 100+20+30-15 =135.
Note that there is no line between item 2 and item 3 as there is no discount applied in that case.
Can you please let me know how to achieve this.
eg.
| Line number | Item number | Description | price | Amount | |||
| 1.00 | itemi1 | Item1 name | 100 | 100 | |||
| discount abc(custom field in salesline) | 15 | ||||||
| 2.00 | item2 | Item2 name | 20 | 20 | |||
| 3.00 | item3 | Item3 name | 30 | 30 | |||
| Total | 135 | ||||||
Thanks,
VK

Report
All responses (
Answers (