This chapter covers the following topics:
With automated cash application processes you can respond to the multiple ways customers have arranged to remit payments easily, including lockbox, and electronic payment through direct debit, Automatic Clearing House (ACH) and credit cards. Use seeded cash application rules, or define your own, to automatically create receipts and apply them to billing charges quickly and accurately with minimal manual intervention. When exceptions occur, manage receipts manually to correct receipts and invoice balances quickly.
Record and apply payments received to the appropriate billing charges either manually or automatically in Oracle Lease and Finance Management. When you create a receipt, capture receipt details that may include the payment amount, customer account, contract number, invoice number, invoice lines or consolidated invoice number migrated from prior releases.
Record the receipt of payment from multiple sources through alternative processes. When you have defined agreements with customers to remit payments automatically to your account through direct debit or ACH transfers, you can create the receipts automatically in Oracle Receivables. When customers make credit card payments to your account, you can also create the receipts automatically.
You may have agreements with third party commercial banks or agencies that collect lockbox payments on your behalf. When customers remit payments to the lockbox, the agency processes the payments and transmits files electronically to record the receipt in Oracle Receivables.
When customers remit payment by check or cash in the mail, you can either record the receipt individually or in a batch. In a batch of receipts, Oracle Lease and Finance Management captures batch ate, remittance bank, general ledger date and user defined attributes so you can:
Create one receipt against a contract and another receipt against an invoice.
Create a batch with a past due date.
Use different bank accounts to remit payment using the same receipt method.
Account for receipts on a different date than the batch date.
Capture receipt information specific to your organization.
Resubmit erroneous batches after rectifying errors.
Advance receipt- record prepayments, such as security deposits, to contracts before they are booked to ensure that prospects are serious about negotiating and signing contracts.
Once receipts are recorded, identify the invoice detail to match the payment to the appropriate billing charge. Define cash application rules in Oracle Lease and Finance Management to process receipt application automatically. Automatic receipt application is vital to efficient cash management and collections efforts and timely, accurate receipts management reduces costly reconciliation and adjustments. In Oracle Lease and Finance Management you can apply the following types of manual receipts to invoices or contracts:
Apply batch receipts
Apply Direct Debit or ACH receipts
Apply receipt automatically for regular payment
Apply receipt automatically for one-off payment
Apply Lockbox receipts
Apply receipt manually for individual payments
Apply Advance receipts to unbooked and booked contracts
Revenue recognition and accounting for the receipts process occurs in Receivables. Receipt accounting is based on accounting details defined in the Receivables Accounting Template.
When customers remit payments with insufficient information to identify the correct billing charge, you can apply the receipt to On Account in Oracle Lease and Finance Management. When the details accompanying a payment are insufficient to identify a customer account, you can apply the receipt to an Unapplied account in Oracle Lease and Finance Management.
When account balance reconciliations require adjustments or when customers dispute balances, adjustments may be required to correct applied receipts. Unapply payments and then reapply them to invoices. You can make the following changes to applied receipts:
Update receipt customer details
Update receipt
Update receipt application
Update receipt application by invoice line
Update receipt application by stream type
Reapply receipt application
Use extensive search criteria in Oracle Lease and Finance Management to search and view all receipts created in Oracle Receivables and Oracle Lease and Finance Management.
You can create receipts using the following methods:
Uploading files using AutoLockbox.
Entering receipts details using the Lease user interface.
Creating automatic receipts.
You can create receipts manually using the user interface in Oracle Lease and Finance Management. Oracle Lease and Finance Management lets you create individual receipts and in a batch.
You can create receipts either against contracts or invoices with Auto Application in a batch.
To create and apply receipts in a batch, perform the following step:
Create a batch and add receipt details to batch.
Submit the batch.
Process the batch.
To create a batch, perform the following tasks:
In the Batch Receipts page, click Create Batch.
Enter the batch details.
Enter the receipt details for each receipt in the batch as described in the Create Batch Receipt Field Descriptions table.
Click Apply to save the batch.
Note: By default the batch status is set to Working. Keep the batch status to Working if you need to add more receipts to the batch later.
Field | Description |
---|---|
Operating Unit | Operating unit assigned to the record.
Note: The list of values includes operating units assigned to the MO: Security profile. |
Batch Name | Batch Name |
Batch Total | Batch Total |
Batch Date | Batch Date |
GL Date | GL Date |
Currency | This can be either the ledger currency or the contract currency. If your receipt currency is the same as the ledger currency of your organization, you can ignore the currency conversion fields. |
Receipt Method | To process payments. |
Remittance Bank Name | Bank name to remit payments. |
Remittance Bank Account | Bank account to remit payments. |
Currency Conversion Type | If your receipt currency is not the same as the ledger currency of your organization, select the currency conversion type. |
Currency Conversion Rate | If you selected User as the Currency Conversion Type, enter the currency conversion rate. |
Currency Conversion Date | If you selected a value other than User as the Currency Conversion Type, enter the currency conversion date. This date enables Oracle Lease and Finance Management to determine the appropriate currency conversion rate for the currency conversion type you selected. |
Status | Batch Status |
Once you complete the entry of all receipts for a batch, change the batch status to Submit and click Apply. On submission of a batch, Oracle Lease and Finance Management compares the batch total entered by you at header level with the total of receipt amount for all the receipts in the batch. If these totals match, Oracle Lease and Finance Management submits the batch and makes it available for processing. If the totals do not match, Oracle Lease and Finance Management displays an error and does not submit the batch.
Important: Once submitted, you cannot change the batch details, receipt details, and add or remove receipt details.
Oracle Lease and Finance Management processes batch receipts by auto applying receipts based on the cash application rule. Only batch receipts with Submitted status is processed.
To process the submitted batch, perform the following tasks:
Log on to Oracle Lease and Finance Management using Lease Administrator responsibility.
Run the Concurrent Cash Application program.
On submission, Oracle Lease and Finance Management processes each batch with status submitted, or resubmitted for the selected operating unit. The Concurrent Cash Application checks for the following:
Validates the batch and receipt details.
If all the details are valid for the batch, Oracle Lease and Finance Management creates the receipts and auto applies receipt to invoices based on the cash application rule. See: Auto Application.
Changes the status to Process.
Even if one or more details are not valid, Oracle Lease and Finance Management does not process the batch and changes the status to Errored. You can correct the errored batch and resubmit the same for processing.
Note: The receipt entered in a batch are created only after processing. Before processing, you cannot update the receipts entered as a part of batch. When you search for receipts in Oracle Receivables or Oracle Lease and Finance Management, only the processed receipts are available.
Important: Oracle Lease and Finance Management creates individual receipts in Oracle Receivables even for receipts created as a part of batch and does not create batches in Oracle Receivables.
You can rectify the batches with error and resubmit them. Resubmitted batches are processed again by the Concurrent Cash Application program.
To rectify and resubmit a batch with error, perform the following tasks:
On the Batch Receipts page, search for the batches and click Update.
On the Update Batch page, Oracle Lease and Finance Management displays error message against receipts with invalid data.
Based on the error, you update either batch details or receipt details with valid details.
When navigate to the Update Batch page, the status of the batch is changed from Errored to Error Correction.
Once you update the details for all the errors, change the batch status to Resubmit and click Apply.
The batch is now available for processing.
You can create Unapplied, On Account, Unidentified, Advance, or Applied receipt using the Create Receipts page. In case of applied receipt, you can also use Auto Application. To use auto application, you must create receipt against a specific invoice or a contract.
To create a receipt, complete the following tasks:
In the Search Receipts page, click Create Receipt.
Enter the receipt details. Refer to the Create Receipts Field Descriptions table for the field descriptions.
Select the cash application criteria to apply the receipt amount to the invoices.
Click Apply.
Based on the selected cash application criteria, Oracle Lease and Finance Management performs the following:
Application Criteria and Customer Name not specified: Creates an Unidentified receipt.
Note: You can later enter the customer details on an Unidentified receipt and convert it to an Unapplied receipt.
Application Criteria not specified and Customer Name specified: Creates an Unapplied receipt.
Advance: Creates an Advance receipt. See: Creating Advance receipts
Contract Number or Invoice Number: Auto applies the receipt to open invoices based on the cash application rule. See: Auto Application.
Note: If you want to review and update the cash application based on the Auto application, then select Review. Oracle Lease and Finance Management will redirect you to update cash application page after performing auto cash application.
Future Pay: Creates a Future Pay receipt.
Manual: Allows you to select invoice lines manually to which you can apply receipt.
On Account: Creates an On Account receipt.
The following table describes the fields on the Create Receipts page.
Field | Description |
---|---|
Operating Unit | Operating unit assigned to the record.
Note: The list of values includes operating units assigned to the MO: Security profile. |
Receipt Number | The identification number of a payment, such as a check number. |
Receipt Date | Specify the Receipt date for payment. |
GL Date | Specify the GL date for receipt. |
Receipt Amount | Amount of the receipt. |
Receipt Currency | Currency of the receipt. |
Receipt Method | To process payments. |
Remittance Bank Name | Bank name to remit payments. |
Remittance Bank Account | Bank account to remit payments. |
Customer Name | Name of the customer. |
Customer Bank Name | Name of the customer's bank |
Customer Bank Account | Customer Account number |
Currency Conversion Type | If your receipt currency is not the same as the ledger currency of your organization, select the currency conversion type. |
Currency Conversion Rate | If you selected User as the Currency Conversion Type, enter the currency conversion rate. |
Currency Conversion Date | If you selected a value other than User as the Currency Conversion Type, enter the currency conversion date. This date enables Oracle Lease and Finance Management to determine the appropriate currency conversion rate for the currency conversion type you selected. |
Criteria | Select the application criteria for receipt. If you select contract number or Advance as application criteria, then specify the contract number against which the payment is received. If you select Invoice as application criteria, then specify the contract number against which the payment is received. |
Flexfield | Oracle Lease and Finance Management captures the user-defined information based on the definition of Descriptive FlexField (DFF) "Receipt Information". You can create user-defined information based on the DFF functionality to store additional information. See:Descriptive Flexfields, Oracle Receivables Implementation Guide |
Oracle Lease and Finance Management allows you to create advance receipts against booked or unbooked contracts. You can also specify the stream types against which an advance payment is received.
When you create an advance receipt, Oracle Lease and Finance Management redirects you to Receipt Allocation page by clicking Apply on the Create Receipt page.
On the Receipt Allocation page, optionally you can specify the stream types and amount received against each stream type.
You can generate invoices against advance receipt through the Advance Billing process. The Advanced Billing process generates invoices based on advanced receipts and are then applied to these invoices automatically. The Automatic Cash application is based on Receipt Allocation. If there is no receipt allocation defined for the receipt, then the receipt application will be based on the CAR. See: Auto Cash application.
Note: If the advance receipt is against unbooked contract, you can generate invoices through advance billing only after the contract is booked.
AutoLockbox is a facility that Oracle Receivable provides you to eliminate manual data entry by automatically processing receipts that are sent directly to your bank.
Additional Information: Creating and applying lockbox receipts is an automatic procedure that occurs in Oracle Receivables.
The standard Autolockbox procedure is a three step process:
Import: An SQL* Loader script uploads the data from the bank file to the Autolockbox tables.
Validate: The validation program validates the uploaded data.
Post Quick Cash: Receipts are applied and the customer balance is updated.
See: Using AutoLockbox, Oracle Receivables User Guide.
Oracle Receivables does not provide for auto cash application based on stream type or at line level. Oracle Lease and Finance Management extended the Auto Cash application to provide the cash application based on Lease specific Cash Application Rule (CAR) and cash application at line level.
To use the Oracle Lease and Finance Management Auto Cash application, set the Line Level Cash application to Oracle Lease and Finance Management while setting up AutoLockbox in Oracle Receivables. When you process AutoLockbox in Oracle Receivables, it uses the cash application logic provided by Oracle Lease and Finance Management if the line level cash application is set to Oracle Lease and Finance Management.
See: Lockboxes, Oracle Receivables Implementation Guide
Oracle Lease and Finance Management first checks whether the receipt is against the Leasing related invoice, contract, or termination quote. For this Oracle Lease and Finance Management uses the reference number provided in the Lockbox, field types Invoice 1, Invoice 2, ... in the record type overflow payment.
Oracle Lease and Finance Management validates the following:
If the receipt is without any reference number or has a non leasing invoice as a reference number, then Oracle Lease and Finance Management does not perform Auto Cash application. For such receipts, Oracle Receivables Auto Cash application is performed. See: AutoCash, Oracle Receivables User Guide.
If the receipt is against Leasing related Invoice or Contract, then Oracle Lease and Finance Management automatically performs line level cash application based on cash application rule (CAR) set up in Oracle Lease and Finance Management.
If the receipt is not related to any of the above two conditions, then Oracle Lease and Finance Management checks whether there any open invoices for the customer. If open invoices for the customer are present, then Oracle Lease and Finance Management applies cash based on the Receipt Mismatch rule. If there are no open invoices for the customer, then Oracle Lease and Finance Management checks whether the receipt is related to any termination quote. If it is related to the termination quote then Oracle Lease and Finance Management processes the termination quote.
The Receipt Mismatch Rule is meant only to process lockbox receipts. The following three options apply to defining the Receipt Mismatch Rule:
<BLANK> - The BLANK value has no functionality in Oracle Lease and Finance Management.
Apply to Oldest Invoice First
Apply to Newest Invoice First
Oracle Lease and Finance Management identifies the Receipt Mismatch Rule from the default cash application rule at the operating unit level. The Receipt Mismatch Rule determines whether the mismatch rule was created. When the Receipt Mismatch Rule is set up to apply mismatched receipts to On Account, Oracle Lease and Finance Management ignores the BLANK value set for the receipt mismatch rule and continues to process receipts.
Oracle Lease and Finance Management checks the following:
Identifies the Amount Tolerance percentage and the number of days for the termination quote from CAR associated contract. If no CAR is associated to contract, Oracle Lease and Finance Management uses the default CAR.
If the receipt amount is within termination quote amount plus or minus tolerance amount and the receipt date within Termination Quote Date + Number of days for Termination Quote then Oracle Lease and Finance Management starts termination quote processing.
Creates receipt as unapplied receipt.
You can use the Automatic Receipts feature of Oracle Receivables to automatically generate receipts for customers with whom you have defined payment agreements, such as payments through direct debit.
See: Creating Automatic Receipts, Oracle Receivables User Guide
See: Creating Remittance Batches, Oracle Receivables User Guide
When you create a receipt against an invoice or a contract , Oracle Lease and Finance Management applies the receipt automatically using the Cash Application Rule (CAR).
For automatic application, you must set up at least one cash application rule for an operating unit and make it a default cash application rule. It is important that all the billable stream types in the contracts covered by the invoice are defined in the appropriate cash application rule.
See: Define Cash Application Rules, Oracle Lease and Finance Management Implementation Guide
Each open line, having balance greater than zero, related to reference object is considered as Auto Application if the reference object is Oracle Lease and Finance Management related AR invoice or Contract.
If the receipt is against the contract, then Oracle Lease and Finance Management uses the cash application rule associated with the contract. If the contract is not associated with any cash application rule, then Oracle Lease and Finance Management uses the default cash application rule at the operating level.
If the receipt is a Oracle Lease and Finance Management related AR invoice, however, all the open invoice lines identified are for the same contract then Oracle Lease and Finance Management uses the cash application rule associated with the contract. If the contract is not associated with any cash application rule, then Oracle Lease and Finance Management uses the default cash application rule at the operating level.
If the receipt is a Leasing related Receivables invoice and the open invoice lines identified are for different contract but with the same CAR associated to each contract, then Oracle Lease and Finance Management uses that CAR. If none of the contract is associated with any CAR then Oracle Lease and Finance Management uses default CAR at the operating unit level.
If the receipt is a Leasing related Receivables invoice and the identified open invoice lines are for different a contract and the same CAR is not associated to each contract and all the contract has the same start date then Oracle Lease and Finance Management uses the default CAR at operating unit level.
If the receipt is a Leasing related Receivables invoice and the identified open invoice lines are for different contract and the same CAR is not associated to each contract and all the contract does not have same start date then:
Oracle Lease and Finance Management groups the contracts with same start date.
If the same CAR is associated to each contract in the group then Oracle Lease and Finance Management uses that CAR for the group.
If the same CAR is not associated to each contract in the group then Oracle Lease and Finance Management uses default CAR for the group.
Oracle Lease and Finance Management starts applying cash to the group having earliest date and second earliest and so on.
You can apply Cash to an invoice line based on CAR. To apply Cash, perform the following tasks:
If the receipt is Under Payment and the underpayment rule is "Move to Unapplied" then Oracle Lease and Finance Management does not apply receipt to any invoice line and creates an unapplied receipt.
If the receipt is Under Payment and the underpayment rule is "Apply based on Transaction Type" then Oracle Lease and Finance Management first applies to the invoice with a stream type having lowest sequence number in CAR. If still there is some unapplied amount on the receipt, Oracle Lease and Finance Management selects the stream with sequence number and so on.
If the receipt is Under Payment and the underpayment rule is "Prorate", then prorate the receipt amount in proportion of line balance to each invoice line with the stream types selected for prorating in CAR.
If the receipt is Over Payment and the overpayment rule is "Move to unapplied" then Oracle Lease and Finance Management applies the receipt amount to each line in full and keeps the remaining receipt amount as unapplied.
If the lockbox receipt is Over Payment and the overpayment rule is "Apply to Customer Balance," Oracle Lease and Finance Management ignores the Apply to Customer Balance rule and continues to process the cash application.
If the payment is within tolerance, Oracle Lease and Finance Management applies the receipt to each invoice line in full in the sequence in which they were created.
In Oracle Lease and Finance Management, you can search for receipts created from all sources including Lockbox and manual receipts in either Receivables or Oracle Lease and Finance Management. You can also view and update receipt applications for all the receipts in Oracle Lease and Finance Management.
You can find manual receipts by performing a list search in the Receipts tab of the Operations page. List search is a search tool that helps retrieve information quickly and easily.
Perform the following steps:
Click Show Filters.
Select the objects using the following filters:
Operating Unit (mandatory field)
Receipt Number
Customer
Contract Number
Invoice Number
Receipt Date: This field uses a range of dates.
GL Date: This field uses a range of dates.
Amount: This field uses a range of amounts.
Receipt Method
Advance Receipt
You can also include the following additional filters to the search criteria by clicking Add:
Currency
Customer Number
On-Account Amount: This field uses a range of amounts.
Unapplied Amount: This field uses a range of amounts.
Unidentified Amount: This field uses a range of amounts.
Note: You can remove the additional filters from the search criteria by clicking the remove filter icon next to each added criteria.
Click Go.
The search results are displayed.
You can save searches by performing the following steps:
After selecting filters, click Save.
Perform the following actions in the Create Saved Search region:
Enter a name for the saved search in the Name field.
Select the Display in Tile checkbox to display a tile having this search's details in the Receipts tab.
Additional Information: Tiles display the count of search records for the defined search filters. This count can be refreshed by clicking the refresh icon present on each tile. Clicking on a tile will show the filters selected for this saved search.
Select the Set as Default checkbox to make a saved search as the default search.
Click OK.
Even if a saved search is not saved as a tile, it will be displayed in the drop down beside Show Filters/Hide Filters. You can manage saved searches by clicking Manage Saved Search in this drop down.
Note: You can disable list search using the Disable List Search button in Table Diagnostics. After disabling list search, you can find manual receipts by performing either a simple or advanced search.
A simple search on the Receipts tab includes the following parameters:
Operating Unit (mandatory field)
Receipt Number
Customer
Contract Number
Contract Number
Receipt Date From
Receipt Date To
An advanced search allows you to expand or refine their search criteria.
Once you search the receipt, you can view the receipt and receipt application details by clicking the receipt number.
You can view the receipt application details either in a details mode or a summary mode. In the detail mode, Oracle Lease and Finance Management displays the line details and application amount for each invoice line to which the receipt is applied. In the summary mode, Oracle Lease and Finance Management groups the receipt application by stream and displays stream type and amount applied to the stream type.
Important: You can view the search results at stream type level. By default, the view is the Summary mode. In this mode the invoice lines are grouped by streams. In the Detail mode, all the streams are grouped together.
You can decide the default view mode. Set the OKL: Number of Receipt Applications to Default Summary View profile option to the Default Summary view. If the number of receipt application line is equal to or more than the value set for this option, the default view mode is Summary otherwise it is Detail.
In Oracle Lease and Finance Management, you can:
Update Unidentified Receipts.
Update Receipt Application.
Update Advanced Receipt Allocation.
Mass apply on account or unapplied receipt amount to open invoice through Receipt Reapplication.
You can add customer details to an unidentified receipt by updating the receipt. When you add customer details to an unidentified receipt, Oracle Lease and Finance Management changes the receipt from unidentified receipt to unapplied receipt.
To add customer details to unidentified receipt:
Navigate to the Receipts page.
Search for the receipt.
Click a receipt number to navigate to the Receipt Details page.
Click Update.
Note: If the receipt is an unidentified receipt, Oracle Lease and Finance Management redirects you to the Update Receipt page.
Add the customer details.
You can update the following receipts:
Fully unapplied or On Account receipt: You can add receipt application details by adding invoice lines to apply receipt to.
Partially or Fully applied receipt: Add receipt application, unapply existing receipt application, change the applied amount for existing receipt application, change on account amount or application GL date.
Update receipt applications by creating receipt applications to unapplied or on account receipt or change receipt application for already applied (fully or partially applied) receipts. You can change the application amount for existing application, unapply the existing application and add new invoice lines for application.
You can add new invoice lines and fully apply the amount or manually enter the amount to apply to the invoice. You can update the application in either the Summary or the Detail view.
To update receipt applications:
Navigate to the Receipts page.
Search for the receipt.
Click a receipt number to navigate to the Receipt Details page.
Click Update.
Note: If the receipt is neither an unidentified nor an advance receipt, Oracle Lease and Finance Management redirects you to the Update Receipt Application page.
You can update the receipt application either at summary level or detail level.
To update receipt application at the detail level, set the view mode to Detail on the Update Receipt Application page.
Adding Invoice Lines to Apply Receipt To
To add invoice lines, perform the following steps:
Navigate to the Cash Application page.
Click Add Invoice Lines.
Note: Oracle Lease and Finance Management displays the list of invoices lines having an open balance that matches the search criteria you entered.
Select one or more invoice lines to apply a receipt to and click Add.
Oracle Lease and Finance Management adds the invoice lines to receipt application with zero applied amount.
Enter the amount to be applied against each invoice line.
Note: If you want to fully apply one or more invoice lines, select those invoice lines and click Fully Apply.
Unapply Receipt Application
To unapply receipt applications:
To unapply receipt application, set the applied amount for receipt application line to zero.
Select the lines and click Unapply.
Update Existing Receipt Application
To update existing receipt application, change applied amount and/or GL date.
Note: Invoice line consists of line amount and tax amount. The total of line amount and tax amount is line total. You can apply receipt to invoice line either at the Line total level or at the line amount and tax amount level. When you apply receipt at line total level, Oracle Lease and Finance Management derives the applied amount for line and tax by prorating the applied amount. To prorate the outstanding line amount and outstanding tax amount is taken as base. To apply amount at line total level select Line Total in apply to field. To apply amount for line and tax separately select Line amount and Tax in apply to field.
Once you complete the above, click Apply.
The receipt balances displayed on the Update page are not updated automatically based on changes. To view the updated balance based on changes, click Recalculate to refresh the balances on the page. Click Apply to save the changes.
To update receipt application at Summary level set the view mode on update receipt application page to Summary. In the Summary view mode, you can update the receipt application at the stream level. The process of adding invoice lines, fully applying or unapplying the receipt amount is similar to that in the 'Detail' view mode. You can Fully apply or Unapply the receipt amount at the invoice line level and not at the stream level.
Add Invoice Lines to Apply Receipt To
You can add invoice lines in the Cash Application page. The steps to be followed to add invoice lines in summary mode is same as in detail mode. When you add invoice lines in summary mode, Oracle Lease and Finance Management groups the added invoice lines by stream type and currency. If the receipt application already exists for a combination of stream type and currency, then Oracle Lease and Finance Management adds the selected invoice lines to the existing summary line. If the receipt application does not exists for a combination of stream type and currency, then Oracle Lease and Finance Management adds the summary line.
You can enter the applied amount either at the summary or invoice line level. You can also enter the applied amount separately for the line and tax both at the summary or invoice line level.
When you enter the applied amount at the summary level, Oracle Lease and Finance Management prorates the applied amount to each invoice line related to summary lines based on the outstanding balance of an invoice line.
Unapply Receipt Application
To unapply receipt application at the summary level, set the applied amount at summary level to zero. Oracle Lease and Finance Management unapplies the receipt application to all invoices lines associated to the summary line.
Update Existing Receipt Application
To update the existing receipt application, change the applied amount at summary level or invoice line level within specific group of stream. If you update the amount at summary level, then the updated amount is prorated for each invoice line for a stream based on the outstanding balance.
The applied amount can be entered or updated at the summary level or invoice line level. You can also enter the applied amount for the line total or line and tax separately. Select the appropriate option to update or enter the applied amount for Apply To. The following are the options:
Summary Total: Oracle Lease and Finance Management lets you enter the applied amount at the summary level. The amount entered at the summary level is prorated to invoice lines.
Summary Amount and Tax: Oracle Lease and Finance Management lets you enter the applied amount at the summary level separately against the line only amount and the tax amount. The amount entered at the summary level is prorated to invoice lines.
Invoice Lines Total: Oracle Lease and Finance Management lets you enter the applied amount at the invoice line level. Use this option when you want to change the applied amount for specific invoice lines associated to the summary line. For this, select the summary line and Oracle Lease and Finance Management displays all the invoice lines related to the summary line. Then you can update the applied amount for one or more invoice lines. You can also fully apply and unapply as required.
Invoice Line Amount and Tax: Oracle Lease and Finance Management lets you enter the applied amount at the invoice line level separately against the line only amount and the tax amount. The amount entered at the summary level is prorated to invoice lines.
To update the advance receipt allocation.
Search the receipt.
Navigate to the Receipt Details page.
Click Update. When receipt is created as an advance receipt and yet not applied to any invoice lines, Oracle Lease and Finance Management redirects you to the Update Receipt Allocation page. Even if the receipt is created as an advance receipt but already applied to invoice lines, you can not update the receipt allocation. For such receipts, Oracle Lease and Finance Management redirects you to the update receipt application page.
On the Update Receipt Allocation page, you can change the already allocated amount to stream types or add stream types to allocate receipt amount.
Oracle Lease and Finance Management allows mass application of unapplied or on account balances of receipts for a customer to invoices with open balances for the same customer through the following two Receipt Reapplication programs. Oracle Lease and Finance Management uses auto cash application for this.
If the input parameter is Contract Number:
Oracle Lease and Finance Management checks whether any un-expired advance receipt with un-applied or on account balance is present against a contract. If no such advance receipt is present then Oracle Lease and Finance Management does not perform receipt reapplication.
Note: In the cash application rule, Number of Days to Hold Advance payment is defined. The advance receipt expires after number of days defined in CAR, that is, the advance receipt expires on a day when Receipt Date + Number of days to hold advance payment defined in cash application rule for a contract.
If the advance receipt is available then Oracle Lease and Finance Management checks whether any invoice lines against a contract has a balance. If there is no invoice lines with balance then Oracle Lease and Finance Management does not perform receipt reapplication.
If there are both advance receipt and invoice lines with balance for a contract, then Oracle Lease and Finance Management applies advance receipt to open invoice lines one by one based on the receipt allocation. If the receipt allocation is not available for a receipt then Oracle Lease and Finance Management applies the receipt based on the cash application rule associated with the contract.
If the input parameter is Customer Number then Oracle Lease and Finance Management selects all the contracts with open balance. For each contract:
Oracle Lease and Finance Management checks whether any unexpired advance receipt with unapplied or on account balance is there against a contract. If there are no such advance receipt then Oracle Lease and Finance Management does not perform receipt reapplication.
If there are both advance receipt and invoice lines with balance for a contract, then Oracle Lease and Finance Management applies advance receipt to open invoice lines one by one based on receipt allocation. If receipt allocation is not available for a receipt then Oracle Lease and Finance Management applies the receipt based on the cash application rule associated with contract.
If the input parameter is Contract Number then Oracle Lease and Finance Management ignores other input parameter and performs receipt application as follows:
Checks whether any unexpired advance receipt with unapplied or on account balance is present against a contract. If there are no such advance receipts then Oracle Lease and Finance Management does not perform receipt reapplication.
If the advance receipt is available then Oracle Lease and Finance Management checks whether any invoice lines against a contract has a balance. If there are no invoice lines with balance then Oracle Lease and Finance Management does not perform receipt reapplication.
If both the advance receipt and invoice lines with balance are present for a contract, then Oracle Lease and Finance Management applies advance receipt to open invoice lines one by one based on the receipt allocation. If receipt allocation is not available for a receipt then Oracle Lease and Finance Management applies the receipt based on the cash application rule associated with contract.
If the input parameter is Customer Number and Receipt Type is Advance then Oracle Lease and Finance Management selects all the contracts with open balance. For such contracts:
Oracle Lease and Finance Management checks whether any un-expired advance receipt with un-applied or on account balance or receipt date is there against a contract. And whether this receipt matches the receipt number and Date Range parameter. If there are no such advance receipt then Oracle Lease and Finance Management does not perform receipt reapplication.
If both advance receipt and invoice lines with balance are present for a contract, then Oracle Lease and Finance Management applies the advance receipt to open invoice lines one by one based on receipt allocation. If receipt allocation is not available for a receipt then Oracle Lease and Finance Management applies the receipt based on the cash application rule associated with contract.
If the input parameter is Customer Number and Receipt Type is All, then Oracle Lease and Finance Management selects all the contracts with open balance.
Oracle Lease and Finance Management checks whether there are any receipts with on account or unapplied amount for a customer. If there is no receipt with on account or un-applied amount for a customer, then Oracle Lease and Finance Management does not perform receipt reapplication.
If there are receipts with on account or unapplied amount, then Oracle Lease and Finance Management applies the receipt to open invoice against contract of the customer based on cash application rule.
When your customer remits payment for an invoice, the receipt is usually in the same currency as the transaction. However, there may be times when your customer remits payment in a currency that is different than the currency of the open debit item. For these occasions, Receivables lets you create cross currency receipt applications to let you fully or partially process the payment.
See: Cross Currency Receipts, Oracle Receivables
For Leasing related receipts and invoices, cross currency application is possible when you create or apply receipt through:
AutoLockbox: For the cross currency receipt application using auto lockbox, see Applying Cross Currency Receipts, Oracle Receivables User Guide.
Manual Receipt through User Interface with Auto Application: If you create a receipt with the application criteria as contract number or an invoice number, and select the contract or invoice with a currency other than the receipt currency, then Oracle Lease and Finance Management creates the cross currency receipt application.
Batch Receipt: When you select an invoice or contract having different currency than batch currency, then Oracle Lease and Finance Management creates the cross currency receipt application.
Advance Receipt Application: If you create an advance receipt in currency other than the contract currency during advance billing program, Oracle Lease and Finance Management creates the cross currency receipt application.
Receipt Reapplication: If you select to create cross currency receipt application while mass applying the receipts to open invoices through receipt reapplication program, Oracle Lease and Finance Management may create cross currency application. During Receipt reapplication, Oracle Lease and Finance Management first applies the receipt to invoices with the same currency as receipt currency. However, after applying receipts to invoices of the same currency, if there are receipts with unapplied or onaccount balance in one currency and invoice with open balance in other currency, Oracle Lease and Finance Management creates cross currency receipt application.
Manual Receipt Application: Oracle Lease and Finance Management allows you to create cross currency application manually. You can select invoice lines with currency other than receipt currency manually and apply the receipt to the selected invoice lines. In case of cross currency receipt application, you can enter the applied amount in the invoice currency. Oracle Lease and Finance Management derives the receipt amount allocated based on cross currency exchange rate.
Future Pay Application: If you create future pay in currency other than the contract currency, Oracle Lease and Finance Management creates the cross currency receipt application.
In all of the above options, by default Oracle Lease and Finance Management uses Cross Currency Rate Type defined in the Oracle Receivables system option and receipt date to determine the exchange rate to apply cross currency receipts and derive allocated amount in the receipt currency.
You can update the default exchange rate used for the cross currency application. To update the exchange rate:
Navigate to the Update Receipt Application page.
See: Update Receipts
Click Cross Currency Rate.
On the Update Exchange Rate page, the cross currency receipt application lines is displayed grouped by the invoice number.
Update the exchange rate at the invoice level.
Oracle Lease and Finance Management recalculates the receipt allocation amount in the receipt currency and receipt balances based on the updated exchange rate.
You have now have the ability to apply credit memos to the individual invoice lines. Also, when credit memos are created for invoices, they are not dated with the invoice date. As a result, tax credits match the tax in the original invoice.
To automate credit memo application, use the Credit Memo Sweep program for the following processes:
Rebook Billing Adjustment Credits: This includes online rebook, principal pay-downs, and variable rate re-amortizations.
Termination Credit Memos: This includes termination billing adjustments, discounts and refunds.
Rollover/Re-lease Termination Quotes: This includes rollover and refinance terminations, re-lease and Transfer & Assumption terminations.
Short Fund Credits (Supplier Retention): This includes short funding termination quote credits.
The Credit Memo Sweep program determines the invoices that must be selected and applies credit to invoices with open balances for:
Security Deposit and Discount: It applies credit to the same contract.
Supplier Retention: It takes credit from the source contract and applies to the target contract.
Note: You cannot use the Credit Memo Sweep program for credit memos that have multiple lines. To use the Credit Memo Sweep program:
Modify the AR Grouping Rules setup to ensure that there is no grouping.
Define the Application Receipt Method.
Run the Master Credit Memo Sweep Contract program to start the Credit Memo Sweep Child programs.
You can apply on-account credit memos to specific invoice lines. The Credit Memo Sweep program performs the following steps:
Create a zero amount receipt
Apply the receipt to the credit memo
Apply the receipt to the invoice line
Note: Credit memos are interfaced to Oracle Receivables without grouping.
Credit Memo Application Rules (CMAR) defines how to apply a credit memo to an invoice. The CMAR process applies to discount, security deposit and supplier retention. CMAR targets invoices with following categories:
Termination quote related invoices (Defined on T&C. For example, Contract Obligation and Quote Fee).
Termination quote bill but not paid invoices.
If you define Contract Obligation for both discount and security deposit, the system applies the discount credit memo to Contract Obligation first.
To create Credit Memo Application Rules navigate to the Application Rules page. You can define CMAR that should be used when processing credit memos for the contract's invoices automatically.
For credit memo automatic application, you must:
Set up one credit memo application rule for each credit memo type by operating unit and make it a default credit memo application rule.
Define the billable stream types in the contracts to be covered by the credit memo and their order.
Discount credit memo, if created by release/rollover needs to be applied to rollover credit memo invoice for discount.
Discount credit memo, if created by non-release/rollover needs to be applied using CMAR.
Correct Credit Memo Dating: The correct credit memo tax lines can be calculated and accurate information can be sent to the tax engine. For termination, the credit memo transaction date should use the original stream element date.
The credit memos will be dated with the stream element date of the stream being credited.
The individual credit memos to be generated for each billed stream element for all terminations/expirations including partial termination in base term.
Termination billing adjustment credit memos during partial termination in base term will be generated based on 'Termination Billing Adjustment' system option and will not follow Rebook billing adjustment options.
System Option for Termination Billing Adjustments: For termination processes, the Invoiced Based System option, in the Termination Billing Adjustments page, can be used to apply credit memos directly to the invoice line.
System Option for Application Receipt Method: Use the Credit Memo Options region of Operational Options page to select the 'Application Receipt Method' for credit memo sweep program for zero dollar receipt.
Enhanced Matching Logic for Split Assets: For credit memos created for an asset that have been split during rebook, if no invoice match is found for that asset line associated to the credit memo, then the system will look for the parent asset line for a match.