Thursday, 26 April 2018

Customer Credit Limit Failure Hold

Understanding Credit Check Failure Hold Message in messaging window: 

During credit checking process, first the ‘Overdue invoice’s’ is validated, if it fails then the Order goes on hold. The credit check failure hold message will indicate the hold applied due to ‘Overdue invoice’. 
- If the first validation passes through then ‘Order Credit Limit’ is checked, if the order amount is greater than ‘Order Credit Limit’ set then Order goes on hold. The credit check failure hold message will indicate the hold applied due to ‘Order Credit Limit’. 
- 
If second level validation passes then the 'exposure/outstanding' balance is calculated based on the ‘Credit Check Rule' set up and it is validated with the 'Overall Credit Limit' defined. If exposure is found to be exceeding the overall 
Credit Limit then the order goes on hold. The credit check failure hold message will indicate the hold applied due to exceed in Overall Credit Limit. At this stage to find available the following formula explain this...Available = Overall Limit 
- Exposure Positive Exposure means Customer Outstanding and Negative 
Exposure means Customer balances/advance.The exposure amount calculated will depend on the Attributes checked in credit check rule in Exposure Tab. 
If customer has overall limit of $1000 and exposure is 500 then 
Available = 1000 - 500 = 500 
If customer has overall limit of $1000 
and exposure is -500 (advance paid bycustomer) then 
Available = 1000 -( - 500) = 1500. 

The Credit exposure report will show the total exposure amount based on the attributed checked in the credit check rule, this report does not show the exposure amount of each individual attribute. The simple method is to toggle the attributes on the credit check rule and rerun the credit exposure report and examine the impact. For example if the report shows current exposure amount of $1000 and the credit check rule used has ‘Include Open Receivables Balance’ and ‘Include un-invoiced Orders’ 
checked, you may uncheck one of the attributes and then rerun the credit exposure report to see the impact. If the exposure amount is due to ‘Include Open Receivables Balance’ then customer will need to check the AR balances in AR by running the aging reports in AR. If the exposure amount is due to ‘Include un-invoiced Orders’ this means exposure of all orders currently Booked and Not Invoiced. Term ‘Not Invoiced’ means Orders which are closed from OM and data for the same lying in RA_INTERFACE_LINES_ALL waiting for the invoicing. 

For checking the open receivable balances you can run AIGING FORM 
Receivables> collections>collections 
Use flash light, enter account number, and then do search. 
Click on Aiging TAB. 
Check Include Receipts at Risk check box and hit display button. 

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...