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
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
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 a comment