Skip to Content
author's profile photo
Former Member

Issue of Credit Limit as per Sales

Posted on Apr 27, 2011 at 04:04 AM 15 Views

Dear All

I have the requirement from the user the Credit Limit should be updated as per the Sales.

Suppose this month Customer Invoicing is being done for 10 lakh,then its credit limit should automatically get updated to 20 lakh,

If invoicing is being done for 20 lakh,then credit limit in T code FD32 will be getting updated to 40 lakh.

Can you plz suggest me on this issue.

Many Thanks

Rakesh Naveen

SD (Sales and Distribution)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Apr 27, 2011 at 06:14 AM

    Hi,

    I had worked on a similar requirement.This is very well possible with user exit.Check user exit VKMPTZZ,LVKMPFZ1,LVKMPFZ2 and LVKMPFZ3 not sure which one.

    Ask your abaper to write a formula to concancate the sale figure from VBRK table and multiply with 2 and this figure is updated as on last day of the month (Schedule it).It will work perfectly every month no need to manually enter credit limit.

    In my last project the formula was CREDIT LIMIT = (Invoiced value X 1.5) - ( Returns value + credit note value ) + (debit note value) all from VBRK table.This will give you more accurate credit limit figure as returns/credit/debit notes are also considered.you acn check with your client.

    Regards,

    Siraj

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    OD Manikandan
    Posted on Apr 27, 2011 at 05:00 AM

    Hai Rakesh,

    Since user require to update the the credit limit monthly as per the customer month sales.

    Create a USEREXIT in SAPMF02C Credit management program, and schedule it to execute once in a month end.

    and KNKK-KLIMK should get updated with 2 X Receivables of the previous month.

    I dont think this will be in standard functionality.

    Regards,

    Mani

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Apr 27, 2011 at 05:44 AM

      Hello,

      Yes, as per experience, I think your requirement is out of standard of current SAP functions for credit management as automatic. However, you can use some functions as work around, there is a tcode OVA8. You can use credit limit seasonal factor as increase or reduce and check if this suits your requirement. However, any change to this assignment or configuration may lead to ineffective credit checking as the change may affect all customers using the same credit control area without exceptions.

      see this link for your reference on credit management:

      http://help.sap.com/saphelp_40b/helpdata/en/34/60b199ae724effe10000009b38f91f/content.htm

      Otherwise, try user exit enhancement with user 1, 2, 3 check boxes in the same tcode OVA8. Ask your ABAP on possible user exits that can be modified and the complexity of the requirement if feasible.

      Hope this helps.

      Thank you and regards,

      Ria

  • author's profile photo
    Former Member
    Posted on Apr 27, 2011 at 10:18 AM

    Hi,

    need to activate the Credit Management function in SAP SD Module for full functionality.

    Thank You

    Amit Kumar

    Add comment
    10|10000 characters needed characters exceeded