Aging Report

[Former Member]

Hi all,

Iam working on a customer aging report. It displays Profit centre, Account group and Customer Number wise.

Please note that there are 4 different amounts getting displayed ( amount due from customer in various periods ( ex <7 , < 15, <30, <60 days ).

For a paricular customer, there is Debit and Credit entry in which Account group exists for debit entry and doesn't exist for credit entry. As a result, iam not able to sum this two entries. Please give me the solution for this.

Thanks in advance,

Chintu

[Former Member]

Hi, if you are reading your data into an internal table you are able to check your data and give a default Account group or take over from the debet entry. Succes

[Former Member]

Hi Rob,

Could you please elaborate this answer...

Thanks,

Chintu

[Former Member]

Hi all,

Please answer the above question...

Thanks,

Chintu

[Former Member]

Hi Chintu,

After fetching the Data to an internal table use like this .

use Field SHKZG = 'H' then

itab-wrbtr = - itab-wrbtr.

when SHKZG = 'S'.

itab-wrbtr = itab-wrbtr.

Then use Collect in other Itab.

hope u hav got the Idea.

Regards,

Prakash

[Former Member]

Hi prakash,

Thanks for the answer.

I have already seggragated the debit and credit entries with the field SHKZG. But the problem is I cannot sum the entries.

For ex. for a customer 2001, Profit centr is 1004 and acct group is 'IPF' and for same customer 2001 , profit centre is 1006 and acct group is 'SD'.

How can i achive this? Please advice

Thanks in advance,

Chintu

[Former Member]

Hi,

Can you post the sample internal table entries which are being populated? That would be easier to suggest the solution

Regards,

Vikranth

[Former Member]

Hi Chintu

If you are referring to customer account group, better dont consider account group for fetching data for calculations. You can get account group from customer master table KNA1 based on the customer codes.

Rgds

Sathar

[Former Member]

I have found the answer myself. Thanks