cancel
Showing results for 
Search instead for 
Did you mean: 

Reg: Customer Credit Limit + Varied Amount ( Month Wise)

ravi_kumar100
Active Contributor
0 Kudos

Dear All,

We do have the below credit management requirement for an manufacturing industry.

For a certain Material the company provides an Accrual discount ( Statistical ) to all its Customers. The accrual amount gets accrued for all invoices ( in a Z- Table)  and at the month end various rebate schemes are created ( Z- Table) and the balance accrual gets carry forwarded to the next month.

Current requirement is that the accrual balance appearing at month end has to be included along with the Credit Limit for the Customer.

Ex: Customer Credit Limit : 200000 INR + 12000 INR ( Accrual Balance)

For any sales order the credit check should be against the 212000 INR,

If anyone had come across the similar requirement kindly do suggest.

We are planning  the below options:

1) To change the Credit limit periodically by including the Accrual Balance for every month.

2) Or else Create a Z- Table , store the values of Accrual Balance Month Wise for each customer and refer it during Sales Order creation.

Regards,

SRK

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

There is no standard functionality available in credit management to fulfill your requirement. You have to find out the work around. The options you are thinking is correct but in the second case i doubt the credit exposure will not include the accrued amounts if you just want to by pass the credit limit check by adding the accrued value maintained in the Z table.  

Do u want to by pass the credit limit check during sales cycle by adding the accrual amount or you want the credit exposure to be updated in such cases also?

If you want to update the credit exposure go for enhancement. Use a field in credit master to update the accrual amount every month through a batch job in background. Include that amount in the credit exposure for credit limit check. You can do the same enhancement with your second option if you don't want to use any field in credit master.

S. Satyajit