You’re offline. This is a read only version of the page.
66
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
You'll need to an the extra field to SalesInvoiceTmp table and populate it in an extension of SalesInvoiceDP class.
Then you'll need to duplicate the standard invoice report, modify the report design and use this new report instead of the standard one.
Refer to Customize App Suite reports by using extensions and How to create a new design for a Sales Invoice report, for example, for more details.
Share
Report
All responses (
Answers (
