Cutomer Aging Query!unable to get the Result

[Former Member]

Hello gurus,

I have a Customer balance aging report to create witha layout as below:

BNo AtDo SDoC Item Bal Due1-15ds Due16-30ds Due31-50ds

90||232|||600|||1|||-100||-100||||||||||||||||||||||||

90||233|||600|||2|||-20|||||||||||||-20|||||||||||||||

90||231|||600|||3|||800|||||||||||||||||||||||800|||||

Result -

---

680|||-100||||||-20|||||||680|||||

the issues I am facing are as below

1. unable to get result at billno. I have put the option as 'Suppress result rows---Never' on the BillNo Char. But the result starts at the Actno when I do teh above.

2.how do I get 680(800(-20)(-100)) as result instead of 800 for the Due46-60dys.

All the key figures are restricted Key Figures.

Also, what is the difference between the Result on the characteristic and the Calculate result As---Summation on the key figure?

Thanks

Simmi

Thanks a lot!!!!!

Simmi

Message was edited by:

simmi

Message was edited by:

simmi

[Former Member]

Guys,

Please help me here. What is a cell reference? I think we need a blog for "CELL EDITOR" . There are too many posts but all are confusing.

How do I achieve the below,

if there are more than 1 item for a billing doc and the balance due amount for each item fall in a different time bucket,example:

Inv.# 91736315 which is partially paid. The payment of USD1,260.00 is in aging bucket 61-90days & total invoice amount of USD1,425.00 is in aging bucket 91-120days.

Is it possible to just have the net outstanding of USD165.00 for Inv.# 91736315 shows in the aging bucket 91-120days in the AR Aging Report.

Similary, the one billiing doc an have 5 items---will result in 5 rows in thereport with due amounts in five different aging buckets. The requirement is that the subsequent result is based on the previous column data.

Regards

Simmi

Message was edited by:

simmi

[Former Member]

Okay. I think my example is no clear. Let me explain,

1. Billing doc is the most granulat level of detail in the query. If I place this in the first in the char list in the rows and select suppress result rows never, it is not bringing the subtotals in the final result. Why is this?

If I move the Billing doc after company code, sales org, customer, it is bringing thesubtotals on the billing doc at every new customer level; why is this?

eg:

Billdoc CC Salesorg customer amount

111 5 9 100 10

112 5 9 100 60

113 5 9 101 20....no subtotal

if as belwo

CC Salesorg customer Billdoc amount

5 9 100 111 10

5 9 100 112 60

RESULT 70

5 9 101 113 20.....now there is result row

Why is this behaviour?

Reagrds

simmi

[Former Member]

Simmi,

On Point 1 - Are you saying that which ever option you take on Suppress Results Rows you do not get a result row?

On point 2 - On your formula for 46-60 Days, have a look at the key figure properties. I think you need to select <b>Results from this Formula</b> on the <u>Formula Collision</u> section.

Regards

Gill

[Former Member]

Guys you are suggesting an avg which is not the result I want. The final result is based on the results of the previous columns.