Sales Distribution SD Module User Exit - Past Due Credit

[Former Member]

Hi

Would like to consult on weather it is possible to ask a SAP developer to develop user exit for Credit Block to ignore, and let the Sales Order go to billing if:

1. If risk category: N01 (we set it up as low risk customer) and past due not more than $5,000 (including a credit where a customer has not taken for longer than certain days, and therefore triggers Past DUE)

2. All risk category with past due not more than $5000, regardless hwoever many days it has been past due.

Our situation here is big distributors take their own sweet time to take their chargebacks. We have only 4 big distributors, and we don't want to hold any of their orders, and tired of releasing orders that are not really triggered by "past due".

thank you

[VeselinaPeykova · Accepted solution]

Isn't this possible with OVA8 routines?

The only difficult part is, that you don't wish t use percentages, but a hard amount.

Our situation here is big distributors take their own sweet time to take their chargebacks. We have only 4 big distributors, and we don't want to hold any of their orders, and tired of releasing orders that are not really triggered by "past due"

I am confused. Aren't these charge-backs items in BSID for these KUNNR with SHKZG eq 'H'?

In standard SAP, I think ,such items are not considered for overdue checks - check LF035F00.

[Former Member · Accepted solution]

Veselina,

that is what i have been told. Im a user and i will submit this to our SAP in-house bus.analyst.

I will check your recomendation: OVA8 and LF035F00

This is an attempt for a "2nd" opinion and holding our SAP in-house team accountable. So thanks for your answer.

On the last comment, i have access to SQVI and therefore would be able to check those value. Without going to tables, can i check on FBL5N?

last but not least, i know on VKM1 when releasing i can see the reason a particular Sales Order is being held for. Dyna Mavo OlIt, when it is A A B, i know it is being held due to Past Due (Oldest Items).

How/where do i found out, as a normal user, what has been set in each risk category to trigger past due?

[VeselinaPeykova · Accepted solution]

Hello Yan,

if you need to get a second opinion and ideas on technical realization before you have even spoken to your consultants, then there is something wrong with the procedures and the working atmosphere in your company.

Checking customizing (OVA8) or reading code (LF035F00) is not how as a business user you can contribute best, if you wish to develop in such direction, maybe you can apply for a position in your SAP department.

It is a bad idea to base your opinions on your in-house experts from a post in an internet forum from a random person who has no access to your configuration, developments etc.

If one of my users needs to know specific configuration details, all he has to do is ask, and I would send him the data and explain the setup. Maybe you can also ask your consultant to provide you the information.

The authorization team has been really generous to grant you SQVI. Yes, there is a way to check lots of things with it, but there is a reason why you have no OVA8 display access, so giving you ideas how to bypass restrictions and check configuration will be irresponsible.

As to SHKZG - this one you can see in user transactions, it is the debit/credit indicator.

[Former Member · Accepted solution]

Thank you for your advise and opinion.

I see where you coming from especially as an SAP developer dealing with business user like me who trying to be a "smart-ass" by using the word "2nd opinion" "holding our SAP team accountable"

I assure you that is not my attention. I am just trying to do with limited IT resources we have, tickets are backlogged and I have to gain understanding faster than the projected time they have allocated for our dept. When it comes to our time, I can speak some of the "language" and perhaps they can understand it right away. That is all.

Also although I have a curious mind, in no way I have the knack to go/or develop skills in this direction, this is just an attempt to help the team here. I do read and compare, and make judgment as to which advise/opinion from a "random person" (you are not random by your historical posts and/or badges btw - you're an expert) to take in.

Back to OVA8, apparently I do have view access. "no modification"

And I can see each Risk Category has CG 01 and CG 02 with some details in it. I can see now what triggers past due for each risk category.

Your first comment was % was not a good idea, but I see theres  Max.open.item%. With credit Limit 1M, would putting 1% ignore all past due items up to $10,000?

Where in OVA8 can a setup for specific amount be set?

[VeselinaPeykova · Accepted solution]

Hello Yan,

my intention was not to scold you, it is great that you are trying to help.

The problem with getting an opinion from people in SCN is that we have no access to check the setup in your system or be aware how a certain solution would impact the business processes in your company.

People who usually seek advise here, can check the customizing and can obtain documentation of the company-specific developments, read the code, access SAP notes etc. With your current role this can be challenging.

It can happen that my idea is not suitable, because it conflicts with a certain setup and your SAP team would probably choose a different approach that takes more time to implement and test. So if the consultant tells you that something is really complicated and will take a lot of time and effort to implement, it is possible that he has some reasons - you can ask him to explain you how they are planning to implement the change and what will be the impact on other processes.

Maybe you can ask the SAP team if they need help with preparing good examples in a test system or with testing the solution - this could speed up the process.

As to my comment on percentages - I meant it is usually better and easier to use percentages instead of hard amounts. The check on open items is not directly related to credit limit - open items are the documents you see in FBL5N. There you can have normal items and also some items with special G/L indicator taken into account.

Imagine you have customer A with open items for 10 000 and from these 1 500 are overdue for more than 5 days. You have in OVA8 setting for 5 days and 10 %. This means that the next order will be blocked because of overdue items. If your setting is 5 days and 20 %, then it will not be blocked.

If you have 0 days for overdue and you have 10 000 total, out of which 1500 are overdue for 5+days and 200 are overdue with 1 day, then the check will be done against 1 700 and not against 1 500 as in the first example.

For most of your customers you wish to have zero days tolerance (all overdue items should be considered in the check) and only for low risk ones you will consider overdue items after X days of being overdue. If what I explained about percentages and days is sufficient for your processes, then probably it will be mostly configuration effort and testing. If you really need a check against hard amounts, then this involves also development, because such setting does not exist in standard.

If you go for development in credit management, please make sure that you and your colleagues test all possible scenarios end-to-end before it gets to your production environment.

[Former Member · Accepted solution]

Thank you, it seems very clear to me and straightforward.

[Former Member · Accepted solution]

Veselina,

one last question on max % item. When we set it as 1% and letsay total past due 10 000 which means 1% = 1000.

does that 1000 means anything up to 1000 or will it take into account credit memo past due of -1500 as 1500 instead of negative 1500?

We have chargebacks and credit memo that customer have not taken for well over 90 days. we dont want this to block future sales order because these are credits to the customer and not really past due invoices.

your reply is greatly appreciated. Thanks.

[VeselinaPeykova · Accepted solution]

In my previous post I mentioned that open items with credit indicator are not considered for overdue checks at all (not selected for the check) in standard SAP.

It has been a long time since you posted.

I believe it is time to start discussing the various business cases with your local consultants.

This specific question was easy to answer, because it was about the standard SAP behavior, but for sure there will be scenarios, which occur in your company that you might have forgotten about and of which I will not be aware.

Your in-house SAP consultant can be really useful for you in this situation, because he/she will start asking: but what about process X, what about customer group Y etc...