How to group amount on the basis of dimension by code

Markandey_Pandey

Hi all,

I want to write code for calculating the total of amount and quantity by grouping the dimension.

then i want to show the output like this by writing cal code.

Dimension Quantity Total
D1 100 200
D2 250 350

like that

This we can do easily by indenting the dataitems (in reports) and using the GroupTotalfields ,etc.
But according to my requirement i want to do the same by writing CAL code, because it may be that quantity and amount is of different type so i have to separate them.

Can anybody help me.

kriki

Check http://www.mibuso.com/howtoinfo.asp?FileID=22.
The last part (Make a total amount per "Gen. Bus. Posting Group" and "Gen. Prod. Posting Group" of table 15:"G/L Entry") explains how to read records and total them by certain fields.

srij

great post