topic Re: Aging Report in Application Development and Automation Discussions

Aging Report

Former Member — Thu, 10 Sep 2009 11:48:39 GMT

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

Re: Aging Report

Former Member — Thu, 10 Sep 2009 13:05:18 GMT

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

Re: Aging Report

Former Member — Fri, 11 Sep 2009 03:55:26 GMT

Hi Rob,

Could you please elaborate this answer...

Thanks,

Chintu

Re: Aging Report

Former Member — Fri, 11 Sep 2009 09:12:40 GMT

Hi all,

Please answer the above question...

Thanks,

Chintu

Re: Aging Report

Former Member — Mon, 14 Sep 2009 04:32:29 GMT

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

Re: Aging Report

Former Member — Mon, 14 Sep 2009 04:40:48 GMT

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

Re: Aging Report

Former Member — Tue, 15 Sep 2009 06:44:31 GMT

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

Re: Aging Report

Former Member — Tue, 15 Sep 2009 07:23:21 GMT

Hi,

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

Regards,

Vikranth

Re: Aging Report

Former Member — Thu, 24 Sep 2009 06:47:36 GMT

I have found the answer myself. Thanks