Release Statistical Write off items to collection agency

[Former Member]

Hi All,

As part of Final billing Dunning activity, we are creating Write-off and Statistical Write-offs for all the open items once it reaches the last level in the dunning procedure.

My question is, we want to release these statistical write off items to collection agency(CA) as part of dunning activity. I tried adding this activity along with the activity that creates write off and statistical write off items in the same dunning level(by giving sequential number as 1 and 2).  With this configuration it is releasing the original open items to CA but not the statistical items created as part of other activity.

Please let me know how to release statistical write off items to collection agency in the same dunning level without releasing the original items.

Thank you

Sruthi

[AmlanBanerjee]

Hi Sruthi,

Is there any specific reason for releasing the items to Collection Agency through Dunning activity.

There is a standard SAP Release (FP03M) and Submission (FP03DM) process for the same.

Moreover, in the Dunning activity, Check, if the DB commit is happening or not for the Statistical items, and only then release them.

Thanks,

Amlan

[Former Member]

Hi Amlan,

Thank you for your time.

The reason is, currently we are using FP03M for releasing the items but we are manually entering all the contract accounts from FPM3. Also from those accounts we are segregating the ones that are more than $10 and passing only those accounts while releasing which is taking lot of time.

So my understanding is if we release them as part of dunning activity, we can submit manually (FP03DM) just by passing the parameter as submission status as “01”.

Thank you

Sruthi

[AmlanBanerjee]

Hi Sruthi,

Not Sure why you are manually giving the Contract Accounts as input in FP03M for mass release.

FP03M has the flexibility to pick up only those items which have reached a particular Dunning Procedure and dunning level.

You can find all these in the Additional Selections tab in FP03M along with feature to submit the Statistical and Written-off entries.

So if you have a particular Dunning Procedure and dunning level for write-off , configure that in FP03M variant and execute the same after the completion of the Dunning run.

Now with your requirement to only release those accounts which have an outstanding balance of more than $10, you can configure an execution variant, say 01 and place it in FP03M and based on that enhance event 5015, which will check for the account outstanding balance,. You can use FKK_ACCOUNT_BALANCE_COMPUTE for the purpose.

Based on the Outstanding amt. if you don't want to release the accounts to Collection agency, you can pass them in the T_FKKOP_DEL table in event 5015.

Hope it helps...

Thanks,

Amlan

[Former Member]

Hi Amlan,

Let me tell you our business scenario. When any of the open item in the contract account reaches last level of final bill dunning, we are writing off all the other open items in the contract account(even if they are not over due). And creating Statistical write off for all the write off items. So if we select particular dunning level in the additional selections, it will miss the other open items(which reached first dunning level or no dunning level at all) from releasing to collection agency.

Thank you for detailing about event 5015. It helps.

Regards

Sruthi

[AmlanBanerjee]

Hi Sruthi,

Got your Business scenario.

So when you are creating the Write-off Statistical entries in the Dunning activity, you are creating it with a particular main/Sub combination and Document type.

In FP03M, in the Custom selections tab, give the Combination of the main/Sub combination and Document type and Collection item EQ blank.

So it will pick up only the Statistical entries for release to Collection agency and use event 5015 for filtering the accounts based on the account outstanding balance.

Hope it helps...

Thanks,

Amlan

[Former Member]

Hi Amlan,

When we thought of this option, we are worried that this might release other old statistical write offs in the system, but I think we can control that also using posting date in the additional selections.

Thanks a lot for your suggestions and time.

Regards

Sruthi

[former_member199199 · Accepted solution]

Hi Sruthi,

You can try this approach -

1. Create a new dunning procedure (say WO) and configure one level as 01 (release to Merc). Set days in arreas as 0. As a part of the activity, you can create a FM to release to mercantile (preferably a copy of FKK_COLL_AGENCY_RELEASE_0350).

2. While creating write off statistical open item, in user exit (FQEVENT 0010/0030), you can assign dunning procedure WO at the statistical document level (fkkop-mahnv).

3. On the immediate next dunning run, will pick up the statistical document for dunning to WO -  01. And as a part of the activity the document would be released.

4. You will then have to run a submission job (FP03DM) to create the referral file for the agency.

Alternatively, you can set up release job FP03M and in the addition selection tab you can mention the dunning procedure WO and level 01. If required you can enhance events 1734, 5060 to specifically select the statistical items (exclude the original final invoice documents).

In that case you don't have to define anything in dunning activity of WO - 01.

Either way you would require a following submission job (FP03DM).

Hope it helps. Let us know how you go.

Regards,

Bodhisattwa

[rahul_paldiwal2]

Hello Sruthi,

Follow below steps to submit the items to collection agency.

Step 1. Assign custom Write Off FM to the dunning activity. As part of this FM create the statistical document . Also ensure that the statistical document has the dunning step of the original written off document. This will help in the selection program for step 2 and 3.

Step 2: Run the release batch FP03M and in the additional selection tab select the dunning step and with statistical item.

Step 3: Run the submission batch FP03DM with the above parameters.

Let me know how you go.

Regards,
Rahul

[Former Member]

Hi Rahul,

Thank you for your time.

Sorry, I am not sure what you mean by Dunning Step, Is that Dunning Level?

"Also ensure that the statistical document has the dunning step of the original written off document."  kindly elaborate this.

Thank you

Sruthi

[rahul_paldiwal2]

Hello Sruthi,

I had a question around your dunning process.

Once the customer's final bill is generated why you are doing dunning at the invoice or the document level.Won't it be more effective to do dunning at the account level so that you send one final reminder notice to the customer.

Since you are doing dunning at the document level even after final invoice, you are facing all this issues.

We also had a similar scenario however we convinced business to have below rules for effective collections as well as simplifying the SAP process :

* Dunning to be done at the document/invoice level for active accounts : This will ensure that all the relevant invoices go through all the dunning level/collection steps before disconnection.

* Dunning to be done at the account level once the account is finalised: This will ensure we send one final reminder notice, one legal default letter. This also stream lines the process of write off and referral to collection agencies.

With respect to your question, yes it is dunning level.. Sorry I always mix up between collection step and dunning level.

Regards,
Rahul

[Former Member]

Hi Rahul,

Sorry if I havn't coneveyed it properly, but we are doing dunning at account level only. But after posting final invoicing if there are any charges such as misc charges or return charges, then they will be posted with different due date. so when final billed open items reaches dunning level, other items might not reach dunning because of the duedate.

Also we are not dunning the statsitical write off items,statitical write off items are created after original items reaches last level of final bill dunning. So statistical items won't have dunning level on it.

Please let me know if I am missing something.

Thank you

Sruthi

[william_eastman]

Sruthi:

did you look at receivable adjustment functionality?  Then the write off complications are avoided more easily.

regards,

bill.

[Former Member]

Hi Bill,

I am not sure what it is. Can you please share a document or link to take a look.

Thank you

Sruthi

[AmlanBanerjee]

Hi Sruthi,

Bill is talking about the Doubtful and Individual Value Adjustment (IVA) processes.

Check the following SAP Help Portal link for more info-

http://help.sap.com/saphelp_erp60_sp/helpdata/en/14/eac5536a51204be10000000a174cb4/content.htm?frame...

Thanks,

Amlan