Skip to Content
0
Jan 30, 2020 at 03:22 PM

Credit limit calculation- above the standard formulas

120 Views

Hi,

we are looking at the FSCM credit manamgent an see some examples there for the calculation of limits.

However, not sure whether there is something available on top of this.

Has someone done any work in here?

We would like to have limits based on sales in past (figure from KPI in master record for last year, or even a number of years) and days in payment condition.

how would I do a formular like this:

Yearly sales divided by (360 days divided by number of days in payment term).

Example: Sales = 100'000

Payment term = 30 days

formular should then calculate: 100'000 / (360 / 30) = 8'334

Thank you in advance!

Hein