Skip to Content
0
Former Member
Jun 30, 2007 at 11:55 PM

suppressing duplicates for summing

10 Views

Post Author: srikarthy

CA Forum: General

Order

Amount

Item

quantity

ATR-PSU1

1211.93

PR0000460

583.14

PR0000460

291.57

ATR-PSU1

1.00

PR0000460

0.00

ATR-PSU1

1.00

PR0000460

0.00

ATR-PSU1

1.00

PR0000460

13.60

ATR-PSU1

1.00

PR0000460

277.97

ATR-PSU1

1.00

PR0000750

628.79

PR0000750

314.39

ATR-PSU1

3.00

PR0000750

0.00

ATR-PSU1

3.00

PR0000750

0.00

ATR-PSU1

3.00

PR0000750

27.20

ATR-PSU1

3.00

PR0000750

287.19

ATR-PSU1

3.00

Good Day!

In the report above, each production order has various costs like material costs, operations cost hence there are many lines for a production order. But the quantity is just 1 and 3 in the two production orders above. How to total the quantity by item? When I sum it, it shows 20 instead of 4.

Thanks,

srikarthy