problem in 0Fair_C03 Related Query

[Former Member]

Hello Guru's

In the Kfig (0DAYs) , i should get amount(Debit/credit amount) for net due days (OP_KEYDT) till today with item status(OPEN).

So have done following restriction ...

net due day<= OP_KEYDT(variable)

item status = O

But the problem is it showing data for those which which has CLEARING DATE.

How to achieve this...i want to shopw only OPEN Status one...

Hope some one understood the issue....i am not able to explain it

Thanks in Advance

Dev

[Former Member · Accepted solution]

I am confused - what arwe you trying to do in process terms

Are you trying to get an aged debt report with buckets based on the net due date - ie 0-30 etc

[Former Member · Accepted solution]

Hello,

I am trying to get amount (Credit/debit amount) till TODAY in 0Days

[Former Member · Accepted solution]

Didn't quite answer my question - what process wise in AR terms are you tryign to do?

(for note: I am a BW AR specialist)

I

[Former Member · Accepted solution]

Hello Simon

In a Kigfugure(0Days), ishould show AMOUNT with Item status only O but not with Status C

Hope you got it.

0COMP Customer Clearing Date DUEDATE Item status Credit/ debit Amount

DE30 10001 09.04.2008 O 16.492,03

DE30 10001 25.04.2008 O 15.041,34

DE30 10001 16.05.2008 O 49.476,10

DE30 10001 24.05.2008 O 28.683,82

DE30 10001 25.05.2008 O 16.492,03

DE30 10001 07.06.2008 O 16.492,03

DE30 10001 18.06.2008 O 15.857,80

DE30 10001 30.05.200824.05.2008 C 57.367,64

DE30 10001 28.06.2008 O 28.018,66

DE30 10001 24.04.2008 O 12,5

DE30 10001 24.04.2008 O -28.683,82

DE30 10001 30.05.200824.04.2008 C -86.051,46

DE30 10001 30.05.200824.04.2008 C 12,5

DE30 10001 30.05.200824.04.2008 C -12,5

DE30 10001 30.05.200824.04.2008 C 28.683,82

DE30 10001 04.06.200825.04.2008 C 15.041,34

DE30 10001 03.07.2008 O 31.715,60

DE30 10001 04.06.200826.03.2008 C -15.041,34

DE30 10001 11.07.2008 O 16.492,03

DE30 10001 16.06.200816.05.2008 C 49.476,10

DE30 10001 16.06.200818.06.2008 C 15.857,80

DE30 10001 16.06.200816.04.2008 C -49.476,10

DE30 10001 16.06.200815.05.2008 C -15.857,80

DE30 10001 23.07.2008 O 31.715,60

DE30 10001 30.06.200828.06.2008 C 28.018,66

DE30 10001 26.07.2008 O 32.349,83

DE30 10001 30.06.200829.05.2008 C -28.018,66

DE30 10001 01.08.2008 O 13.192,34

DE30 10001 08.07.200823.07.2008 C 31.715,60

DE30 10001 08.07.200803.06.2008 C -31.715,60

DE30 10001 07.08.2008 O 18.000,00

[Former Member · Accepted solution]

I guess you are trying to do some sort of aged debt report histroically

What is 0 days??

Normally we have reports that look like this

          Balance    Not Yet Due           0-30 days   
Customer 1   10             5                  5
Customer 2   5              5                  0

[Former Member · Accepted solution]

hi

Imagine 0days is just name of a Kfig .

Can you please tell what is the restriciton behind Not yet Due in your report

My reports is also some what same,

Table

Balance 0 Days 1 - 8 days 9 - 30 days 31 - 45 days > 45 days

Customer Number EUR EUR

10001 0,00 117.570,60 386.289,40

Overall Result 0,00 117.570,60 386.289,40

Edited by: Srinivas dev on Oct 8, 2008 1:15 PM

[Former Member · Accepted solution]

ok..

Not Yet Due is a CKF of

not yet due rkf1 + not yet due rkf2

not yet due rkf1 is

keyfigure of 0DEB_CRE_LC

item status = O

Calendar Day (ie Posting Date) <= key date

Net Due Date is an interval of key date1 +0 (offset) and key date1 +999999 (offset)

not yet due rkf2 is

keyfigure of 0DEB_CRE_LC

cleared date > key date 3

Calendar Day (ie Posting Date) <= key date

Net Due Date is an interval of key date1 +1 (offset) and key date1 +999999 (offset)

Now key date is the entered date - you normally have key date2 and key date3 read this same date

Now this theory on this is ..

RKF1 is those items that were open at the time of the key date and still open now

RKF2 is those items that were open at the time of the key date and were subsequently cleared SINCE the key date

So to restate the AR report histroically we have to add both together

You need to have these two RKFs and one CKF for each aging bucket

in the 0 to 30 days the bucket will be

Net Due Date is an interval of key date1 0 (offset) and key date1 -30 (offset)

The 31 to 60

Net Due Date is an interval of key date1 -31(offset) and key date1 -60 (offset)

You get the idea..

[Former Member · Accepted solution]

Hi simon,

i will try this and let yu know the result

Thanks in adv

Dev

[Former Member · Accepted solution]

Hi simon,

Can you please let me know what r the restrictions you have for balance

Thanks in Adv dude

DEv

[Former Member · Accepted solution]

Have you tried the simplest one?

Add up all the aging buckets CKFs!!!!

Or one CKF and 2 rkfs - as in the above examples but drop the netdue date clause from both

It really is that simple - this is how the normal r3 AR reports work by reading from BSID and BSAD (ie RKF1 and RKF2 inthat order)

[Former Member · Accepted solution]

Hello Simon,

Sorry to ask you again but i am totally confused here...

Can you leave me your Personal mail Id to that i can mail you my problem with screen shot....bcoz i am not able to get correct data in 0days.

Thanks in adv

Dev

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

maybe a simple approach is

in restricted keyfigure

u restrict open status with

INCLUDE O=OPEN

EXCLUED C= CLEARING DATE

this way it will show all values with Open status and exclude all values with clearing date

[former_member205352]

Try Clearing date = # in the restriction instead of item status = O.

In fact both should work I guess item status is not populated properly in your case.

Hope this helps.