SAP FSCM - Credit Limit Check

[Former Member]

Dear All,

We have relationships maintained in the BP for the Higher and Lower Level, in general when sales order gets created for this combination the limit will be  checked overall and utilized accordingly. in case if the overall limit is fully Utilized then the sales order will be blocked but

We have requirement to block the sales order in case any overdue exist for  any one BP for the above combination , irrespective of higher or lower level relationship. The Sales order should get blocked inspite of the overall limit still available for that relationship combination.

As per the below example inspite of 8L overall limit exist as on 02.12.2015 still the sales order should get Blocked as there is an overdue for one of the relationship BP i.e BP1B as on 01.12.2015

For Ex:

Business Partner	Credit Limit	Sales Orders Created with the payment  01/12/2015	Payment Cleared as on 01.12.2015	Sales Order created as on 02/12/2015
BP1 – Higher Level	5L	5L	5L	1L using BP1 -  this should block as there is a Overdue item in this relation inspite of 8L overall Limit still exist
BP1A – Lower Level	2L	2L	2L
BP1B – Lower Level	3L	1L	Over Due
BP1C – lower Level	1L	1L	1L	50 Thousand using BP1C : This also should block as there is a Overdue item in this relation inspite of 8L overall Limit still exist
Total	11L

Regards,

Reenu John

[Former Member]

Hi Reenu,

For the BADI UKM_CHECK_STEP, copy the implementation UKM_CHECK_110 and enhance it to check for the Age of the Oldest Open line for all the related BPs.

Let me know if it worked

Best

Juan C.

[Former Member]

Dear All,

Has anyone experienced such requirement, Kindly advise.

Regards,

Reenu John

[former_member199199]

Hi Reenu,

In utility industry we had a similar solution with commercial and industrial customer.

There if one of the sites of a company has overdue debt (i.e., credit management score is more than a threshold) and the site BP is a high risk customer, we usually do not allow them to sign up with a flexible product.

At what point of this implementation are you stuck at the moment ?

Thanks,

Bodhisattwa

[Former Member]

Dear Bodhisattwa,

Good Morning:)

Thank You So much for your reply

We have SAP FSCM credit management implemented in our project, the current config for Sales order block is as per below : 

In BP the relationship has been maintained to utilize the overall credit limit irrespective of higher or lower level, hence in the current system the sales order will block only in case if the overall limit has been utilized.

But the new requirement is to block the sales order in case any overdue item exist for the BP irrespective of higher or lower level relationship and inspite of overall limit still available for that relationship combination.

We are not sure which settings we need to change to achive the new requirement in credit management , i tried fue but not successfull in achieving it

Kinldy let me know if you need any further details.

As per the below example inspite of 8L overall limit exist as on 02.12.2015 still the sales order should get Blocked as there is an overdue for one of the relationship BP i.e BP1B as on 01.12.2015

For Ex:

Business Partner	Credit Limit	Sales Orders Created with the payment  01/12/2015	Payment Cleared as on 01.12.2015	Sales Order created as on 02/12/2015
BP1 – Higher Level	5L	5L	5L	1L using BP1 -  this should block as there is a Overdue item in this relation inspite of 8L overall Limit still exist
BP1A – Lower Level	2L	2L	2L
BP1B – Lower Level	3L	1L	Over Due
BP1C – lower Level	1L	1L	1L	50 Thousand using BP1C : This also should block as there is a Overdue item in this relation inspite of 8L overall Limit still exist
Total	11L

Regards,

Reenu John

[former_member199199]

Hi Reenu,

So with the current configuration, you say you are blocking sales order, have you maintained any configuration at BP level or you have put customised valdiation in sales order creation process ?

Thanks,

Bodhisattwa

[Former Member]

Hi Bodhisattwa,

Sorry for delay in response.

All of our Sales Order Block config is standard nothing has been customized.

We have done the configuration under SAP FSCM credit management module to Block the sales order.

Regards,

Reenu John

[Former Member]

Hi Bodhisattwa,

Please share the score details, I will check in my system to add that with some modifications and see will it works for our requirement.

Regards,

Reenu John

[former_member199199]

Hi Reenu,

I think the configuration you are talking about is the score calculation formula ?

Thanks,

Bodhisattwa

[Former Member]

Hi Bodhisattwa,

Yes , once i look into that i may get some idea , hence please share your advice.

Regards,

Reenu John

[former_member199199]

I think you are using below configuration path to restrict the sales order, can you pls confirm the formula you are using (because this is where I used to configure when I was wokring in utility industry)?

IMG -> FSCM -> Credit Management -> Credit Risk monitoring -> Master data -> Define formulas

If yes, please share the formula logic you are using.

Thanks,

Bodhisattwa

[Former Member]

Hi Bodhisattwa,

Thanks For The Reply

In our system sales order is getting blocked as per the below settings i.e

Financial Supply Chain Management > Credit Management > Integration with Accounts Receivable Accounting and Sales and Distribution > Integration with Sales and Distribution >Define Automatic Credit Control

As of now there is no formula defined, I can see only the below two standard formulas are exist

There is one option under "Define Automatic Credit Control " i.e "Open Items" when I did F1 I got the below details , i am not sure if i set Reaction "B" & Status / Block "check box" for this will it work or not.

Credit check against overdue open items

Specifies whether the system carries out a credit check based on open items.

Use

This type of credit check works in conjunction with two values that you specify in the adjacent fields:

• Maximum % of overdue items in open items

• Number of days which the open items are overdue

The proportion of overdue open items (that exceed the specified number of days) in the total of open items should not exceed the percentage specified.

Regards,

Reenu John

[former_member199199]

Thanks Reenu.

The process is a bit different as what we have used in utility.

Still, I think if you select option "B" and keep the check box ticked, it would work. But also you have to think about the Max open item % and no. of days item open.

And keep the check box ticked which is 'status/block'.

Hope it would work. Please let me know how you go.

Thanks,

Bodhisattwa

[Former Member]

Hi Bodhisattwa,

Ya sure, will follow the above steps and test.

I will let you know the results, I hope it should work.

Regards,

Reenu John