Tag Archives: receipt at risk

Receipt at Risk

From Oracle user guide, it is said that

“In Receivables, you can apply a receipt to an open debit item before cash is actually received from the bank. Therefore, receipts with a Standard remittance method are considered receipts at risk if they have been confirmed, but not yet cleared. Receipts with a Factored remittance method are at risk if they have not yet been risk-eliminated.”

But when I only select  “At Risk” option as “Y” in receipt summary form, not only above two kinds of receipts are displayed. Some receipt with state of “Remitted” and with receipt class “not remittance” are also displayed. It seems that “All not cleared receipts are considered as “At Risk”“. Is it right?

In the last query, it shows

“SELECT …. FROM AR_CASH_RECEIPTS_V WHERE (AT_RISK=’Y’) order by RECEIPT_NUMBER”

Then I view the view definition of AR_CASH_RECEIPTS_V, the most important section is as

“…

DECODE ( NVL(CR.CONFIRMED_FLAG,’Y’), ‘Y’, DECODE( CR.REVERSAL_DATE, NULL, DECODE( CRH_CURRENT.STATUS, ‘REVERSED’,’N’, DECODE( CRH_CURRENT.FACTOR_FLAG, ‘Y’, DECODE( CRH_CURRENT.STATUS, ‘RISK_ELIMINATED’, ‘N’, ‘Y’), DECODE(CRH_CURRENT.STATUS,’CLEARED’, ‘N’,’Y’))), ‘N’), ‘N’) AT_RISK ,

…”

By the way, I refer the section of user guide to introduce the concept of “Include Receipts at Risk in Customer Balance”.

———————————————————————————————————————————————————–

“In Receivables, you can apply a receipt to an open debit item before cash is actually received from the bank. Therefore, receipts with a Standard remittance method are considered receipts at risk if they have been confirmed, but not yet cleared. Receipts with a Factored remittance method are at risk if they have not yet been risk-eliminated.

You can view the number and amount of receipts at risk and their effect on your customer’s open balance in the Receipts Summary window.

To include receipts at risk and receipts that were created by the Bills Receivables Remittance or Maturity and Risk program, select Yes in the appropriate areas in the Find Receipts window.

To display receipts at risk and include them when calculating a customer’s past due balance in the Account Details window, set the AR: Include Receipts at Risk in Customer Balance profile option to Yes. This profile option affects the Account Details window.

If this profile option is set to No, you can choose to include items at risk by performing the following:

  1. Choose the Include Receipts at Risk option from the Tools menu.
  2. Execute your query.

 Important: The AR: Include Receipts at Risk in Customer Balance profile option and the option on the Tools menu do not affect the customer balance calculation in any Receivables standard reports or listings. These options only affect whether Receivables displays receipts at risk and includes them in the open balance calculation for Account Details.”