credit check

[Former Member]

Hello All,

Following is the Scenario.

Customer Credit Limit: INR 1,00,000/-

Credit Period: 20 days

I have sold material to customer worth 80,000/- for period of 20 days. In 20 days customer makes partial payment e.g. 65,000/-. i.e. his outstanding is Rs. 15,000/- which is more than the tolerance limit acceptable to company. Tolerance limit is Rs.5,000/- (Tolerance limit is the amount acceptable by company for any customer which can be kept pending)

Now customer gives new order (with out making payment for previous transaction).

We want to block the order for this customer. i.e. system should do credit check at following,

1) Credit limit i.e. Rs. 1,00,000/-

2) Credit period i.e. 20 days

3) check for Tolerance amount.

Following are the setting done.

1) Credit Limit set as Rs. 1,00,000/- in FD32

2) Credit period set as 20 days in OVA8.

Please suggest me know to check for this tolerance limit.

Thanks and regards,

[Former Member · Accepted solution]

Hi,

FBL5N gives you the open values, the same you can get from sales value(SAUFT) from KNKK table. You can use a lot of fields from transaction FD32(according to the business requirement). You can take the payments terms field(ZTERM) from KNVV table as a reference for days in which the customer has to pay. Other tables VBAK,LIKP,VBRK, T691F. The logic should be dynamic in nature, as the customer purchases are dynamic. The output should be as such, it has to calculate the open sales value dynamically. such as if the customer buys today his credit value will be due in 20days, 2nd sale would be after one week, 3 purchase will be after 21 days...like wise, so the logic in calculation would include all the purchases, taking the terms of payment and delivery date/sales date.

regards

prasad

[Former Member · Accepted solution]

Thanks RVS Prasad,

After going through ur & other input following logic is decided.

a) User Exit LVKMPTZZ, LVKMPFZ1will be used.

b) System will look for amount receivable in Table KNKK - SKFOR (field)

c) If the amount is less than tolerance limit for that customer the system will allow to save the order without looking for

outstanding days.

d) If the amount is greater the system will check for oldest item open from Table BSID + ZTERM Payment Term. If this is greater

than the acceptable limit system will block but if this is less, system will allow to save the order.

Please do comment on it.

Thanks & regards,

Shailendra Panhale

[Former Member · Accepted solution]

Hello,

Please update

Thanks & regards,

[Former Member · Accepted solution]

Hi,

If you stick to your post, your logic works( i.e. If first order is not cleared, all the subsequent orders must be blocked).

regards

prasad