Business Partner - Average Delay field

[Former Member]

Hi Everyone,

There is a field titled "Average Delay" on the business partner master data screen on the payment terms tab. I have been doing some research on how this field works as we've been asked to create a query to calculate a customer's DSO.

In my research I have found that this field is defined by the user and is used in the cash flow analysis. The cash flow analysis is adjusted according to what the average delay is per customer.

Has anybody set anything up to automatically calculate the average delay for a customer? Or must you calculate this outside of SAP first and then enter the delays into SAP on a regular basis?

It would be helpful and convenient if a formatted search could be used on the field to do the caculcations automatically. Would this be possible and if so, how?

Thank you in advance for your help.

Amanda

[former_member583013 · Accepted solution]

Amanda,

At this time this value has to be calculated manually. The system does not calculate this.

A formatted search can be used to calculate this but it would be a comples one. How would you define the delay? Is it

Actual Payment date - Actual Due Date on Invoice?

What happens in case of installment?

[Former Member · Accepted solution]

Hi Suda,

I agree that it would be rather complex and could vary from person to person.

For example, you asked if the delay should be calculated from the due date or in other words the amount in days it took the customer to pay after their due date. In my case, I would want to see the number of days it took the customer to pay from the posting date. I wouldn't take the due date into consideration at all. Of course, our next customer may want something different and may request the calculation you brought up.

However, because the number entered into this field affects the cash flow statement, we have to be very careful as to how we use it. I've tried testing how this exactly affects the cash flow statement and haven't been able to quite follow it. But for this post, I believe the best answer is to do the manual calculation and manual entry.

Thank you,

Amanda

[former_member583013 · Accepted solution]

If you decide to create a formatted search for this calculating this I would suggest you use a UDF at the BP Master level

Suda