how i make sum to debit amount

i want to make aged account receivable as following(represent debit amount only):

no name total 1-30 31 -61 61-90

1 Ahmed 278000 178000 100000 0

2 said 90000 90000 0 0

3 maged 100000 80000 10000 10000

1-i want to now how i make sum to debit amount within 1-30days or from 31-61days.

2- and if sum of debit amount within 1-30 is greater than total amount put total amount.

(ex if debit amount to Ahmed within 1-30 days is 300000 this value is big from 278000 then put 278000)

Hi Ahmed,

From the above, then I can’t really see the difference in what you are asking and the standard “Customer Summery Aging” report.

OK thank you