I have a sales order report that has two subreports on it one calculates the number of items sold and their amounts and the other is a list of the names of dies sold. On the subreport quantity, I have two items that can be sold, diesetup and an extra time charge these have to be calculated seperately, but I need the final amounts to Sum as total due, but if there are more than four diesetup I need to credit the total amount. I'm sure this is not as hard as it seems, but I can't figure it out. If anyone can help it would be much appreciated.
Subreports
- Thread starter Linda31
- Start date
subreports
OK
I have 5 diesetup charges at $63.00 each, the fifth one is free.
I also have 5 extra time charges at $17.50 each.So the subtotal
due is $402.50, but the total due is 339.50 ($402.50-$63.00).
Is this enough of an example?
Thanks
OK
I have 5 diesetup charges at $63.00 each, the fifth one is free.
I also have 5 extra time charges at $17.50 each.So the subtotal
due is $402.50, but the total due is 339.50 ($402.50-$63.00).
Is this enough of an example?
Thanks
Fornatian
Dim Person
- Local time
- Today, 10:58
- Joined
- Sep 1, 2000
- Messages
- 1,396
My simple approach is to have a yes/no flag field for each record to indicate whether to include the field in the calculation, on the fifth run you could then click the field to indicate not to include.
Would this be appropriate. There are other solutions, but I believe that this buy four get one free may change in future as it is a business rule therefore a simpler approach would offer more flexibility in the long run. It would also account for different pricings for diesetups.
Would this be appropriate. There are other solutions, but I believe that this buy four get one free may change in future as it is a business rule therefore a simpler approach would offer more flexibility in the long run. It would also account for different pricings for diesetups.
