SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

Dunning Amount

Former Member
0 Kudos
323

we have requirement explained in below example, so please help me to find out solution config or new enhancement to meet this requirement

Lets say we need to trigger collection step U001 when overdue Amount is $100 and it is Overdue by 30 days

we have grouping at contract account level, now a particular Contract account have following line items

due date Amount

20th August, 2011 70

24th July, 2011 30

Total debt on ca 100

Dunning run date and issue date: 23rd August, 2011

We want to exclude the debt of $70 which is due on 24th august to determine dunning criteria of $100 and include only those items on CA which are overdue by 30 days to determine the collection step - In this case 30 days overdue debt is only $30 so this CA should not hit collection step U001- This is not happening right now we are clubbing the $70 as well and this CA is dunned.

Please let me know if anything above is not clear

1 ACCEPTED SOLUTION

william_eastman
Product and Topic Expert
Product and Topic Expert
0 Kudos
266

Vinod:

Assuming that you are using BRF for this - you need to define several expressions which are independent of the dunning balance, and which correspond to the amount over 30 days. That should not be very difficult. Then utilize the 30 day overdue balance in the determination of the U001 step.

regards,

bill.

View solution in original post

8 REPLIES 8

william_eastman
Product and Topic Expert
Product and Topic Expert
0 Kudos
267

Vinod:

Assuming that you are using BRF for this - you need to define several expressions which are independent of the dunning balance, and which correspond to the amount over 30 days. That should not be very difficult. Then utilize the 30 day overdue balance in the determination of the U001 step.

regards,

bill.

0 Kudos
266

Hi Bill,

Thanks for your reply, yes we have BRF in place,

It will be of great help if you could point me towards some specific expressions details which I can use here to solve the problem?

Vinod

0 Kudos
266

I am planning to arrive at dunning balance criteria as under to meet he requirement stated in my first post

kindly advice if this approach is good.

Dunning balance criteria = BETRW IN $FKKMAGRP - sum of $FKKMAVS (selection

criteria being due date (FAEDN) is not equal to lowest due date in

$FKKMAVS)

0 Kudos
266

Hi Vinod,

To cater to your requirement, make four expressions of the expression type-0FICADR001 namely.

(a) Latest due date

(b) Business Partner

(b) Contract Account

(c) Dunning Balance.

First expression will contain the latest due date (FAEDN-$FKKMAVS) for all the items in the current dunning notice.

Business partner will contain field (GPART-$FKKMAGRP).

Contract account will contain field (VKNT1-$FKKMAGRP) based on the selction criteria GPART = Business partner

Dunning balance expression will contain the field (BETRW-$FKKMAGRP) based on the selection criteria by

VKONTGRP = Contract Account

FAEDN not equal to Latest Due Date

The amount that you would get will be $30.0.

Now declare a constant expression and assign a value of 100 to that, and then compare the value of dunning balance with the constant. If it satisfies, then trigger collection step U100, else not.

Hope it helps....

Thanks,

Amlan

0 Kudos
266

Hi Amlan,

Thanks very much for extending your help as always, I will implement and get back to you. .

Kind regards,

Vinod Khelani

0 Kudos
266

Hi Amlan,

Just wanted to have your guidance,

I am not able to get how we are going to handle cases where there are multiple items having different due dates but all of them are over due by 30 days

so we want to include all these multiple items in dunning balance

please have your guidance on above query.

Kind regards,

Vinod Khelani

0 Kudos
266

Hi Vinod,

You need to create a expression like DAYS_ARREARS, of expression type, 0FB002.

In the formula editor, you need to write the formula for calculating the Difference of days between the latest due date (FAEDN) for the all the single items in the current dunning notice and the issue date of dunning (AUSDT), by giving the time zone and the factory calendar that you are using.

This will store the number of days.

Now, create another expression, OLDEST_DAYS_ARREARS of expression type 0RE001.

In this expression, give the expression to be checked as "DAYS_ARREARS" and in the Single values table, use the value > and single values as 30.

Now use this expression for taking into account all the items which are due for more than 30 days.

Hope it helps....

Thanks,

Amlan

0 Kudos
266

Hi,

In addition to Amlan's detailed response, please note that the structure $FKKMAVS contains line items that are being proposed for dunning during the dunninc run.

I hope this helps you.

Regards,

Ivor Martin