Creating subtotal sections on report 202 - Sales Document

kuf

I would like to create two section on a sales incoice as follows (report 202)

Value
1 Item 1 x
2 Item 2 y
Sub total x+y

3 Item 1 a
4 Item 2 b
Sub total a+b

TOTAL X+y+a+b

Help

tinoruijs

If you want this in report 202, you probably want it also in 204, 205, 206 and 207.
If that is the case, maybe the best solution is to make a function in the sales documents to create sales lines type text which contains the subtotal in the description. That way the subtotal will not be counted in the total amount of the sales document. And you won't have to adjust 5 reports.

SobyOne

When designing the report code, choose "View, Globals".

You will need to create at least 1 global variable per total.

Then you put the values into the footer of the report, or the group footer.

You may also want to take advantage of the auto-subtotaling feature of NAV reports, but the topic is way beyond the scope of this forum.