Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to sum all the qty group by supplier
Example i have Supplier, ItemGroup, Item and Qty, and i would like to accumulate sum all the Qty base on individual Group
Supplier ItemGroup Item Qty AccuItem AccuItemGroup AccuSupplier
Man A A1 10 10 10 10
A1 20 30 40 30
A1 30 60 100 60
A2 20 20 120 80
B B1 10 10 10 90
B2 30 30 40 120
B2 10 40 80 130
C C1 10 10 10 140
C2 10 10 20 150
C3 20 20 40 170
Please some one help me. Many Thank
Any body can help me?