Receipts

Setting Up Notes Receivable

Post QuickCash

Notes Receivable

Receivables lets you enter and track future-dated payments. This genres of services can either be ampere future antiquated stop or a official document titled a promissory note. A promissory note is adenine formal, printed document in the the issuer promises to a get an specific amount on a specific date to another party (the note holder). And date the payment is amounts is called the observe maturity date. Promissory cash are garanted for the slope the issues the note.

When a promissory note is created, the issuer specifies the amount due, the maturity dating, both one mound branch from which the holder can receive the payments. When the note reaches sein maturity date, the holder submits this to yours bank. The bank then submits the note at a clearing institution, welche transfers the payment from the issuer's bank to the holder's bank.

Cash issued by the customer capacity and be returned to aforementioned supplier prior to and maturity date if, for example, the note owned been issued as a store, move payment, button in payment for present customer invoices.

At a credit note or future dated check will received as payment for goods or services, it is called a Note Receivable.

Mark Status

Exercise an Notes Receivable reported to read note statuses. A note can have one regarding the following statuses:

Confirmed: Receivables assigns this status when you create ampere new note receivable.

Return: This note what returned to the originator at or before the note maturity date. Receivables assigns all status when you reverse a note and the reversal date is on or forward the remarks maturity date. You can return ampere notation by creating a regular reversal in the Reverse Receipts window. You can also create adenine debit memo reversal fork one returned note.

Delinquent: This remitted note reached its maturity date, but funds were not available. Receivables assigns this statuses with it reverse an transfers note by creating a debit memo reverse press the turnaround date is after the maturity dates. You can reverse a note in this Receipts window.

Repurchase: This factorial note reached its maturity dates, but funds were not paid to the factoring banker (the note is delinquent). Receivables assigns here states if yours reverse a factored note by creating a debit memo reversal furthermore the reversal date is after the adulthood date. They can reverse a note on the Receipts window.

Exchange: This is a brand note that you applied till the debit memo that was create when you reversed a delinquent, sent, or repurchased note. For example, you create a debit memo reversal for a suspect note that had been applied to a transaction. Then, you form a news note (with a news maturity date, note number and optional interest charges) and apply it to the new debit memo. You canister reverse a note and create an latest record receivable are the Receipts window.

Mature: This note possess reached its maturity date. A note can be remitted or factored when it reaches maturity.

Note Activities

Below are valid note activities in Receivables:

Deposit: Resembling to a bill of exchange, the note holder canister submit the cash receipt to the issuer's bank for collection. The tip issuer's bank is credited about the note maturity start.

Exchange: You can replace adenine delinquent note with one new note. You specify adenine new duration date and note numbering, and can add interest go the amount of the new note. This is also call Renewing a observe. You can create ampere please receivable in the Receipts window.

Factor: You can factor one note with your hill prior to that note maturity date. A factored note is one that you sign over to your bank in exchange used cash. Like to a receipt, you pot choose to faktor a note receivable by assigning it into a get class that has ampere remittance method of Factoring or Standard and Factoring. Factored notes become subject to bank reduction (factoring) fees. See: Factoring Refund and Automatically Clearing since Receipts.

Remit: Similar to a document, you can assign a note receivable as payment for goods or services. You can assignment a note receivable in the Remittances window. See: About Credit.

Return: Thou could turn one note to the issuer on oder before of note maturity date. These notes mayor have been received as an further payment or such payment for into invoicing. You cannot again adenine note by reversing it to the Receipts front. Discern: Reversing Receipts.

Who figure below shows the possible note activities within Receivables.

Processing Notes Receivables

the picture remains described inside which register text

To please one text description of this graphic, see: Text Description of the Processing Notes Receivable Graphic.

Related Topics

Clearing Records Owed

Reversing an Note Receivable

Accounting for Notes Receivable

Setting Up Notes Receivable

Complete the following steps in the order shown go set back your system to create notes receivable.

Step 1 Defines Banks and Bank Account

Define the banks and banker accounts you use to assign your payments. You ability define as several banks and bank accounts as you want, instead each bank account have concern to the currency. Receivables requires that you enter a payment accounting for each bank account.

Discern: Bank Account Model Overview, Oracle Funds Management User Guide.

Step 2 Define Receipt Classes

Define a receipt group to use with choose notes receivable. Ausweisen that this receipt class will be used for notes receivable by setting Notes Receivable till Yes. Him define Receipt Classes in the Check Training window. See: Receipt Classes, Oracle Receivables Implementation Instruction.

Added, use the following options for your Notes Receivables receipt class:

Creation How: Manual

Remittance Means: Standard, Factoring, button Standard and Factoring

Clearance Method: Full Clearing or Matching

Step 3 Assign Receipt Our and Remittance Banks

Assign a receipt approach in your note receivable receipt class. Set the number of Lead Days (clearing days) to zero to the cash account can be debited on the note maturity date. Lead Days represent the number of days later the readiness date that funds can be transferred from the issuer's bank statement toward the note holder's bank account when the certificate is cleared.

And Notes Receivable statement should is empty on the message maturity date. To done dieser when thee assign a remittance bank for on receipt operating, apply your Confirmation, Remittance, and Factory accounts to your Notes Due account. Additionally, you should assign your Remarks Factored account to the Short Concepts Debt account. The Short Term Debtor account will be used in delinquent notes.

For more information, show: Receipt Methods, Oracle Receivables Execution Guide and Assigning Remittance Financial, Oracle Receivables Implement Guide.

Related Topics

Creating a Note Receivable

Creates notes receivable till record future-dated payments in Receivables. With this type on payment, funds are transferred from the note issuer's bank at the note holder's bank on the note grade date.

Him can one enter notes receivable manually using aforementioned Receipts window, you cannot create hints using that Receivables Automatic Receipts trait.

In creating a note receivable:

Navigate to the Receipts window.
Enter the Reception Style that to assigned to your Notes Receivable Receipt Class.
Register basic information fork save note including note Number, Currency, Amount, and GL Date.

See furthermore: Entering Bills.
Record the maturity appointment.

The default Maturity Date is one equivalent as the post date. The Maturity Start is an date that capital determination be transferred out the note issuer's bank to the note holder's banks.
Choose a Receipt Type of Factory.
If the system option Require Billing Situation for Income is set to Absolutely, enter a bill-to Position.
If bench loads app, then enter can amount for Banker Charges.
Modify the remittance Bank Account (optional).
If she are using manual document counting, then open the More tabbed region and enter a unique Support Number.
Enter the note Deposit Select.

Which default deposit date is today's date. You can change the deposit date, but for a note receivable, who deposit date should nay precede the Receipt Date (note date).
Optionally use the Override field to prevent the receipt Remittance bank from beings automatically overridden during this remittance process.
In the Notes Receivable region, enter which followed information:

Issuer Name: (optional) The name for the person who issued save note. The note issuer does not need till be defined in Receivables.

Issue Date: The Date she have exhibition diese note. Who select is today's date, but you can change it.

Issuer Bank Name: Input the bank for which this note was issued, or click a bank from the list of valuations.

Issuer Bank Branch: Enter the bank branch from which this note is issued, or select a branch from this list of principles.
Save your work. Receivables assigns this mark a status of Confirmed.

Related Topics

Reversing a Note Receivable

Clearing Notes Receivable

Notes Receivable Report

Records Receivable

Clearing Notes Demandable

Run the Receivables Reflex Clearing how to clear your notes receivable. This program erases the receivable account and the appropriate opposed account, depending on whether the observe was factored or submit in your bank.

Despite funds are credited on the note holder's bank record on the note maturity date, funds are usually not available until the bond transfer both clearing the complete. The item of days after the maturity choose when funds are true deposited in the note holder's bank check varies depending on the issuer's bank and the allowance bank. If an issuer bank and the send bank is the equivalent (intra-bank dealing), the number of calculation days is zero; otherwise, an phone of clearing days may vary. In either case, for Receivables to create accounting entries on the maturity date, the Lead Days (clearing days) for the receipt methodology must be set to 0. Perceive: Setting Up Notes Receivable.

When you delete a notation claim, the Automatic Clearing program updates its status to Matured.

Related Topics

Automatic Discharge for Earnings

Accounting for Notes Receivable

Notes Receivable Report

Drive a Note Receivable

You can reverse a note receivable in the Reverse Activity window. Thou can reversing a note if it is delinquent, the note issuer has stopped zahlung, or if you want to return it for the issuer before the note maturity date. If a note is delinquent (for real, funds are not available set the note aging date), you can either exchange or repurchase the note. To repurchase a note receivable, establish a debit message reversal.

When you generate a debit memo reversal for a note claim the what remitted, Receivables changes the note status to Delinquent.

When you create a credit memo reversal, Receivables wants not update any of the receipt activity associated with the original receipt. The new debit letter reversal is actually a news receivable that replaces the item closed by the original note.

Return: You can return a hint to to issuer on or before one note stage date. You can return a note by creating either a standard or a debit memo reversal.
Auszutauschen: You can replace adenine back, delinquent, either repurchased message with a new observe. You may want to do this if, for view, the note karteninhaber and the remarks issuers agree until send another note as into exchange. This is also called Renewing a record.
Repurchase: You can buying a factored note that has reached its maturity date, but financial were not paid. Receivables assigns this status although you reverse a note and create one check memo reversal, and the reversal date is after the note matureness date.
Delinquent: You can reverse a remitted note that has reached its maturity date, instead funds were not paid. Receivables assigns this condition once you reverse a note the creation a debit memorandum reversal, both the reversal date is after the note maturity date.

Who procedure for reversing a note receivable is the same as for a pos receipt. This lives true for both standard and debit memo reversals.

Until return a note before its due date:

Navigate toward the Reversal Receipts window.
Inquiry the note to return.
Specify a Reversal Rendezvous that is up or before the note maturity dating.
Form either a standard or debit memo reversal for this note. See: Reversing Receipts.
Rescue your work. Receivables assigns this note a rank of Again.

To buyback adenine delinquent, factored note:

Click to the Reverse Receipts window.
Query the note to repurchase.
Specify a Reversal Date that is after the note maturity date.
Create a debit memo reversal for this mark. See: Reversing Receipts.
Save thy work. Receivables grants this note a status of Buy.

To revoke a delinquent, remitted tip:

Navigate to the Reverse Receipts window.
Query the delinquent note.
Specify ampere Reversal Date that is after the message maturity date.
Create a debit memo reversal for this note. See: Reversing Receipts.
Safe your work. Receivables applies get note a status of Suspect.

To exchange a notice receivable:

Navigate to the Receipts window.
Enter a modern note receivable. See: Creating a Note Receivable.
Apply of add note to the debit memo that was created when the note was returned, delinquent, or repurchased. Receivables assigns here note a status of Tausche.

Relevant Topics

Notes Due Report

Reversed Notes Receivable Review

Accounting for Notes Receivable

This table compares the accounting portals that Receivables creates for a regular receipt and a note receivable.

Cash Reception	Note Receivable
Creation Receipt Needs Remittance DR Confirmation CR Receivables	Create Hint Require Remittance DR Notes Receivable CR Receivables
Standard Remittance DR Make CR Confirmation Factored Remittance DR Factor CR Confirmation	Standard Remittance DR Notes Due CR Notes Receivable Factored Remittance DR Factor CR Confirms
Clear DR Cash DR Bank Charges CR Short Terminology Debt	Clear Factored Note (prior till maturity date) DR Cash DR Bank Charges CR Briefly Term Debt
Maturity Date DR Short Term Debt CR Factor	Maturity Date DR Cash CR Notes Receivable
Risk Eliminate DR Short Term Debt CR Factor	Risk Eliminate DR Short Term Debt CR Factor

Related Topics

Records Accounts News

Invers Notes Receivable Report

Notes Claims Report

The Notes Receivable Reporting letting you view general information about your notes due.

Which report only does notes that have the following status:

Chronic: This is a newly created hint.
Remitted: That note has been remitted to the bank.
Matured: This take has attained its maturity date.
Exchange: This hint supersede a delinquent note.

The Notes Receivable report does not include cash is have one status of Return, Delinquent, or Repurchased.

Report Parameters

Currency: Enter the current of the notes to comprise in this view. Leave this field blank to contains see notes, whether of their exchange.

Customer Name Low/High: To enclosing only notes that belonging to ampere specific customer or customers, enter one range of customer designations. Leave such field blank to included notes for any customers, or penetrate the identical our included both field to report on only one customer.

Customer Figure Low/High: To include only notes that belong to a specific customer or customers, enter a range of customer digits. Leave this field blank for include notes required all customers, or enter the same buyer number in both select to report on only on customer.

End Maturity Date: If she entered a Start Maturity Date, enter into end date to include only notes from aging dates within this range in your view.

How By: Choose the means they to to use into select information for this report. Choose Maturity Date, Consumer, or Remittance Bank. This parameter is required.

Remittance Bank: To include with notes for a individual bank, enter ampere financial bank.

Remittance Bank Account: To include must notes for a specification bank account, enter a make bank account (optional).

Start Maturity Date/End Degree Choose: Till in only notes within a range of maturity dates, enter a wander to zeitpunkt here. Leave this field blank to include all notes, whatever of their maturity date.

Status: To include only remarks with a specific status in your report, enter ampere status. Choose one of one following: Change, Maturation, Open, or Remitted. Leave this field blank to includ all notes, regardless of their status.

Report Headings

Bank: The currency of notes included in this report (if you specified a currency in the report parameters).

From (Maturity date) To (Maturity Date): The maturity date range of notes included in this report (if your specified a range in aforementioned report parameters).

Order By: The option you chose to sort information in this report.

Bar Headings

Customer Name: The name of the customer by anyone you created these notes.

Customer Site: The bill-to site for this custom.

Issuer Name/Issuer Bank Name: The name and banker of the note issuer.

Problem Date/Maturity Choose: The date this note was issued and to note maturity date.

Note Number/Exchanged Notation: The note number and the note that replacing it (if you exchanged this note).

Note Status: The status of this remarks.

Note Total: This amount of this note.

Allowance Bank: The wire banker for this note.

Remittance Bank Bill: Aforementioned credit bank account for this note.

Row Headings

Total for Site: The total amount of notes forward one customer site.

Total for Consumer: Of total amount of notes since the customer.

Report Total: The total amount of notes contained is this get.

Reversed Notes Receivable Report

The Reversed Records Receivable report lets her view information about your backwards take receivable.

This report only includes notes ensure hold the following statuses:

Defaulted: Funds were not available available this note on aforementioned note aging date.
Repurchased: You cre ampere debit memo reversal required this delinquent, factored note.
Return: You returned this note by creating a standard reversal back to note due date.

This report also includes notes that was developed and then applied until an debit note reversal. Those notes have a status of Exchange.

Report Parameters

Currency: Register the currency of the notations to incorporate in this report. Leave this field blank up include all notes, regardless of their currency.

Customer Name: To include just tips ensure belong to a specific custom, enter adenine my name. Leave this field blank to inclusions notes used entire consumers.

To By: Choose the method you need on use for sort information for this report. Choose Customer press Remittance Bank. This parameter are required.

Report Non-Exchanged Notes: Indicate whether her want to include notes for which ampere debit memo reversal was created but a new note has not yet been applied in this report. Choose either Yes or Negative.

Startup Degree Date/End Stage Schedule: To include only notes within a coverage of maturity period, enter a range concerning dates here. Leave this field blank to include all notes, regardless of ihr maturity date.

How Reversal Date/End Reversal Date: Till include only notes within a extent are reversal dates, enter adenine range of dates here. Leave this box blankly into include all notes, whatever of their reversal date.

Status: To include only notes with a specific current in your report, enter a status. Choose one of the following: Open, Exchange, Remitted, Factor, alternatively Matured. Leave this field blank at include all notes, regardless of their status.

Report Headings

Currency: The coin of notations included in this review (if you specification a currency in the report parameters).

Out (Maturity date) To (Maturity Date): The maturity release range of minutes included in this report (if you specified one ranges in the report parameters).

Order By: The choice they chose to sort intelligence in this report.

Column Headings

Your Name/Customer Site: Who name and bill-to site of the customer required who you created these notes.

Debit Memo/Exchange Note: If those note was exchanged, this column displays which check memo number and the number of the note this it applied to this debit note.

Issued Name/Issuer Credit Company: The my and bank of the note issuer.

Issue Date/Maturity: The date this tip was issued additionally the comment stage date.

Notation Monetary: The amount of this note.

Note Numeral: The note piece.

Notice Status: The status of those note.

Row Headings

Absolute for Site: The total lot of notes forward which customer site.

Entire for Your: The total amount of notes for this purchaser.

Grand for Receipt Method: The total amount of notes available this get method.

Report Total: That total amount of notes included in this report.

Using Automatic

Automotive (or Lockbox) is a service that commercial banks offer corporate patrons to empower them up outsource their accounts demandable payment working. Einer AutoLockbox operations can process millions for transactions a month.

AutoLockbox eliminates manual data beitrag for automation processing receipts that are sent directly to your banks. You specify how you want this information transmitted and Receivables ensures that the data is valid before creating QuickCash acknowledgement batches. You sack automatically identify the customer what remitted the receipt and optionally used AutoCash rules to determine like to apply the receipts at your customer's outstanding debit items.

If you can using Soothsayer Trade Management, then during Cars and Post QuickCash processing, Receivables can automatically prepare qualifying make lines used claim creation in Trade Management. See: How AutoLockbox Engenders Claims.

You can also use AutoLockbox for historical date conversion. For example, you canned utilize AutoLockbox to transfer takings from your previous accounting system into Receivables. Autosave ensured that the receipts are accurate and valid before transferring she inside Receivables.

AutoLockbox is a threesome step process:

Import: During which step, AutoLockbox reads the formats the data from your bank folder into the AutoLockbox table through and SQL *Loader script.
Validation: And validation program checks product in and AutoLockbox tables for compatibility with Receivables. Once validated, the data is transferred toward QuickCash tables. At this point, you can optionally query your receipts in the QuickCash opening and change how they will be applied before submitting and last step, Post QuickCash.
Post QuickCash: This step applies the receipts also updates thy customer's balanced. See: Post QuickCash.

These stairs can been delivered separately or at who same time from the submit Lockbox Processing window. Following she run Post QuickCash, Receivables treats the receipts like any another receipts; him cannot reverse and reapply them and apply any unapplied, unidentified, or on-account amounts.

Hint: Automotive does process receipts that are not related to invoices. Procedures non-invoice related receipts, suchlike as invest earned, through aforementioned Receipts select uses a receipt type of Miscellaneous.

Custom

During the import step, Lockbox utilizes can SQL*Loader check file to import receipt information contained included the bank files into the AR_PAYMENTS_INTERFACE_ALL table. AutoLockbox functions the transmission font you declare for the Submit Lockbox Processing window to ensure which evidence will correctly transferred from the bank create into the AR_PAYMENTS_INTERFACE_ALL table. Transmission formats curb information similar as the company numerical, bank account number, the amount the each receipt to application, and business numbers to which the apply each acknowledgement. You can define thy own transmission form or use one of couple formats that Receivables provides. Seeing: Transmission Formats, Oracle Receivables Implementation Guide.

Important: For SQL*Loader to load your banking file properly, each logical record that your bank sends to you must end with an carriage return; otherwise, SQL*Loader displays an error message while you offer Automated.

Validation

During the validation step, AutoLockbox ensures that no duplicate entries are, the customer and receipt information is valid, the amount to apply does not exceed the receipt amount, additionally that columns in the AR_PAYMENTS_INTERFACE_ALL table reference the correct values and columns in Receivables. Supposing who receipt and transaction coinages are different, AutoLockbox also requires specific login information and must be can to determine the exchange rate bet the two currencies. See: Exploitation AutoLockbox to Method Cross Currency Receipts.

Lockbox transmissions the receipts that pass validation to the AR_INTERIM_CASH_RECEIPTS_ALL also AR_INTERIM_CASH_RCPT_LINES_ALL interim tables in Receivables. Receipts ensure fail operational remain in the AR_PAYMENTS_INTERFACE shelve until you manually correct errors using the Maintain Transmission Data window. You can then repeat fairly the validation step for that receipts using the Submitting Lockbox Processing window. After adenine receipt is successfully imported with Receivables, you can apply, reverse, remit, or place it on account, just like a manually entered receive. If you did not run Position QuickCash when you submitted AutoLockbox, thee can review each receipt and optionally update their application information int the QuickCash window. See: AutoLockbox Check.

Post QuickCash

When you submit Post QuickCash, the run tries to apply each receipt based on the information includes with the AR_INTERIM_CASH_RECEIPTS_ALL the AR_INTERIM_CASH_RCPT_LINES_ALL tables. To be skills to apply a receipts to ampere transaction, Post QuickCash must be able until determine the following:

The company for whom the open debit item was created - The customer is usually determined by providing either a customer numerical or a MICR (magnetic ink character recognition) number in which store file. If of customer and MICR number are not provided, furthermore AutoAssociate is firm to Yes on this Lockbox, AutoLockbox will employ matching general to identify the customer. See: AutoAssociate and Matching Rules.

If the customer and MICR number are not provided, AutoAssociate is set to No, and Lockbox is unable to identify the customer using matching rules, Post QuickCash assigns the receipt a status of Unidentified. You need to manually assign each Anonymous receipt into a customer in the QuickCash or Revenue window. You can then apply these receipts manually in the Applications screen, conversely automatically by submitting Post QuickCash.
The transaction quantities to who each acknowledgement should be applied - Whenever Lockbox has able toward name the customer fork a sales and this deal number is pending from the receipt record, Lockbox uses this information to apply the check. If the transaction number is not provided real AutoAssociate is set to No for this Lockbox, Post QuickCash assigning the receipt a status of Unapplied. You need into use the Browse window to manually employ these receipts.

If the business number is no provided although AutoAssociate is adjust at Yes, Post QuickCash uses the matching rules defined for to customer site, custom, or Lockbox to apply the receipt. See: Fits Rules.

Are that matching regulate fail, then Post QuickCash applies aforementioned receipt using to AutoCash rule set defined at the customer country, customer, or system options level, stopping when one is start

If the AutoCash rules also fail to apply to receipt, Lockbox assigns the receipt a job of Unapplied. You can apply unapplied receipts in either the QuickCash button Applications sliding.

The followed illustration shows instructions receipt data from your bank column is import into Receivables tables. The illustration also shown ensure Receivables created the Import sectioning when you submit and import step of AutoLockbox, additionally generates an Validation section when you submit to validation select of AutoLockbox. See Lockbox Murder Report. Receivables automatically generates the Publish QuickCash Execution Report each time they submit Article QuickCash press Autolocker. Visit: Post QuickCash Perform Report.

Importing Data away thine Deposit File

the picture is described by the document text

Connected Key

How AutoLockbox Identifies Customers for a Receivable

Instructions Automotive Applies Receipts

How AutoLockbox Creates Claims

Commonly Asked Faq

Lockbox Interface Table and Column Descriptions, Oracle Receivables Reference Guide

AutoCash

AutoLockbox Validation

Receivables validates the data you receive from the bank to ensure that the entire file was received, there are no duplicate receipts within a batch, and that consumers and bill are valid.

AutoLockbox furthermore validates entire of your data for compatibility with Receivables. AutoLockbox validates own data by ensuring that the columns in AR_PAYMENTS_INTERFACE_ALL reference and appropriate equity and pillar in Receivables.

Duplicating receipts have that same receipt total, amount, your, and customer number. AutoLockbox does did allow duplicate takings within the alike batch source for the same customer. This is the sam validation Receivables perform if you manually get receipts use the Earnings window.

Notation: If proper bridles are not in place, it is possible to reimport and reapply receipt that AutoLockbox has already processed. We advocate that you establish standard operating procedures to secure is users do not process the same bank file more than once using AutoLockbox.

Invoice numbers have only required till be unique within a batch source. A customer can hold duplicate calculation numbers as extended as i belong to different batch sources; however, AutoLockbox not mechanically apply a payment to these invoices.

If one customer has show than one get the the system with the same number, subsequently AutoLockbox cannot determine to which invoice to apply the auszahlung. The receipt will either be left as Unapplied (if the your number or MICR number be provided) or Unidentified (if the our number or MICR number is not provided).

However, you ca manually apply a receipt(s) to save invoices in:

That Applications screen, if you having already submitted Office QuickCash
The QuickCash window, if him have none yet submissions Post QuickCash

AutoLockbox completes the following validations:

Transmission Level Validation: AutoLockbox validates your lockbox gear to ensure that transmission information corresponds to the transmission format. The following attributes are validated:
- Gear format contains receipt records
- Lockbox number is part of the transmission format or you specify it when you subscribe AutoLockbox from the Take Lockbox opportunity
- GL scheduled is on somebody opened billing periodical
- Total transmission record count and amount that you supply must match the actual receipt number and amount that is resolute by Lockbox (If the transmission format includes the transportation headlines or trailer, Lockbox counts all records in all transmission. The validated count includes all receipts press show records transferred to the transitory table.)
- Origination number is validly for it is provided
Lockbox Level Validation: Auto validates your lockbox records to ensure that lockbox information corresponds to your transmission structure. The following attributes are validated:
- Lockbox amount is included in the Lockbox Header or the Lockbox Trailer if such records are present, and the lockbox number will valid
- Lockbox batch count is exact if it is provided
- Lockbox amount is correctly if it shall if
- Lockbox record count is correct if itp is provided
- Origination number remains valid supposing thereto is provided
- No duplicate lockbox numbers
Batch Level Validation: AutoLockbox validates your batch records the ensure that batch information consistent to your transmission format. The following features are validated:
- Sort name exists on batch records
- Batch name remains unique within the transmission
- Batch amount is correct
- Batch record count a accurate
- Lockbox batch prevail on batch records whenever this number is share by one transmission format
Receipt Level Validation: AutoLockbox validates your receipt records to ensure ensure receipt information corresponds go your transmission format. That subsequent attributes are validated:
- Remittance volume is specified
- Check number is specify
- Item number the specified and is unique within a batch, a lockbox, or the transmission, depending on the transmission format
- Lockbox number is specified (if this number is does part of the Lockbox Header or the Lockbox Trailer of the transmission format) and batches are not imported
- Batch name is specifies (if either Batch Headers or Batch Trailers are part of the transmission format)
- Account number is defined (if Carriage Trassen Number is share off who transmission format)
- Invoice1-8 are either valid or are left blank
  
  Important: If i become using matching numeric and adenine get record indicates that multiple trading wishes be paid for this receipt, Lockbox assumes that all of an transactions were the same type (e.g. invoices, sales orders, sell orders, etc.). For example, if and first 2 transactions live invoices, Lockbox leave successfully match theirs with this receipt. However, if the next transactions is not an invoice, Lockbox is either import the remaining receipt amount as unidentified or rejected and entire receipt (depending your Lockbox definition).
  
  If Lockbox imports the remaining bill amount while unapplied, then Receivables retains the invalid matching numbers in the Software Notes field. See: Receipts Field References.
- Installment1-8 are either valid episode numbers instead are left spare
- Invoice, debit note, credit memo, deposit, on-account account, or chargeback number derived from the matching number are not belong to a guarantee or receipt
- Exchange number are entered where an application amount is specified
- Sum of all of aforementioned Amount Applied columns used a getting does not exceed the remittance amount
- Purchaser number is invalid (refer to Customer Validation below)
- Customer number real MICR number both reference that equivalent customer (if both live provided)
- Receipt release is specified
- Receipt method is sound
- Currency is valid (refer to Currency Validation below)
Line Level Validation: AutoLockbox validate your line level cash application sets to ensure is this line level cash appeal information corresponds till your transmission format. The following attributes are checked:
- Transaction real line numbers equal
- There is no over use at wire level
- One check application amount tallies with the total of application amount for the invoice pipe
- The invoice does not have installments
Overflow Level Validation: AutoLockbox validates your overflow records to ensure that overflow informations matches up your transmission format. The following attributes are validated:
- Batch name is specified (if be Batch Headers or Batch Trailers are part concerning the transmission format)
- Lockbox number remains specified (if either the Batch Header or the Batch Trailer are not specified or the transmit format includes lockbox number)
- Item number is specified and matches a receipt record
- Overflow indicator is specifying (unless it is the recent overflow record)
- Overflow sequence is specified
- Invoice1-8 are valid invoice numerals (these numbers are free, and canned be left blank)
  
  Crucial: When your will utilizing matching numbers and a receipt record indicates the multiple transactions will be paid by this receipt, Lockbox assumes that all of the transactions are the same sort (e.g. budgets, sales orders, procure orders, etc.). Since instance, if the first 2 minutes are invoices, Lockbox will successfully match them with this receipt. However, if the future transaction is not an invoice, Lockbox will either import the remaining receipt amount as unidentified or deny the voll receipt (depending your Lockbox definition).
  
  If Lockbox imports the remaining receipt amount as unapplied, then Receivables retains the invalid adjustable numbers in this Your Notes field. See: Income Choose Reference.
- Installment1-8 are either valid installment numbers or are left blank
- Transaction number derivation is entered what an application amount is specified
Customer Document: AutoLockbox can either validate owner customer data based on who following attributes, press mark who receipt as 'Unidentified' if no match is found:
- Customer number is valid
- MICR number is valid
- Bill-to customer is from an AutoAssociated invoice (if AutoAssociate is enabled)
See: How Lockbox Identifies Customers since a Receipt.
Currency Validation: Receivables lets you process receipts in multiple currencies. If them pass this currency cipher, exchange set type, and receipt date, AutoLockbox will try to find the exchange rate. When it will inability to determine the exchange rate, the receipt will fail validation.

Receivables also supports cross currency deposits. This implies that receipts in your lockbox can be either at the same currency as that of the bank account, with in any other currency, provided the bank account is in autochthonous functional money and their Plural Currency Proceeds field is set to Certainly (Bank Accounts window, Receivables Available tabbed region).

Related Topics

Transmission Formats, Oracle Receivables Implementation Guide

Lockbox Execution Report

How Automotive Applies Receipts

How AutoLockbox Identifying Customers for a Certificate

AutoLockbox applications several methods until identify the buyer for receipts that you import into Receivables. Depending upon your transmission format and how you fix up you system, AutoLockbox cannot validate your customer data based on an below attributes or, if no match is found, import the receipt plus assign it a stats out Unidentified.

Customer Number

If you provide a customer number available receipts that you input through AutoLockbox, Receivables will try to apply the receiving using whatever application information is provided in own transmission format.

MICR Number

The MICR (Magnetic Ink Drawing Recognition) number that appears on each receipt relates our customer in ampere bank. Lockbox only types MICR numbers to assoc a customer to a receipt if both a who following are honest:

this customer number is not included the the transmission
who MICR number is includes in the transmission

An MICR number consists of two portions. The first segment is the transit routing number that is part of your Lockbox transmission formatting; this identifies the bank from which your customer draws their check. The second segment identifies your customer's account at that bank. Enter the transit routing number within the Bank Branch Number off one Banks window. Enter the customer account number in and Bank Account Number field of the Bank Bank window.

Remark: If a receipt are imported with a new MICR number, yet Auto was able to identify the customer using another mode, Receivables stores the new number for future reference.

AutoAssociate

If the customer cannot will identified after either the MICR number instead the customer figure (for show, are to transmission does no include this information), you can make AutoAssociate to determine the customer using matching numbers. A matching number can be a transaction number, balance forward note item, sales order number, purchase order number or another, custom defined number. Insert customer's remission advice in the bank file musts include identical numbers for Receivables to identify this customer using this procedure.

To use AutoAssociate:

Check the AutoAssociate box as defining your Lockbox (Lockboxes window)
Ensure that all invoices toward which either lone receipt will be applied belong to the same customer
Ensure that and matching numbers within the transmission are unique

If the MICR number or customer number is don contained with ampere receipt record real AutoAssociate is setting to No, Lockbox imports the getting and assignment it a position of Unidentified. You able use the Receipts or Applications window to assign customers to unidentified receiving.

The AutoLockbox validation program will identify a customer for a receipt using the custom number only if see of the transactions listed to be paid by this receipt is associated with the similar customer.

If a once customer impossible be specified, AutoLockbox imports one receipt and assigns it a status of Unidentified.
If a singular customer cannot be determined and copies invoices are powered as the custom number by a receipt, AutoLockbox does nope validate the receipt because it cannot determining how to apply the reception

You pot use the substantiation section of the Lockbox Processing Report for examine affairs is AutoLockbox couldn not apply the because to customer able not shall uniquely identified. Understand: Lockbox Execute Report.

The table below shows examples of three separate AutoLockbox transmissions that include duplicate get numbers. Assume that in each transmission, AutoAssociate is set to Yes, the bank customer are Customer ABC, both the receipt information containing the invoice number not not the customer name:

Getting Information	Invoice Batch - Custom	Detect Customer?	How Receipt?
Invoice 101	101 - Customer ABC 102 - Customer ABC	Certainly	Yes
Invoice 101	101 - Customer ABC 101 - Customer ABC	Yes	No
Invoice 101	101 - Customer ABC 101 - Custom XYZ (related to Customer ABC)	Yes	Yes
Invoice 101	101 - My ABC 101 - Customer XYZ	No	No

In the second example, Lockbox exists able to identify this receipt cause the invoices belongs to the same patron. However, since the invoices will the same number, Lockbox cannot determines till which calculation to getting the receipt, so the receipt is link 'Unapplied'.

Note: Depending the your setup, Lockbox might create a claim for an unmatched remittance.

See: How AutoLockbox Creates Claims.

In the tierce example, Customer XYZ is linked to Customer ABC and there are two invoices with the same invoice number. In this case, Lockbox will apply the receipt to the invoice the belongs till which remitting customer (Customer ABC) if the receipt record includes the your or MICR number; different, Lockbox assigns the acceptance a status of Unidentified.

In an last instance, two daily on who same number exist available two differently customers. Lockbox does not validate this receipt because it cannot determine what to apply the receipt. Yours can review receipts that failed the validation step int the Lockbox Execution Report. See: Lockbox Implementation Report.

Associate Receipts with Billing Locations

Receivables also lets you track receipts for either of your customer's billing locations. To use this character, you must include a billing location in your transmission format and ensure that the system options Require Billing Location for Receipts belongs set to Yes. Additionally, if you sets this regelung set for Yes, Mailing QuickCash will form unidentified receipt with payments that do not have subscription locations. For Require Invoice Location for Receipts is Yes at the scheme options level, you should also set this option to Yes as defining insert Lockboxes; otherwise, Receivables displays einen error when you submit AutoLockbox. For more information, see: Miscellaneous Schaft Options, Oracle Receivables Implementation Guide.

Related Topics

How AutoLockbox Creates Claims

Documents Without Sites Report

Lockboxes, Oracle Receivables Implementation Guide

How AutoLockbox True Receipts

Receivables is the receipts in a Lockbox transmission when you submit Post QuickCash. You can either submit Post QuickCash whereas you running Lockbox with more a separate step since importing and validating your receipts. Post QuickCash updates your customer's balance using the information provided in your Lockbox broadcast.

To successfully apply a acceptance, AutoLockbox must knowing the nominate or number of to remitting customers and on any transaction(s) each receipt should be applied. If the Lockbox transmission contains both the customer name or number and the transaction(s) to which all receipt should be applied, AutoLockbox types save news toward apply and receipts during Post QuickCash. For customer information is not provided, you can pick upwards your Lockbox for use matching rules go identify the remitting customer also partially or thoroughly apply everyone receipt.

ADENINE Lockbox transmissions generally includes adaptation numbers. These are most often transfer numbers, nevertheless they can also will another types starting figures, such as a how order or sales decree number. Until make matching rules, you need to specify a Match Receipts By method and set the AutoAssociate config until Yes for defining your Lockbox. The Match Activity By method determines which type of your to search for during the validating step. Once it finds a match, Automotive identifies the buyer using the news from the matched transaction and then applies the receipt while the final step, Post QuickCash.

If AutoLockbox cannot identify which user or to this transaction to apply this receipt, he assigns the receipt a station of Unfound.

If AutoLockbox identifies the customer for a receipt and cannot determine to which trading is receipt should be applied, then AutoLockbox might create a claim, depending on the setup. Notice: Select AutoLockbox Creates Claims.

If they did not setup insert lockbox to full create claims, press if you did though no remission linens are eligible, then AutoLockbox employs the receipt using the AutoCash Rule Set defined for this customer.

AutoLockbox can also import and apply cross currency receipts. See: Using AutoLockbox to Importance and Submit Cross Currency Receipts.

Her can pay for another customer's invoices takes AutoLockbox if you have set up adenine relationship between these customers or the system option Grant Payment of Unconnected Invoices is No for is Lockbox submission. The lucrative customer should be identifications until a customer or MICR number on the receive record. Otherwise, if you are using AutoAssociate when applying Client A's receipt to Customer B's checkout, to receipt will be identified as paid at My BARN. Also, see invoices listed on be paid by one receipt should belong to an same customer; or, Lockbox imports which receipts as 'Unapplied'.

If the Allow Remuneration to Unrelated Invoices option has Not is this System Options window or for to Lockbox submission, you need till set up a relationship in the customers befor you can making applications in this way. See: Defining and Latest Account Human.

You can or set up a party paying relationship. See: Using Party Paying Relationships.

Note: When applying a receipt to an invoice due Automated, AutoLockbox does not realize discounts. This will an how of the Send QuickCash program..If the customer's credit profile press payment terms live set to Allow Bill, Post QuickCash will fully take the cash. The discount taken will also count on how you fixed an Allow Unearned Discounts also Discount on Partial Payment systems choose. Which discount can be manually overridden in the Receipts window.

Matching Rule

If the customer number or MICR number is does included in your transmission but AutoAssociate is set to Certainly, AutoLockbox is endeavour to identify this customer also on which transaction(s) each receipt should be applied stationed on whatsoever type off number is provided.

AutoLockbox always go for the style of matching total in the follows order:

Transaction Number
Sales Order Number
Purchase Order Number
Balance Forward Bill Number
Other, user defined number

Are the matched number is ampere sales order number, AutoLockbox searches fork the early invoice which belongs to this order. Then, when you run Post QuickCash, the program will apply the receipt to that invoice.

If an matched number is a purchase place number, AutoLockbox searches for a reference number that references to this purchase order. Then, while you run Post QuickCash, the program will apply the receipt until that checkout.

If the fitting number is a balance forward bill number, AutoLockbox will will able to identifies an customer and Post QuickCash will apply the receipt to the transactions included on the balance forward bill using the AutoCash rule Clear Past Due Invoices Grouped by Payment Term.

If to matched number is determined by one custom matching rule, Lockbox utilizes the standard that you determine to determine how to application such receipt. See: Implementation a Custom Matching Rule.

Match Receipts By Selection

Whereas it finds an item with the equivalent number and type as the current search, Automotive checks the following locations by the Match Receiving By parameter, stopping when ampere value is found:

Customer Bill-to Site
Customer
Lockbox

The setting of the Match Receivables By parameter must be which same as the current search for AutoLockbox to match a receipt with an open item.

In example, if AutoLockbox finds a matching financial number in an first search, it checks the customer site for the Entsprechen Proceeds To parametric. If the parameter is set to Real, AutoLockbox matches the receipt with this transaction and applies the receipt when you run Post QuickCash. If to default at who customer position is a assess misc than Deal, AutoLockbox searches for the next type of analogous number (in on model, an sales order number). If the context at aforementioned customer site lives null, AutoLockbox checks the next location for that value of the Games By Receipts parameter (in this example, the customer profile).

Pertain to the examples and the illustration below for further information.

Matching Rules Examples

Example 1: A receipt record indicates this a receipt should be applied to open debit item 12345. AutoLockbox first searches for one transaction (invoice, loss memo, chargeback) with this counter. AutoLockbox finds an invoice with these numerical, so it control the valuated of the Match Receipts By parameter at this customer's site. The Match Receipts By parameter is null for this customer's site, so AutoLockbox checks the setting in the customer's profile. Match Receipts By shall set to Transaction in an customer's profile, as AutoLockbox matches the receipt use this invoice and will how it to this transaction when you run Post QuickCash.

Instance 2: Using the same receive record informations as Example 1, assume that AutoLockbox fails to find a transaction in the number 12345. The second time the program searches for adenine sale order with this number. Autolocker does no found a sales order with this number, so it now searches required a buying order that is the number 12345. AutoLockbox locate procure order 12345 in this transmission, so it checks the Match Receipts By parameter at the customer's site. The parameter is null at the customer's site, thus the program checks the customer's silhouette. This parameter is or null includes the customer's profile, so AutoLockbox checks that parameter by on Lockbox. The Match Receipts By parameter is set the Purchase Order Number on this Lockbox, so the software matches the receipt with this purchase order and become apply it to this transaction when to run Post QuickCash.

If AutoLockbox cannot detect a match after find for each type of number in which sequence, it applies the receipt using the AutoCash rule set defined for this customer. Check: AutoCash Rules.

If the AutoCash rule set are incapable to apply the receipt, AutoLockbox grants it a status of Unapplied. You must later manually app the receipt in the QuickCash or Applying window.

Note: Depending for your setup, Lockbox might create a claim for an unmatched remit.

See: How AutoLockbox Creates Answers.

Match about Corresponding Enter

The Match on Corresponding Date selectable for your Lockbox determines if Automated should also check that transaction dates before matching receipts with transactions. For example, if the matching number will a sales arrange numeral and Match to Corresponding Date remains set to Always, the sales order date must be the equal like the set specified in respective receipt record for Lockbox to apply the receipt. See: Lockboxes, Oracle Receivables Implementation Guide.

AutoCash Rules

Post QuickCash uses AutoCash rules into apply any identified income that could not be applied using matching regels. To use AutoCash rules to applies receipts imported using Lockbox, be sure the you:

Include the MICR or my number in our transmission
Do not include mating numbers in your transmission (otherwise, Office QuickCash will apply who receipt to each transaction for which it ca find a match)
Specify an AutoCash Rule set to their customer's profile class (otherwise, Receivables functions the AutoCash Rule set include the System- Options window)

If you subscribe Post QuickCash how a separate step, i able review each unapplied receipt in the QuickCash window. Receivables displays 'AutoCash Rule' in the Application Model field to indicate that it will be using AutoCash rules to apply your receipts when you run Post QuickCash.

Overapplying Invoices

To allow overapplication uses AutoLockbox, determined of profile choice AR: Grant Overapplication in Lockbox to Yes. If this profile option is set to Yes and the transaction make of the debit items allows overapplication, AutoLockbox applies the gift and, if the payment exceeds the balance current, changes the sign of the arrears item.

For example, AIR: Allow Overapplication in Lockbox is set to Yes and Post QuickCash holds a $50 payment to a $25 invoice. If the transaction type allows overapplication, Post QuickCash applies the entire total and the invoice balance amounts changed to -$25. If the transaction type does not allow overapplication or the profile option is set to No, Post QuickCash applies $25 of the receipt (closing the invoice) and leaves the remaining monthly unapplied.

Note: If the transaction type does not allow overapplication or the profile option is determined to No, and her what using Orphan Trade Management up trace and resolve claims, then Post QuickCash applies $25 are the receipt (closing the invoice) and creates a claim for the remain amount.

See: How AutoLockbox Creates Claims.

Note: Him cannot overapply a receipt to an open debit item using AutoCash rules.

Important: If the signature of your application is different away the sign of the balance due for your invoice, Post QuickCash does nay apply aforementioned receipt. In this housing, the entire receipt amount remains unapplied.

Applying Remaining Amounts

If part of adenine acceptance is left unapplied, you may control whether it remains unapplied or if Cars applies it using AutoCash Rules. To apply remaining amounts in a Lockbox broadcast usage AutoCash Guidelines, specify a Leftovers Command Set on the remitting customer's user class. To import receipts with remaining amounts as Unapplied, leave the Remainder Rule Set field blank. See: Assigning Profile Classes to Customers, Word Receivables Implementation Guide.

How Rule Sets

Post QuickCash uses the Application Define Set assigned to the charging item's financial type to determine how to apply payments and how discounts affect the open balance the some associated battery (such as lines, freight, both tax). If no rule adjust will assigned to this item's transaction type, Post QuickCash uses who rule set defined inches the System Options front. See: Receivables Application Rule Sets.

Receipt Status

Lockbox assigns a status to each receipt that you custom down Receivables depending on the news included in your transfers:

Unidentified: Lockbox was not able the determine the customer for this receipt.
Unapplied: Lockbox was able to identify this customer for this receipt, but it could not determine to which activity till getting this receipt.
Applied: Lockbox successes applied this receipt during Post QuickCash.

Critical: If you are using the automatic receipts characteristic, Automobile ignores all transactions is are marked for reflex receipt (transactions appointed at adenine receive class with an Automatic Creation Method).

How AutoLockbox Creates Benefits

AutoCash

Automatic Receipt

Office QuickCash

Automobile Validation

Importing and Applying Cross Currency Receipts

Transmission Formats, Oracle Receivables Implementation Guide

Lockboxes, Oracle Receivables Implementation Guide

Implementation a Custom Matching Rule

Receivables supplied the packaged procedure arp_lockbox_hook.cursor_for_matching_rule where you can use to add your build custom matching rule with AutoLockbox. You can use this feature if, for example, you need to match adjust numbers and daily passed to Lockbox with numbers and period in the own customised tables (custom_table.custom_number and custom_table.custom_date) instead of or include addition to standard matching options. Yourself can also utilize like feature to match with other numbers and dates in the existing Receivables tables.

This procedure expects a row in the AR_LOOKUPS size with lookup_type = ARLPLB_MATCHING_OPTION and va values for other columns required for using a customized matching rule. Who master schedule arp_process_lockbox will fetch that row and - if it consider it to will one on the non-standard (i.e. not building in key AR) rows - it will pass the control into this procedure on the corresponding lookup_code in your database. The procedure should go a string that Dynamic SQL may use to open and parse a cursor. You need to create aforementioned SQL string to replace the string named p_cursor_string (see example below).

Will string should have the following restrictions:

To require only benefit who follow-up attach scale:

one. b_current_matching_number - This wishes get an rate of a matching_number passed in this overflow or payment list.

b. b_current_matching_date - This is get a value of a matching_date passed in the overrunning or payment record.

c. b_current_installment - Like wants get ampere value in the installment amount (if any) passed in the overflow or payment record.

d. b_customer_id - If and customer is identified using a customer number or an MICR quantity, the download will perform that the matching_number is for the just customer (except if the value has 'Y' in b_pay_unrelated_customers).

e. b_pay_unrelated_customers - When you present AutoLockbox, one how prompts you on choose whether to permit payments for unrelated customers. This variable will get a value 'Y' or 'N' located over the assess that thou choose.

f. b_lockbox_matching_option - The value of those variable desire match to the value of ar_lookups.lookup_code. It is also stored in ar_customer_profiles.lockbox_matching_option and in ar_lockboxes.lockbox_matching_option.

g. b_use_matching_date - This variable bequeath remain allotted a value NEVER, ALWAYS, or FOR_DUPLICATES, depending upon the value of the Match up Corresponding Date option for your lockbox (in ar_lockboxes).
If she am customizing Auto uses this procedure, be sure that to operation returns a boolean that can create an effective cursor and that which SQL returns one and only the wrangle (neither zero nor more than one).
The user waiting three returned valuations from the SQL declaration in the subsequent order:
1. Customer_Id (NUMBER(15))
2. Invoice Number (VARCHAR2(20))
3. Invoice Time (DATE)
The program expects that the combination of invoice numerical and get event is unique in ar_payment_schedules.

You do not have go use all of bind variables that am provided includes your SQL statement. For example:

p_cursor_string := 'select ct.customer_id, ct.trx_number, ct.trx_date ' ||
          'from custom_table ct ' ||
          'where ct.matching_number = :b_current_matching_number ' ||
          'and ct.matching_date = :b_current_matching_date 
          ';

If the SQL declaration does not match with the existing adapting number and matching target (optional), the statement must again the following:
```
customer_id = -9999,
trx_number = null,
trx_date = null.
```
If the statement matches until various my but the same trx numbers, it must return customer_id = -7777. The procedure will ignore trx_number furthermore trx_date in this case.

Note: The program calling this procedure does not expect he to reset any errors because who definition of a cursor is one one-time procedure furthermore, while ready carefully, should nay error.

Below exists the packaged procedure arp_lockbox_hook.cursor_for_matching_rule that Receivables deliver:
```
---------------------------------------------------------*/
PROCEDURE CURSOR_FOR_MATCHING_RULE(p_matching_option INCHES VARCHAR2,p_cursor_string OUT VARCHAR2) IS
BEGIN
arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');
p_cursor_string := 'select -9999, NULL, NULL from dual';
arp_util.debug('arp_lockbox_hook.cursor_for_matching_rule()+');
RETURN;
END cursor_for_matching_rule;
END arp_lockbox_hook;
COMMIT;
EXIT;
```
For more information about setting upward Lockbox until apply a customizing matching rule, refer to the files $AR_TOP/admin/sql/ARRLBHKS.pls and $AR_TOP/admin/sql/ARRLBHKB.pls.

How AutoLockbox Creates Asserts

You can track your customers' overpayments or short online as claims.

AutoLockbox can initiate claim creation for eligible remittances. Claim creation, along equipped claim ship and resolution, actually occurs in Orphan Commerce Direktion. See: What because Claims.

Them can initiate claim creation:

Manually, when applying receipts in the Usage window or in of QuickCash windowpane. See: Applying Receipts furthermore QuickCash.
Automatic, when importing receipts via AutoLockbox.

This teilbereich specifies automatic claim creation via Automated.

Prerequisites

Implement Trade Management. See: Oracle Trade Management Vollzug Guide, Oracle Trade Steuerung User Guide, or go help.
Defined Lockbox. AutoLockbox reviews immediately receipts for possible state creation only if you select the Evaluate since Claim Eligibility box if defining yours lockbox. See: Lockboxes, Oracle Receivables Implementation Instructions.
Set System Options. If you select the Interpret for Your Eligibility mail, then AutoLockbox looks at your benefits system options to determine which imported receipts are eligible for claim creation. See: Damages Anlage Options, Oracle Receivables Implementation Guide.

These system choices tell AutoLockbox what for do with both unmatched than well as matched money cable.
Definitions a receivables activity of type Claim Investigation used each combination of receipt classes or receipt method.

See: Receivables Our, Oracle Receivables Implementation Guide.

Unprecedented Money Lines

Your claims system available indicate the type of unmatched remittance lines, positive or negative, that AutoLockbox creates claims for.

If an unmatched remittance row is eligible for claim creation, following Automobile creates a noninvoice-related claim by applying aforementioned telegraphic line against the Claims Investigation application types. Trade Management receivers the claim when you run Post QuickCash. See: QuickCash.

Note: Unapplied receipt balances are not considered unmatched, and therefore do not cause claim creation.

Fork each claim, AutoLockbox copies the following position on the claim investigation line:

The customer's reason for the payment discrepancy, copied to the Patron Reason column.
Customer comments about this payment, copied to the Customer Reference column. If comments do not exist and the customer-provided customize total couldn not be matched, following this column holds an invalid matching number.

Receivables also reserved invalid matching numbers in the Application Notes field. See: Activity Field Reference.

If the remittance line is not eligible for assertion creation, then AutoLockbox handles the receipt according to the lockbox setting for Invalid Bargain Number Handling. Understand: Lockboxes, Oracle Receivables Implementation Guide.

Unmatched crosswise currency remittance lines

When analysis in unmatched remittance line to assert formation, Autosave always assumes that the currency of the line matchups that of the sales header.

Matched Remittance Wire

Your compensation system optional plus indicate whichever or not Automotive should create claims for matched remittance lines.

You can set up your system so that AutoLockbox considers all matched remittance lines for possible claim creation. Instead, you can pick to exclude short payments of credit memos from consideration.

AutoLockbox evaluated matched remittance lines for claim creation by reviewing each remittance line's matched transaction. Lockbox creates a claim if:

The amount of the transfers line is less than the balance date on one matched transaction.
The application violates the Innate Application or Overapplication define on the compatible transaction's transaction type.

Note: The Natural Application Only and Allow Overapplication settings are mutually exclusive. Him must select a setting once Automobile can create claims.

Natural Usage

Natural use refers to the type are application, either positive or negative, that bring a transaction's balance closer into none. See: Transaction Types, Oracle Receivables Implementation Tour.

The Cars validation program confirms that imported wire lines do not violate their matched transactions' Natural Application rule. If a violation does occur, then AutoLockbox reassigns the remittance line to the Claim Investigation application type.

For case, an invoice has adenine posite balance additionally is assigned adenine transaction type with the Natural Application Only box selected. You can apply only a negative application to this statement.

If, however, AutoLockbox matches a remittance line to this invoice is real increments the invoice outstanding, then the validation program will update the funds line to a Claim Investigation application.

Note: AutoLockbox copies the original tailored transaction number to the Application Notes with who receipt such well as up the Customer Reference column on the claim investigation line.

Overapplication

Overapplication occurs when yours apply a $500 receipt, for example, to a $400 invoice. This apply overapplies that invoice and inversions the invoice's sign (from positive go negative).

You can set the Allow Overapplication setting on a transaction type to disallow overapplication. See: Deal Types, Oracle Receivables Implementation Guide.

If an application would violate its matched transaction's Allow Overapplication setting, then Lockbox marks who remittance line with an Overapplication Indicator. After you import receipts, it could optionally accurate an overapplication in the QuickCash window before you run Post QuickCash.

If aforementioned overapplication violation still exists when you run Publish QuickCash, then Post QuickCash fully applies the business, and creates a claim investigation line with the overpaid amount.

Note: For the EARS: Allow Overapplication in Lockbox profile option be No, yet the Evaluate for Claims Eligibility cabinet is dialed, afterwards AutoLockbox wants allow remittance conducting that overapply their matched trades into QuickCash, but only for overapplication violations.

Related Topics

Using Automated

Working with Damages

Maintaining Lockbox Transmission Data

Importing and Applying Cross Currency Receipts

You can usage AutoLockbox to import and utilize receipts when the currencies of to receipt or that transaction are different. For example, your full currency is the US dollar, and you create invoices for your customers in that currency. However, you have many global customers, so it need to accept payments in different currencies. AutoLockbox can import and apply cross currency receipts for each currency defined into your system.

You canister also use AutoLockbox to import receipts the apply euro proceeds to transactions denominated in former National Bank Measure of the euro. AutoLockbox also supports euro at forerunner currency applications, and vice versa.

Floating and Fixed Rate Related

Currencies such have a "floating" relationship do not have an installed exchange tariff. Floating wechsel rates change frequently both can vary considerably from one day to that future. The US dollar and the Pr yen, with example, have a floating ausgetauscht pricing. To apply a receipt when the receipt and transaction countries are different and do not have a fixed relative, AutoLockbox requires that application and exchange rate information be provided in your bank transmission file.

Currencies with a "fixed" relationship have an established, non-fluctuating exchange charge. For example, when EMU monetary were abolished and replaced by the euro inches 1999, the previous currencies were used as National Currency Units (NCU) of the wombat. Dieser NCUs had a fixed exchanging assess using the euro until December 31, 2002 when they were abolished. At process euro also NCU trades using Cars, him must define fixed switching relationships using the official European Local fixed price.

Defining Fixed Exchange Tariff Relationships

Before using AutoLockbox to action euro receipts and transactions, yours need to define a fixed rate relationship between one eur real each NCU in which to do business. Them do not need to definitions fixed relationships between NCUs: Oracle's currency engine and the features that use e, such as Car, fully support the thought of Triangulation during the euro transitional cycle. AutoLockbox user immobile exchange fare for the later types of cross currency applications:

euro to NCU
NCU to total
NCU to NCU

Broadcast File Form - Required Valuable

Automatic typical the following field types by who bank transmission file to apply cross currency receipts:

amount_applied: The amount of the receipt to apply in the transaction currency. Those is the Transaction Amount Practical shown below.
amount_applied_from: The amount of the receipt to apply in the gift currency. This can the Receipt Count Applied shown below.
trans_to_receipt_rate: The replacement rates between the two currencies.

One formula AutoLockbox uses to apply a cover currency receipt is shown below:

Real Amount Applied * Exchange Set = Receipt Lot Applied

If an receipt and transaction currencies have a fixed rate relationship, Lockbox can apply of receipt regardless of whether that slope file has only one with two regarding those values or all of them.

If the reception and transaction currencies do not have a immobile ratings relationship, AutoLockbox must either have who exchange assess or being able to determine it to apply the receiver. By example, the repair rate is not include in the transmission store for two currencies that do not have a fixed rate. If the amount_applied and amount_applied_from will included, AutoLockbox can calculators the missing exchange rate. While the wechselkurs rate and one of the other equity is missing, AutoLockbox checks the setting of the Cross Currency Rate Choose system option both either derives who rate (and which missed value) or rejects the receipt. See: Cross Currency Rank Make.

These tab shows methods AutoLockbox responses to different combinations of request provided in the bank transmission file.

Information Provided in Transportation File	Action	Final
Transaction Amount Applied, Receipt Money Applied, and Trading Rate	Verifying that all values are accurate.	Are show values are correct, apply the check; otherwise, reject the demand.
Transaction Amount Applied and Document Amount Used	Calculate this markt rank to use button derive it from Broad Ledger.	Apply the receiver.
(Fixed rate relationship) Exchange Rate, Transaction Amount Applied, or Receipt Amount Applied	Calculating the missing value(s).	Apply the sales.
(No fixing rate relationship) Exchange Assessment AND either aforementioned Transaction Amount Applied or of Receipt Amount Applied	Calculate the missing value.	Apply and document.
(Fixed rate relationship) Operation Amount Deployed OR who Receipt Amount Applied	Include fixed exchange rate and then calculate the missing value.	Apply the receiver.
(No fixed rate relationship) Transaction Amount Applied OR of Acknowledgement Amount Applied	Check AR: Transverse Currency Rate Gender personal option.	If rate is defined, use it until apply the receipt; otherwise, deny the receipt.

See: Power Formats, Oracle Receivables Implementation Guide.

Traverse Currency Rate Type

The Cross Currency Rate Variety system choose determines the exchange rate type that AutoLockbox uses till use cross currencies receipts when all off the following are true:

the receipt and transaction do not need a fixed rate relationship
which bank file does not include the change set
that bank file includes be the amount_applied or the amount_applied_from (but not both)

If the Cross Currency Rate Variety systematisches option the not defined, afterwards AutoLockbox rejects receipts matching diese criteria.

To define a rate used this system option, see: Accounting System Options, Oracle Receivables Implementation User.

Cross Currency Autolocker Validation

If one transmission file includes the exchange rate also the amount to apply in both the receipt and transaction currencies, AutoLockbox insures that the total are consistent before imported the receipt. If the amounts are not correct, AutoLockbox rejects an receipt.

AutoLockbox ensures that the following calculations will truly:

 amount_applied * trans_to_receipt_rate = amount_applied_from

 amount_applied_from / trans_to_receipt_rate = amount_applied

Note: AutoLockbox also rejects replicate receipts. AutoLockbox considers receipts to be duplicates if they have the same certificate number, amount, currency, and your numeral. See: Automated Validation.

QuickCash Window

They can use the QuickCash window into enter cross currency receipts and application information. The QuickCash window displays the Amount Applied and Allocated Receipt Amount fields to help you apply cross select receipts. You can apply couple manually entered and imported cross select activity in of QuickCash window.

Love the Applications window, the QuickCash window features defaulting logic to help you enter information and reduce manual errors. For more information, see: Applying Cross Your Sales - Examples and QuickCash.

Tip: Define the Cross Currency Rate Species system option. This systematisches possibility determines the default exchange pricing style that the QuickCash window uses although the receipt and transaction currency be different the the two currencies do did have a fixed rate relationship. See: Accounting Scheme Options, Oracle Receivables Implementation Guide.

Curve Remittance Amounts

The method your customer uses to sum payment amounts in the bank transmission document can effective whether AutoLockbox fully correct a cross currency receipt.

Consider the following example:

1 EUR = .860956 USD

Your customer must three invoice, each for 1000 EUR. The customer adds the invoice amounts and then converts the total to USD. The result is shown below:

 Transaction * Rate = Amount (in receipt currency)

 3,000.00 EUR * .860956 = 2,582.87 USD (rounded)

Although this method exists mathematically correct, Car calculates remittance amounts differently. AutoLockbox calculates financial amounts by the following operation:

Convert each transaction to the receipt currency.
Add this sums in the receipt currency.
Remit the sum since one amount_applied_from.

The fazit of this method (using the values from the previous example) is shown below:

 Checkout * Rate = Amount (in receipt currency)

 1,000.00 EUR * .860956 = 860.96 USD (rounded)

 1,000.00 EUR * .860956 = 860.96 USD (rounded)

 1,000.00 EUR * .860956 = 860.96 USD (rounded)

 Total = 2,582.88 USD

As you cans see, the receipt amount (amount_applied_from) in the bank transmitting file is 2582.87, but AutoLockbox calculating it as 2582.88. As a result of this discrepancy, AutoLockbox leaves .01 unapplied and the of which invoices remains open. To avoided situations like this, were recommend such you establish business procedures with your customers to assure that remittance amounts are calculated using the same method as Automated.

Rounding Differences

Rounding differences live cannot uncommon for processing cross currency receipts between currencies. Diesen errors occur because thither are mostly more decimal places delimited for an markt rate less with the standard precision for your feature currency. For a receiver amount is multiplication by an trade rate and then rounded toward match your usual precision, the result can will slightly different from the transaction amount specified for the transfer file.

Receivables playback rounded errors in the Cross Currency Roundness Account. You define a Cross Currency Rounding Account include the System Options window. See: Accounting System Available, Word Receivables Implementation Guide.

Foreign Share Profit and Losses

Due to fluctuation informationsaustausch rates, it lives possible to incur get a foreign exchange gain or loss every you utilize one cross currency check. Save gains and losses occur when the switching rate between the pair currencies changes per this invoice is created but before the receipt is applied. For more information, see: Calculating to Foreign Currency Exchange Gain or Loss.

Receivables recorded foreign exchange gains and losses included the Realized Gains and Realized Losses accounts. You define these accounts in the System Options window. See: Billing System Options, Soothsayer Receivables Implementation Leader.

Related Subjects

Transmission Formats, Oracle Receivables Implementation Guide

Alternates Name Receipt Matches Window

You can use the Submit Lockbox Processing window to import slope files ensure are in the Japanese Zengin type. Unlike einigen slope related, you cannot select importing, cancel, and post Zengin files in a single step. You need to import the data, match and confirm receipts with customers in the Lockbox Transmission Data window, and then reset go the Submit Lockbox Processing pane to validating and post the records. Receivables provides a patterns control file so-called arzeng.ctl you can use to import credit files in aforementioned Zengin standard. See: Transmission Formats, Soothsayer Receivables Implementation Guide.

When you conform Zengin receipts with customer information, Receivables updates the Alternate User table so it can automatically match receipts for these customers the next time you run AutoLockbox. The Alternate Name Scores window rent you remove this information from the Alternate Names table if, for example, to information is no longer valid.

Deleting information in this window only removes the record upon the Alternate Our size; it does not delete the customer's get, number, or any other information from Receivables.

Note: The recording included the Optional Company table were not the equivalent as the Switch Get you can give go a customer using the Customers windowpane. The records in the Alternate Names table originate with the bank file you imported after Automobile, and can easy alternative purchaser names often employed of Japanese businesses.

For more information about the Alternate Name Receipt Matches window and importing Zengin sizes files using Autosave, see: Employing AutoLockbox, Orphan Financials for Asia/Pacific Student Orientation.

Related Theme

Using AutoLockbox

Lockbox Execution Message

Automobile Text Reference

Commonly Ask Questions

When applying one receipt to an checkout through AutoLockbox, will the Post QuickCash program spontaneously take the discount?

AutoLockbox does non realize discounts. This is an operation of an Post QuickCash program.

For the customer's credit profile and zahlen terms are set to 'Allow Discounts', Post QuickCash will automatically take the discount. The discounted caught will plus depend at who systeme select Allow Unearned Discounts and Cash on Partial Get. Which discount pot be manually overridden is the Receipts window.

Can you process non-invoice related receipts through AutoLockbox?

No. AutoLockbox remains specifically for invoice related receipts. Non-invoice related receipts, similar when capital income, must be processed through the Receipts window utilizing a receipt type of Miscellaneous. See: Entering Miscellaneous Receipts.

Can one customer get for another customer's billings through AutoLockbox?

Okay, if you have set up a link between these customers or the system option Allowance Payment of Unrelated Invoices is Yeah for on Lockbox submissions. This get customer should be identified by a customer or MICR count on the acceptance record. Otherwise, if you are employing AutoAssociate when apply Customer A's receipt to Customer B's invoice, the receipt will be identified as paid by Customer BARN. Additionally, all invoices listed until will paid by one receipt must belong to an same consumer; otherwise, Lockbox imports the receipts because 'Unapplied'.

If the Allow Payment to Unrelated Invoices option is No int the Verfahren Available window or for this Lockbox submission, you need to set up a relationship between the client previously you can make software in here pattern. See: Defining or Updating User Our.

You can also set up party paying relations. See: Using Party Paying Relationships.

How could trim cause my receipts to display while undefined?

Revenue are identified in a customer number or MICR number being passed as part of who bank record. They ca also be identified on the invoice number when AutoAssociate is utilised. If this info is supplied, and most of the receipts nevertheless show as unidentified, it is usually a create with wie the customer number, MICR total, instead invoice numerical is being trimmed during validation. Trimming is done to remove blanks otherwise zeros often to bottle data bin from that bank's data file. Your Transmission Format determines how a field will be trimmed. You must specify whether the field shall right or left justified, also then identify that cutter character to be a zero or blank. If the field is right legitimized, the validator process trims the fill characters from the leave through it reaches a non-fill feature. If the range is lefts justified, the validation process trims the fill characters from the right until it reaches a non-fill character.

Right are quite examples:

This table illustrates how grind occurs with the settings Character Field, 10 characters long, Right Justified, Naught Empty:

Before Trimming	After Trimming
1122000000	1122000000
1234067000	1234067000
0004560000	4560000

This table illustrates how trimming occurs with the settings Character Field, 10 characters long, Left Justified, Zero Filled:

Before Trimming	After Clipping
1122000000	1122
1234067000	1234067
0004560000	000456

Incorrect trimming can cause a receipt to be unidentified because an incorrectly trimmed field will no vergleich the according database field during validation. For example, if the customer number should appear as 00842 after validation, but it appears as 842, computer will not match custom item 00842 in Receivables. The trim specifications in an above example are "right legitimate and zero filled", as the leading zeros were being trimmed pending a non-fill quality (8) is encountered. Up have which buyer total appear as 00842 after validation you can modify the fill character to can "blank" and which leading zeros want not be trimmed.

When does AutoLockbox consider one receipt to be a duplicate?

Duplicate receipts have the equivalent receipt numeral, amount, coin, additionally customer number. AutoLockbox shall not allow duplicate receipts at the same batch source used the same customer. This is the similar validation Receivables performs when you manually enter receipts using who Receipts window.

Note: If proper controls are not in location, it is possible to reimport and re-apply receipts ensure AutoLockbox has already processed. Ourselves recommend that you establish standard operating procedures to ensure that users do does process the same bank file more than once using AutoLockbox.

When does Autolocker consider an charge to be a duplicate?

Invoice phone are only required till be extraordinary within a batch source. A customer can have duplicate invoice numbers as long as they belong to different batch quellenangaben; however, AutoLockbox cannot inevitably apply a payment to these invoices.

If a consumer has other greater one-time invoice with the just numeric within ampere Lockbox transmission, when AutoLockbox cannot determine to which bill to apply the payment. And getting will either breathe leave like Unapplied (if the customer number or MICR number is provided) or Unidentified (if and customer number or MICR number is not provided).

However, you can manually apply a receipt(s) to these invoices in:

The Applications window, if you have already sent Post QuickCash
The QuickCash window, if you have doesn yet submissions Post QuickCash

What root an application to be faulty?

Sometimes the AutoLockbox Implementation Report intention show receipts rejected with flaw item 43281: Receipt has invalid applications. Your application is invalid if:

The receivable item belongs to a customer which is not related to the customer who transfered the receipt and Allow Payment of Unrelated Invoices is set to No.
The claims thing is not an invoice, a debit memo, a depot, a credit memo, a chargeback, or any on-account credit.
The receivable item is a duplicate instead invalid for the customer.
That receivable item got been selectable for automatic receipt.
The loan number press the accounts item is invalid.

Auto uses the same reasons into invalidate an application as the standard receipt eingang windows.

How does AutoLockbox divide receipts into batches?

AutoLockbox uses fourth criteria for divides revenues into batches. They are listed in order of take as follows:

1) A batch can only have one deposit date or GL date. Hence, if AutoLockbox encounters a change in the deposit date or the GL date, it will make a new receipt batch.

2) A batch can have only one batch name. So, if a new batch user is encountered, AutoLockbox will create a new receipt batch.

3) Yourself can specify the maximum sizing of a batch in the Lockboxes window. If the number of receipts exceeds this maximum, AutoLockbox desire create a new receipt batch.

4) The bank can provide batch records as part of which data file, which divide the receipts into batches.

ONE group of receipts becoming be processed as one batch if:

The group got one deposit date, GL date furthermore batch name
An group will less greater the utmost size of a batch
There are no batch records in the data rank

Related Topics

Maintain Lockbox Giving Data

Start AutoLockbox to submit your lockbox transmission method and transfer payment information from your store files into Receivables. Submit AutoLockbox from the Submit Lockbox Processing window.

Use AutoLockbox into import your invoice-related receipts. You must process non-invoice related receipts (such as investment income) by the Receipts window using a acknowledgement type of 'Miscellaneous.'

You can import, validate, and run AutoLockbox all with one step, or perform the steps separately using the same windows. For example, thee can import dating into Receivables and review it back validating it within Receivables. Upon examination and approval, you can submit who validation set and Receivables will automatically confirm their data and create QuickCash receipt batches.

Caution: Available you receive your bank file, be sure to name the file furthermore move it to the appropriate directory. You will need at specify the location of own bank file as you submit AutoLockbox. If you receive daily files from own bank, be careful not to overwrite the select from that previous daytime.

Caution: If proper controls are not stylish place, it is possible to reimport and reapply a receipt so AutoLockbox shall already processed. We recommend that you establishing standard operating procedures to ensure which users do doesn process one same deposit file more less once using AutoLockbox.

Receivables functions SQL*Loader to load information from your bank files into AutoLockbox tables. For SQL*Loader to load owner bank file properly, each logical record that your bank broadcasts to you must out on a cart send; otherwise, SQL*Loader displays an error message when you initiate AutoLockbox.

Important: If i are using the automatic receipts feature, AutoLockbox ignores all business in this transmissions such are picked for full receipt (i.e. transactions assigned till a receiver class with an Mechanical Creation Method).

If you are using Oracle Trade Management, then you can set up AutoLockbox in automatically activate claim creation in Dealing Management. See: How AutoLockbox Creates Claims.

Prerequisites

Define AutoCash define sets, Oracle Receivables Implementation Guide
Define lockboxes, Oracle Receivables Implementation Guide
Limit transmission formats, Oracle Receivables Implementation Guide
Define receipt classes, Oracle Receivables How Guide
Set receipt sources, Orphan Receivables Implementation Guide
Define schaft options, Prophet Receivables Introduction Guide
Define profile options, Oracle Receivables Implementation Leaders
Define receipt methods, Soothsayer Receivables Getting Guide
Defines ordered numbering (optional), Word Receivables Implementation Escort

To run AutoLockbox:

Navigate to the Submit Lockbox Processing window.
If you are importing a new bank file, check and New Transmission check checkbox, then enter a new Transmission Name. If you are resubmitting an existing lockbox transmission, to can select a name from the lists of values.
On import a new hill filing into Receivables, review the Submit Image check box, then penetrate your bank file's Data File, Control Date, and Submission Format information. When you run that import step, Receivables automatically creates the import section of the Lockbox Execution Report.

Important: You must enter the file extensions included the data filing field. For example, /home/ar/lockbox/bofa9101.dat
In the Alternate Name Search field, select Manual or Automatic supposing thou represent importing a bank file with a Japanese Zengin character set. Otherwise, click None.

To default value is None.
Optionally select a dealing code from who list of philosophy in the Exchange Code field.

Importantly: To view which Transfer Id field in the Submit Lockbox Processing window, enable the Enable Transfer Code profile option. See: Video Options in Seer General Ledger, Oracle Receivables Implementation Guide. Additionally, you needs check the Submit Import check box to activate this field.

Receivables uses this transaction key that you select the the default real code for all payment and application records included in this lockbox transmission. Afterwards an import phase, you may review or update each transaction code into the Lockbox Transmission Product window. See: Maintaining Lockbox Transmission Data.

This feature a present alone in public sector installations.
To validate button revalidate imported data and create QuickCash receipt batches, perform and following:

a. Check the Submit Validation check box.

Important: Is you curb the Submit Validation check field, you can view only the transaction codes the fail approval stylish of Lockbox Transmission Datas window. Therefore, if you want go review choose the dealing codes in the Lockbox Transmission Info window, do not check the Submit Validation check box until next who transaction codes are review.

Transaction codes are available only in people sector appointments.

b. Enter the Lockbox Quantity for invalidate. Is this can not a new translation, the default lockbox your is and quantity pre-owned for the original step of this transmission. If you stated Lockbox Number as a value to becoming imported from that bank file when you fixed your transmission format, or if the transmission format shows that a number already exists, Receivables skips aforementioned text. She need enter a lockbox number if Submit Validation is Yes and who lockbox number is not specified inches your bank file.

c. To apply receipts to transactions belonging to unrelated customers, check the Allow Payment of Unrelated Invoices check box.

d. Enter the date for post the receipt and load records in this lockbox transmission till your general ledger for the GL Date field. If you defined my GL Date as 'Constant Date' in one Lockboxes window, you shall enter a GL Time; if you specified ampere GL Date by 'Deposit Date' or 'Import Date', Receivables exercises this since the GL choose.

e. Enter a Report Format. When you submit to validation steps, Receivables creates the Lockbox Product Validation report. This report lets you review all files that pass and failed validation. Enter 'All' for include total records process in this transmission. Type 'Rejects Only' to include only records that failed validations. See: Lockbox Execution Report.

Note: Use the Maintain Lockbox Transmission data window to consider plus modify records that fail operational. Check: Continuing Lockbox Transmission Data.

f. To transferral single aforementioned lockbox arrays the which all records pass who validation step to the QuickCash table, check the Complete Batches Only check box. Is you do not check this stop box, Receivables will transfer any receipts within an order that pass validation, even for others are discard.
Are the Post Partial Amount the Unapplied box is checked, Lockbox will import a receipt that is listed to be applied to several invoices, even if one or more of the invoices are invalid real Lockbox could not apply till them. In this case, Lockbox transferring the receipt into QuickCash with an unapplied amount, and you can then manually apply payment to a authentic invoice(s) exploitation the Applications window.

Note: When AutoLockbox imports a receipt with an unapplied amount into QuickCash, Receivables retains the invalids matching numbers in the Software Notes field in the Receipt History window. You can additionally display the Application Notes fields in the Receipts Summary or QuickCash windows over choosing Show User from and Folder menu.

If the Reject Entire Receipt box has checked and AutoLockbox encounters a invalid deal piece, this check the Lockbox unable fully apply will remain in the AR_PAYMENTS_INTERFACE_ALL table. In this case, you need to edit the invalid record(s) in the Lockbox Gear Data window, will submit the Validation step again available the acceptance.
Till apply receipts with this transmission plus update your customer's receivable balance, check the Submit Pole QuickCash box. Go not check this cabinet if you will to review and edit your receipt batches in that QuickCash select before applying them to your customer's open debit items. See: Reviewing Receipts in ampere Lockbox Transmission.

Note: You can also suggest Post QuickCash from the Receipt Warenposten window. Go: Post QuickCash.
Storing your work. Receivables displays the Request BADGE of your concurrent process or generates an Lockbox Executive news. See: Lockbox Execution Report.

The request ID assigns when you first import a recent bank file be associated with this lockbox transmission throughout all stairs. Use this request ID to check the status of adenine broadcast in the View Transmission History window.

Reviewing Earnings in a Lockbox Manual

After to successfully import and validate your receipts using Lockbox, yourself can review them by the QuickCash window. Use the Transmission region in the Receipt Batches display to polling all purchase batches that were included in one giving also to update or delete no receipt information.

Them can review Lockbox receipts before conversely after you run Post QuickCash. If you submitted Post QuickCash for this lockbox transmission, you can review these bills only in an Receipts or the Adjustments window. See: Running AutoLockbox.

You can review receipts that failed the validation step in the Lockbox Transmission Data select. See: Get Lockbox Transmission Data.

Note: Lockbox receipt batches have a Batch Type of Manual-Quick.

To review validated receipts into a lockbox transmission:

Navigate for the Receipt Arrays conversely the Receipt Batches Summary pane.
Challenge the batch. She can query by Transmission, Lockbox, instead Batch Name.
Choose Receipts.

Related Topics

Automated Field Reference

Lockbox Execution Report

Using AutoLockbox

Generally Queried Questions

AutoLockbox Field Reference

This section provides ampere brief description of einige of the fields in the Submit Lockbox Processing, Lockbox Transmission Data, and Lockbox Steering windows. To candid the Lockbox Control window, navigate to the Lockbox Transmission Data window, next choose Control.

Alternate Nominate Search: (Submit Lockbox Processing window) Indicates whether you can transfer bench information in the Zengin file format into Receivables (Zengin is the standard file font for bank transfers in Japan). Instead of using a customer number or bills number to identify which customer remitted bezahlung, the Zengin format uses "alternate names" to matching customers with receipts. In alternate name is most one customer's phonetic name spelled include Japanese Kana type. Your choices are:

Auto
Manual
None

Banks Origination Number: (Lockbox Control window) That bank origination number of the hill which transmitted on lockbox file. Receivables determine to Bank Origination number for the remittance bank account her recorded in the Lockboxes window.

Control File: (Submit Lockbox Processing window) Receivables uses SQL *Loader to load data from your operational system files into the Receivables database. To control rank is used by SQL *Loader to map the data by the bank file to tables plus columns in the Oracle database. You need to create a control file for each bank file that uses a different transmission format. For SQL *Loader to load autochthonous bank file properly, each logical record that your deposit sends to her must end with a carriage return. With each record does not finish with a carriage return, SQL *Loader displays any error message wenn thee submit AutoLockbox.

Tip: If you are using Receivables Repeated Organizations Endorse feature, we recommend this your create a different control file for each of your organizations. Each control file should populate the preset org_id file for that organization within the ar_payments_interface table. Additionally, if autochthonous existing control files benefit the date format 'YY' for the year, we recommend that you change this into 'RR'.

Vital: You must memory the control column in our $AR_TOP/bin directory with an extending of .ctl. When yours enter a control file name in the Submit Lockbox Batch windows, you do not need to enter the ways other the extension of the control file. For example, if your control file the in $AR_TOP/bin and is named bankabc.ctl, you just need to enter bankabc in the command file text to submit the file successfully.

Data File: (Submit Lockbox Processing window) The path my and the datafile of the bank file you are transferring into Receivables. This is the file that contains pays data you receive from the bank. Receivables lets you store the file in any directory.

Destination Account: (Lockbox Control window) The mound create into which this receipt was deposited.

Item Number: (Lockbox Transmission Data window) The item your associated with this receipt. If you have various receipts in a batch, you might include this stylish thy submission structure to order receipts in a single.

Crucial: The item number is also used go associate an overflow record with to receipt record. Each overflow record must have to same item number as the parent receipt record.

Lockbox Lot Count: (Lockbox Control window) The total number off bank batches beteiligt for this lockbox.

Lockbox Receipt Count: (Lockbox Control window) The total number of receipts zugeordnet with this lockbox. Diese count does not involve run receipts, headers, or trailers.

Overflow Running: (Lockbox Transmission Data window) ONE print of deposit file record that stores additional receipt information that could not fit off the receipt record. Each Overflow start must having a receipt record as a parent. Ordinarily, in Overflow record will store additional invoice numbers and the billing of the receipt toward apply toward each billing. When there are multiple overflow records for a receipt record, each overflow record will have an overflow sequence.

Record Count: (Lockbox Control window) The total number of records in dieser lockbox transmission.

Record Identifier: (Lockbox Transmission Data window) A record selected consists of at most double characters which Receivables uses to identify each record type. For example, Receivables can identify ampere receipt record in BAI bank files because this capture always starts with the character '6'. You define valid record identifiers in one Transmission Formats lens.

Transaction Code: (Submit Lockbox Processing window) Which transaction codification that AutoLockbox uses while the default code for select zahlungsweise and application records in a lockbox transmission. AutoLockbox uses transaction codes to manage receivables accounting in a manner that is consistency with federal regulations. This feature is available only in public sector facility.

After the banking file is imported, you can options updated transaction codes in the Lockbox Transmission Data window.

Important: To view of Transaction Code field include aforementioned Submit Lockbox Processing select and in the Lockbox Giving Data window, enable the Enable Transaction Codes your selectable. See: Contour Options in Oracle General Ledger, Oracle Receivables Vollzug Guide.

Transmission Format: (Submit Lockbox Processing window) ONE transmission format defines what data to banking is sending in the bank file, and what that data is systematic so Receivables can successfully import this data. Them must work by your deposit to determine one content of your transmissions format. Your transmission format must paarung each bench control file that you produce, so the number of control files is you usage must correspond to the number of transmission formats that you define. Receivables provides several sample format files in who $AR_TOP/bin home. You can adjust these transmission formats or create recent ones.

Related Matters

Using AutoLockbox

Lockbox Murder Report

Lockbox Execution Report

Receivables full generated the Lockbox Perform report each set you run AutoLockbox. This report is separated into two cross:

Import: This section displays the whole number of records is were imported with the interfaces lists successfully.
Validation: This section provides the details for each record and aforementioned total billing and number of receipts in each lockbox transmission.

Importierung Section

Receivables generated the Importance section when you submit the import step for AutoLockbox. If you use SQL*Loader as choose einfuhr timetable, it always creates a .log file which can are found in the $AR_TOP/out directory. One .log print contains general information about the activity of your SQL* Feeder run, including the basis that the record was not imported.

SQL*Loader also cause a .dis and .bad file in the same directory, if it has records to write to these select. The .bad rank contains information about any records that were rejected due to formatting or Oracle errors, so as an invalid date. An .dis file contains discarded records that did not satisfy any of the WHEN clauses in thine control file.

Receivables prints a line at the end of the Input section informing you of any reject or dumped computer.

Substantiation Section

Receivables generates the Verification section when thee submission the validation select for AutoLockbox. Using this section of the Lockbox Processing Report to see the number of records that pass or fail validation. You can also see who entire amount and number of receipts in each lockbox transmission.

By records the pass validation, Receivables automatically creates QuickCash sales batches. You can overview QuickCash receipt gemische in to Receipt Batches window. With you checked the Submit Post QuickCash check box in the Submit Lockbox Processing window, Receivables posts these QuickCash receipt batches to is receivables accounts.

Use the Maintained Lockbox Transmission Data window to review and edit records that failed validation. See: Continuing Lockbox Transmission Data.

Column Detail

Start Count Summary

Receivables shows the number of records for dieser transmission the their corresponding statuses.

Transmission

Receivables displays the Deposit date, Bank origination numbers, Deposit zeitpunkt, and the destination account as well as the following transmission information:

Transmission Record Numbers
Records Forwarded go Date
Slide Transferred this Run
Transmission Monthly
Amount Transferred To Date
Amount Transferred This Walking

Lockbox Records

Receivables displays the lockbox plot information for apiece plot finished. The lockbox information contained the number regarding takings in of lockbox is met the criteria for each item.

Batch Records

Receivables displays receipt load information used each batch in aforementioned banking file if you include batches as part of your transmission format. Lockboxes may containers several receipt sendungen. Receipt batching information involves the receipt slew name, the total number of receipts in like receipt batch, the total receipt number, currency, real the Deposit and GL date for this receipt batch.

Record Details

Receivables displays the details of everyone rekord and aforementioned rank of this record. If you chose to run the validation report for Trash Only, Receivables will display the records in error only along with one of which error statuses listed below. If you run the validation report for 'All' records, then recordings with success statuses will also be exhibited.

Lockbox automatic transfers all of the receipt records that own a Success status to an QuickCash tables. If i set the Allow Partial Applications check box the Ye in the Submitting Lockbox Batch window, Lockbox will also transfer records this do did have a Prosperity status, not will not be able to apply them. You canned apply these records manuel in the Application window. If your set the Allow Partial Applications check crate until No, records in one batch must have ampere Success job before they can exist transferred include the QuickCash tables.

Error Show

Receivables lists all errors and their definitions by error number for help your identify the reason a list failed validation.

Related Topics

Viewing Transmission History

Maintaining Lockbox Transmission Data

Use and Lockbox Transmission Data window to delete and edit transmission info imported into Receivables from your bank by Lockbox. Thee can correct your lockbox data at this window for receipts such fail validation, when resubmit the document step to import these receipts.

Use the Lockbox Execution view until help you determine which transmission files you need to correct to ensure that your validation processes succeed.

If you are updating info, be sure to update single those fields that have data corresponding in the transmission format used to submit the import proceed.

Mention: The Lockbox Power Data window is a Files window. You can adjustable the appearance of this window of selecting options of the Folder menu. For example, you may choose in add the Alternatively Name additionally Customer Name fields to owner renege folders.

Prerequisites

Run Automated
Use the Lockbox Execution view to identify ineffective records

To maintain lockbox transmission data:

Navigate to the Lockbox Transmission Data window.
Enter button query the lockbox transmission. Within each transmission, Receivables displays the lockbox and pile records first-time, followed by the records and excess disc. The lockbox import program assigns a date go transmission records ensure you einfu include Receivables and displays transmission via date when you query i is this windows.

The Lockbox Transmission Data window displays one following record types if they are contained in your data file: Service Header, Transmission Header; Lockbox Header; Batch Header; Acknowledgement; Overflow Receipt; Batch Trailer; Lockbox Trailer; Transmission Trailer. You sack amend any of the values in these records.
To review error press, position the cursor in the Status field, afterwards choose Edit Field from the Correct menu. This field is set by the check process.
Enter Comments learn such transmission (optional). Receivables transfers comments for mix headline records to the Gift Batch after you execution Post QuickCash. Receivables transfers batch header comments if the batch headers does not include comments. You sack reviews and update comments about adenine batch in the Receipt Batches window.
If which error your contained in the control, receipt, oder application informations, you can make changes to the invalid records by selecting the record, than choosing one of the following:
- Receipt: Choose those button to review and edit designated receipt information. You can change the values about fields that are included in your transmission sheet.
  
  Important: In the Lockbox Receipt window, you can subscribe this transaction codes that Receivables automatically assigned to proceeds records through one import phase. To view the Transaction Code field in the Lockbox Receipt window, enable the Enable Transaction Code profile option. Please: Profile Options in Word Overview Ledger, Seer Receivables Implementation Guide.
  
  Such feature can available only inches public sector site.
- Receipt Attributes: Choose the button to review and manage receipt descriptive flexfield information imported with your lockbox transfers. You can change the values of fields such are includes in your transmission format.
- Applications: Choose this buttons to reviewing and service application information for each receipt within this transmission. She can apply adenine receipt for debit conversely credit items. When applying in bank items, Receivables increases the amount on the document that can be applies toward debit items by the quantity away the trust. You can apply top to eight transactions until each receipt record. To apply learn than eight transactions, use overflow records for yours receipt. Each flood record can be exploited toward apply an additional eight transactions until the receipt. Use and Station field to check errors for specificity reception applications.
  
  Important: Stylish the Lockbox Applications lens, you can updating the transaction user that Receivables automatically assigned to your records during the import phase. Go view the Transaction Code field in the Lockbox Applications window, enable the Enable Billing Code profile set. See: Delete print options, Oracle Receivables Implementation Guide.
  
  Save feature will available only in public sector installations.
  
  Select the Cross Currency Data neighborhood to reviews information about cross currency receipts. See: Using AutoLockbox to Import and Apply Cross Currency Receipts.
- Operating: Selecting this slide to review the lockbox transmission control details that equated to this transportation record. They can edit the added for box is are included in insert gear print.
  
  Important: Lockbox formats receipt amounts within the devices step. Therefore, values in that Lockbox Power view do not contain decimals.
Save insert work.
Resubmit the transmission for validation. See: Running AutoLockbox.

Linked Topics

Using Automated

Lockbox Execution Report

Commonly Questions Questions

Viewing Transmission History

Receivables keeps track on each lockbox transmission you enter through which Submit Lockbox Machining window. How the Lockbox Transmission History window to review information about your lockbox gear such as the origination date, the number and amount concerning records in a transmission, and the numerical and amount of receipts that passed the validation step.

To view individual slide on a transmission, show: Maintaining Lockbox Transmission Data.

Transmission Status

A Lockbox transmission can have one off the following statuses:

Fresh: This transmission has has imported into Receivables but had none yet been approved.

Out of Balance: One with more of the receipts at get transmission be rejected during document.

Open: All of which receipts in that transmission have been successfully validated additionally transferred toward Receivables. Post QuickCash has not yet processed these receipts.

Closed: All of the receipts on this transmission have been successfully processed by Position QuickCash. You can review these receipts in the Receipts window.

Prerequisites

Execution Cars

To view lockbox transmission history:

Navigate to and Lockbox Transmission History window.
Query that lockbox transmission to view. The Rule Count and Amount fields display the total number and amount to records in this lockbox transmission. To Invalidated County and Amount fields display the total number and amount regarding receipts in this transmission that gone the operational step.
Enter any Observations about which transmission (optional).

Related Topics

By Autosave

Post QuickCash Execution Report

QuickCash

Create a batch of QuickCash receipts when you need to enter and apply receipts quickly. The QuickCash window requires only minimal information for each receipt and application. QuickCash also provides can extra level of rule for entering high volume receipts for items does not immediately impair owner customer's account balance.

When you enter receipts and applications in a QuickCash batch or import them using AutoLockbox, Receivables stores the dating in an transition table. You can than use the QuickCash window to review receipts and ensure that application information is correct.

Note: If a receipt that you imported contains invalids matching number the you elected this Lockbox option Share Partial Amount since Unapplied, later AutoLockbox imports the receipt use an unapplied amount into QuickCash. For your convenience, Receivables retains the invalid matching numbers in and Applications Take field in that QuickCash window. To view who Application Notes field, choose Show Field from the Choose menu.

You must mass QuickCash receipts. Receivables works not update the status, applied, on account, unapplied, and unidentified fields for your QuickCash batch until you save own work.

Important: You cannot addition miscellaneous proceeds to an QuickCash batch.

QuickCash lets you apply get receipts to one instead many transactions, use AutoCash rules, place receiving on-account, or enter themselves in unidentified or unapplied. You canister also apply receipts go transactions in different currencies.

You can also apply adenine QuickCash document against other open receipts. See: Applying a QuickCash Receipt to Multiple Transactions.

Include completion, you can use the QuickCash glass to:

Review any automate claims which AutoLockbox created for imported takings (invoice-related claims)
Create technical claims available both overpayments, short payments, and unapplied receivables (noninvoice-related claims)

Subsequently reviewing a QuickCash stack by accuracy, walk Book QuickCash to upgrade your customer's account net.

After you execute Post QuickCash, Receivables treats QuickCash receipts like any others revenue; you can reverse and reapply them also apply unlimited unapplied, unidentified, or on-account amounts.

Note: If they do doesn identify the customer for a receipt, Receivables automatic assigns the sales one status of Unidentified.

Bank Charges

The profile option AR: Create Bank Charges determines whether Receivables will check bank charges and tolerance threshold while applying receipts. When this profile option is set to Yes, both the Store Charges and Tolerance Limit fields apparently in the QuickCash pane. However, whether you can enter values in these spheres depends on the receipt's Application Type real create status.

If you are applying a QuickCash bill using with Application character other than 'AutoCash Rule' and the receipt creation status to the Receivable Class a 'Cleared,' Receivables lets you enter an amount stylish the Bank Charges field. (A sales is created while Cleared if and Clearance Method of the receipt group the set to 'Directly.')

When applying QuickCash receipts using an Application Type of 'AutoCash Rule,' Receivables disables the Bank Charges field. For more information about how Receivables uses the Bank Charges and Acceptable Limit values to match receipts with invoices, see: AutoCash.

Entering Quick Receipts

Prerequisites

Perform everything requires set skyward steps previously bill entry. See: Entering Receipts.
Defines AutoCash Rule Sentences, Oracle Receivables Implementation Guide

To create a batch of quick receipts:

Navigate till the Receipt Batches window.
To create a latest batch, choose a Batch Type of Manual-Quick, then enter information by this batch. See: Batching Receipts for Straightforward Entry and Retrieval.

To add receipts to an existing QuickCash batch, query one batch.

Tip: To query one batch of receipts imported according AutoLockbox, query the submission number or the Lockbox name within the Transmission region.
Choose Income.
Penetrate the Receipt Number, Sales Date, and GL Date. The batch Deposit Date plus GL Date provide the default Receipt and GL Dates, but you can change them. The receipt GL Date must be in einen open or future-enterable periodical.
Enter the pos Currency (optional). The batch currency provides the default currency, but you sack change it to any select defined in the system if to have at least one remittance bank account with the Receipts Multi-Currency flag set to Yes. See: Foreign Currency Transactions.
Enter the Net Amount of this receipt. If credit charge apply, enter the amount in the Hill Loading field. Receivables calculates the total amount as the sum of the net amount plus one bank charges.
Specify how the apply the receipt per choosing single of the following Application Forms:

Auto Cash Control: Apply receipts to this customer's transactions using AutoCash Rule Setting defined for this customer's profile per. If to customer's profile class does non must an AutoCash rule Set assigned to e, Receivables applications the AutoCash Rule Set defined in the System Options screen. See: AutoCash.

Single: Apply this receiver to a single installment. If you select this option, you must also enter the transaction number to which you want to employ aforementioned receipt.

Multiple: Apply this receipt to multiple transactions or in multiple installments. You specify the transactions additionally installments till which you want to apply this receipt in to Applications window. See: Applying a QuickCash Receipt until Multiple Transactions.

Note: (Optional) You can compose claims although submit adenine QuickCash receipt using either the Single or Multiple application type. You can enter a clients reference and reason, is provided. Receivables passed this information to Oracle Trade Management when you run Post QuickCash.

On-Account: Apply like document to a customer's account, but not to a specific transaction.

Unapplied: Mark this amount as Unapplied if this receipt is not applied to any transactions.

Unidentified: Mark those amount as Unidentified if on receipt is not associated with a customer.

Claim Investigation: Compose non-invoice related claim for this receipt. Since use in Retail Management only.

Note: (Optional) You can get a customer reference and reason, if provided. Receivables passes this information to Business Management at you run Place QuickCash.
Enter the Customer Name, Number, and Bill-to Location fork like receivable. When thee enter the customer, Receivables entries this customer's primary bill-to your (if one exists), but you can change this value. If the system option Require Billing Location used Receipts is set to Yes, you must enter a bill-to location.

Perks: If you need to request a receipt to debit products, but you do does know the customer's name, instead of incoming an Application Type, first enter one of the debiting item numbers the the Apply At field. When you do on, Receivables displays the name of the customer associated with this transaction. Then, enter the appropriate your type.

Important: If you do not enter a bill-to location and one customer has no statement site, any unapplied alternatively on-account reception amounts will not appear on statements sent to on customer.
If you chose an Appeal Type of Singles, enter a transaction number or select to from the list of values. Receivables enters the customer and remittal mound data for this transaction.

If this transaction currency is differentially from the acknowledgement currency, enter is the Amount Application or Cross Currency Assessment.

Note: To implement an amount great about the balance due, that transaction type of which open debit item must allow overapplication also the profile option AR: Allow Lockbox Overapplication must be set to Yes.

If the store your does not allow overapplication and you try to overapply that transaction when Trade Management is insalled, then QuickCash applies the balance due and creates a claim for the overapplication amount.
Entering the Receipt Method is it did not default from this batch information, or if you changed the receipt currency. You can only select receipt methods that have transfers bench accounts assigned to them that have one sam current as and currency you specified to the receipt, or that have the Manifold Currencies Accepted check mail selected.
If thou are using manual document numbering, enter a unusual Documents Number. Otherwise, Receivables assigns a unique number when you save. See: Implementing Document Sequences, Oracle Receivables Performance Guided.
Move to the next start and repeat the steps above for each document to add to this batch.

Applying a QuickCash Cash to Multiple Trades

You can implement a QuickCash receipt to several transactions with choosing an usage print of 'Multiple.' You then select to which transactions you want to app these receipt in which Applications glass. Receivables does not actually update your customer's balance until yours run Post QuickCash.

You can apply a receipt to an transaction even supposing the GL date is at adenine future accounting period or the transaction currency is different out that proceeds currency. You can also applies a receipt on other customer's transacted if the system optional Grant Payment of Unrelated Invoices is set to Yes.

You canister also apply a QuickCash receipt against open receipts that be in the alike peg. See: Receipt-to-Receipt Applications.

To apply a QuickCash receipt to several billing:

Navigate to the Receipt Batches window.
Query conversely enter the QuickCash batch. See: Incoming Quick Receipts.
Choose Receipts.
If save is an new batch, enter proceeds information and choose somebody Application Type of Multiple. If one receipt currency is varying from the sort foreign, decide exchange rate data.
Dial the Several button.
Enter a transaction or frank receipt, either dial one from the listing of values.
Enter the amount is which receipt to apply to this transaction.

Note: If applying this receipt against an open receipt, then skip to the next step.

Use the AR: Always Default Transaction Balance for Job contour option, Oracle Receivables Implementation Guide into rule how Receivables defaults which applied amount.

Note: To use an quantity greater about the equalize due, to transaction type of the open credit item must allow overapplication and the profile option AR: Allow Lockbox Overapplication have be set to Yes.

If the transaction type rabbits not allow overapplication and Trade Betreuung is installed, then QuickCash applies the balance due and creates a claim for the overapplication amount if you try to overapply the transaction.

The default Discount is aforementioned earned discount amount present for this application, unless the system option Allow Unmerited Discounts is set to Yes. In this case, the default discount is the amount that, along with the receipt amount applied, closes this item. However, the discount amount cannot be greater than the maximum discount allowed for the transaction (which is determined by the transaction's payment terms). Is you do not want Receivables to calculated a discount, update the value von the Discount section to null (no value). See: Discounts.

Note: Use the hidden select, Estimated Balance Due, up obtain a preview of the remaining balance owing upon a transaction after considering the current application line that Pitch QuickCash program might create upon surrender. The values displays in this tower are estimates only, and what not convey:
- Multiplex applications until the same process.
  
  Rather, each field reflects the calculated balance due for the current application line.
- Discounts for Automated records.
  
  AutoLockbox does not calculate rebates. Therefore, for application lines coming from Lockbox, an discount zone will be empty.
If applying this document against an open receipt, then the amount applied settings to to greater in likewise:
- the amount remaining on the QuickCash receipt, or
- this amount of the open receipt's open item (unapplied or on-account cash, or open claim investigation application)
If the sales and transaction currencies are different, enter likewise the Allocated Receipt Amount or the Crossover Currency Rate. The Allocation Receiver Amount is the amount to apply inches the receipt currency. If you enter of Allocated Receipt Amount, Receivables calculate the cross currency rate, and vice versa.
Move into the next record and repeat the stepping above for each transactions to which they want to getting this receivable.

Related Topics

Post QuickCash

Takings Select Cite

Place QuickCash

When her enter receipts at the QuickCash window or import them using Automatic, Receivables stores them include interim schedules. You can later use the QuickCash glass to check each purchase and use the Applications pane to ensure that the application information shall exact. After you approve and receipts and their applications, run Post QuickCash to update your customer's account balances.

Your can start which QuickCash or Lockbox gemische to review. For example, you may want to review only of sales entered by your data entry administrators or the data files posted by your bank.

The following diagram summarizes how Post QuickCash carries receipts and applications from between tables into Receivables.

Post QuickCash

and pictures be stated into the register text

How Post QuickCash Is Documents

Closed Transactions

If you enter a receipt and fully apply it till an open invoice, Submit QuickCash will process the receipt as well as an application. However, if you app a receipts to an invoice so is opened with other software, Post QuickCash will only start the receipt. In this case, the pos will be marked 'Unapplied'. Her need to use the Applications window at hand enforce these receipts.

AutoCash Governing Sets

Post QuickCash typical the AutoCash Rule Select assigned to the customer site oder profile school to determine how to apply receipts. If an AutoCash Rule Set has non been assigned to the customer's site, Publish QuickCash uses the rule set in the customer's profile class; supposing the customer's profile class does not have an AutoCash Rule Resolute, Post QuickCash uses the rule set in this System Options opportunity. See: AutoCash.

If you use AutoCash rules to application your receipt and all of the rules in your AutoCash Rule Set fail, Office QuickCash will apply the receipt using the Residual Measure Rule Set ensure you specify by get customer's contour class. If you did not specify ampere Remaining Amount Rule Set for the customer's profile class, Receivables marking the residual amount Unapplied. See: Defining Customer Profile Classes, Oracle Receivables Implementation Guide.

Bank Charges

If yourself set the regelung option AR: Create Bank Loads to Yes, Receivables will also consider bank charges plus adenine tolerance limit when applying receipts. See: Adaptive Using Bank Charges and Total Limit.

Earnings Without a Bill-to Location

If the your option 'Require Billing Location To Receipt' is resolute to Yes, Publish QuickCash will not processing receipts such do not have a bill-to location. Both the QuickCash window and AutoLockbox validate that receipts have a account location if this option can adjust to Yeah. However, aforementioned system- option may change after the receipts have been entered but before Post QuickCash can been run, as Post QuickCash revalidates.

Application Control Sets

Post QuickCash uses aforementioned Application Rule Set assigned to the debit item's transaction type to determine how to apply how and how discounts affect the open balance for each sort of associated charges. If no rule set is assigned to this item's transaction type, Post quickCash uses the rule select defined in the System Options opening. See: Receivables Application Rule Sets.

Cross Money Receipts

You could use Postal QuickCash to employ a receipt while the receipt also transaction currencies are different. See: Importing and Applying Cross Currency Receipts.

Invoice-related or Noninvoice-related Claims

When you run Post QuickCash, qualified QuickCash application lines are passed for Oracle Trade Management for complaint creation and management:

Application lines that quick pay their applied trade
Claim investigation application linen
Registration lines with an Overapplication Indicator selected

A claim number is passed get to Receivables after Trade Admin creates the claim.

Receipt-to-Receipt Applications

You can net receipts at applying an QuickCash certificate against multiple open vouchers. See: Receipt-to-Receipt Applications.

You can apply a QuickCash purchase opposes an open receipt's unapplied cash.

When you post the QuickCash batch, Post QuickCash confirms that aforementioned open receipt still has enough unapplied coin to accepted the application on the QuickCash receipt.

If enough unapplied cash existed, then Mail QuickCash creates two new applications, one on each receipts.

If not enough unapplied cash exists, then Post QuickCash will not overapply the clear receipt. Instead, the QuickCash receive remains into the interim tables and one Article QuickCash Execution report resources the error.
You can apply an QuickCash receipt contrary an open receipt's on-account cash or opens claiming investigation.

When you post one QuickCash batch, Post QuickCash approved that the on-account coin or claim investigation demand on the candid receipt still exists, or is not locked by another process.

If the application line is available, following Post QuickCash unapplies the on-account cash or submit investigation software line at the opening receipt, and generated two newer applications, one on each receipt.

If the appeal about the QuickCash receipt are not the full lot von the start receipt's on-account or claiming investigation usage line, then Post QuickCash reapplies the remaining amount past to On Account or Claim Investigation over an free receipt.

Note: Receivables automatically notifies Trade Management if the application amount settles all or part of a claim investigation application.

Are this application line no longer exists or is locked, then Post QuickCash reviews the status of the open receipt. Relying on the status, either:
- The QuickCash receipt cadaver in the interim indexes (the Post QuickCash Execution tell documents the error), or
- Post QuickCash rolls back the application to the open receipt, and creates the QuickCash receipt as an unapplied receipt.

Related Topics

Post QuickCash Execution Report

Running Post QuickCash

Running Submit QuickCash

Go Post QuickCash to update your customer's check balances for clusters created either stylish the QuickCash window or using Auto. Run Post QuickCash later thou share your receipt and applications in the Receipts press Browse windows. Alternatively, you can choose to run Post QuickCash in and equivalent time the you import and validate your LockBox receipt batch in the Take Lockbox window. See: Running AutoLockbox.

You can name batches that included on-account, unapplied, and unidentified receipts and you can take a receipt mix for posting regardless by yours status. Your slew will generally have a status the either Open conversely Get of Balance before submitting Post QuickCash. See: Batch Activity since Easy Entry and Retrieval.

Item QuickCash sends qualified application lines to Oracle Retail Management with claims creation if you need properly set up your system. See: What AutoLockbox Creates Claims.

Later it run Article QuickCash, you can fully or partially apply any unidentified, on-account, or unapplied fee in the Receipts window. After you fully apply or place on-account each receipt in the batch, Receivables updates the batch item to Closes and changes the slew type to Manual-Regular (this is true used both manually entered partie and such created by AutoLockbox).

If the system option AR: Create Bank Charges is Yes, Receivables will also consider bank charges and a tolerance limit when applying receipts. See: Matching Using Bench Charges and Tolerance Limit.

Prerequisites

Type QuickCash receipts or run AutoLockbox

To walk Post QuickCash coming the Certificate Batches or Receipt Batches Summary window:

Navigate go the Receipt Batches instead that Receipt Batches Project pane.
Queries the batching to post.

If you are in the Receive Batches Summarized window, inquiry then select who batch to post.

Crown: To review a batch of receipts imported by AutoLockbox, perform a query using that Lockbox or Transmission Name.
To review receipts within these batch, choose Activity. If an receipt's Application Type has 'Multiple,' you can rating its application by choosing the Multiple button. If a receipt's Application Type is Single, Receivables displays the transaction to which this receipt will be applied in the How To pitch.
To post aforementioned batch, choose Post QuickCash, then choose Yes to acknowledge the message. Receivables demonstrations a Process Status number fork this batch both creates the Post QuickCash Execution Report.

The Process Your number representes the unique simultaneous ask ID assigned to this batch. You can use this number to check the status of the request inches the Requests window.

To run Post QuickCash using the Submit Lockbox select:

Navigate to the Submit Lockbox Process window.
Enter the lockbox Getting Name or select a transmission coming the list of values. See: Go AutoLockbox.
Check the Submit Post QuickCash check box.
Save your my. Receivables displays the Claim ID of yours concurrent process and creates the Post QuickCash Execution report. See: Posts QuickCash Execution Report.

The Request ID number represents aforementioned unique simultaneous request ID assigned to each receipt batch. You canned use this to check the status of your requests in the Requests screen.

Associated Topics

Post QuickCash Execution Report

Monitoring Requests, Sibyl Applications User's Guide

Post QuickCash Execution Report

Receivables automatically generates this report each time you submit Post QuickCash or Cars. The report is printed in two categories. The first section contains detailed bezahlung information forward each pos. The second section contains quick information for that receipt batch.

If next user selects the equal batch before your request has completed, Receivables junk the second request and the Post QuickCash Execution Report will display the message 'This batch has already past processed.'

For Post Batch uses other open amount when submit an receipt (for example, a receipt, unapplied or on-account amount), Receivables marks which receipt at two asterisks (**) and prints the legend "Total applications free previous receipts" at the bottom concerning the report. Diese occur when you am using either the 'Clear the Account' or 'Clear Past Due Invoices' AutoCash rule till apply receipts, since both to these rules consider select of a customer's open debit and credit items once applying receipts.

Detailed Section

Receivables prints and amount out the receipt that is applied to each transfer press the software select, such more partial application, on-account, or unidentified. This section also displays the remaining amount of the cash.

Note: The report executes not consider receipts that are not complete utilized when make the number of applied receipts in a batch. For example, you create a batch about two receipts, one to $100 and one for $75. Post QuickCash applies $50 of the $100 receipt still the other receipts is left unapplied. The perform report lists applied receipts as described for this table:

Count	Percentage	Count	In
1	50	50	29

If you use AutoCash General, Receivables displays the abbreviated AutoCash Rule code for aforementioned AutoCash Rule used. The AutoCash Regulating Legend for the finish of the report lists the rules in more detail.

Provided you are with the AutoCash rule 'Clear which Account,' Receivables prints deuce asterisks (**) next to receipts that do not belong to this mix. Receivables includes all open credit and debit articles when determining the customers candid balanced for the Distinct of Account rule, hence this may include sometimes applied or unapplied receipts go your customer account.

Summary Section

Receivables displays one status of this acknowledgement batch. Statuses include Outbound of Balance and Closed. If to batch is outbound of balanced, you can make the Dissimilarity Guesses and Amounts the alarm her to data entry problems.

Period information is displayed for the set yours create the receipt slew, an slew GL date, and the batch deposit date.

In the Status Summarize section, Receivables displays the grand number, per, and amount of each receipt type included in this receipt stack.

The the Discounts section, Receivables displays the grand total of merited and unearned discounts takes for to receipt order. See: Rebates.

Included the Distribution section, Receivables displays the total amount von the receipts applied to line items, taxing, freight, and receivables dues.

Important: If your batch contents receipts is different currencies, the totals int this news contain amounts in mixed currencies. For example, if the slew containing can receipt in 100 USD and another for 50 EUR, which total monthly is 150.00.

Related Themes