AL: Variable to Calculate Group Total for each line on page

(0) Share

Report

Posted on by Samantha73

3,255

Hi Guys

I have page that shows sale order line records, and want to include a total quantity of the order for each line. Total will be repeated for for all lines of a given order as below:

Order No Line No Item Qty Total Qty

10001 1000 A 10 30

10001 2000 B 20 30

10002 1000 A 100 100

Not sure how to achieve this and couldn't find an example in the base app

Thanks

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

Pattern here makes sense: https://youtu.be/fXDxAM0ZrvU

Use the calcsums on the sales line table for the qty. field based on a series of filters for the line.

Was this reply helpful? Yes No