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.
This blog is for Oracle Ebs, Fusion and OIC Techno- Functional People. I am sharing my work experience through this blog.
Thursday, 26 April 2018
Customer Credit Limit Failure Hold
Subscribe to:
Post Comments (Atom)
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...
-
P2P CYCLE: INVENTORY=> REQUIESTITION=> RFQ=> QUOTATION=> QUOTATION ANALYSIS=> PURCHASE ORDER =>...
-
Order to Cash (O2C) Cycle with in Oracle Apps Enter the Sales Order Book the Sales Order Launch Pick Release Ship Confirm Create In...
-
---------- 1) Below given query can be used TO get concatenated Gl code combinations segment AND its description USING API GL_FLEXFIELDS_PK...
This comment has been removed by a blog administrator.
ReplyDelete