AR Auto LockBox in oracle apps

Definition: AutoLockbox is a service that commercial bank offers to corporate customers for

outsourcing their Accounts Receivables payment processing. We can use

AutoLockBox for historical data conversion. We can only load Cash Receipts, not

miscellaneous receipts as there is no invoice & customers.

Set Ups done before using Autolockbox Prog:

1) Set Up Receipt Bank : We define Bank with ‘Account Use’: Internal where checks from

customers are deposited. [ ARàSetUpàReceiptsàBank ]

2) Set Up Receipt Class : Here we assign Payment methods. [SetUpàReceiptsàClass]

3) Set Up Receipt Source: We define Receipt Batch Source and assign Receipt Class, payment

method and Bank Account to this source. [Set upàReceipts àReceipt Source ]

4) Define LockBox : Define Lockbox to use the Receivable AutoLockbox Program.

[Set UpàReceipt à LockBoxes àLockbox ]

5) Define Transmission Format : Autolockbox uses Transmission format for importing data

into receivables. Here we define Lockbox Header, Payment,

Lockbox Trailer.

[ Setup àReceiptàLockboxàTransmission Format ]

[ Define LockBox tells how Lockbox will handle Invalid Transaction Number.

1. Post Partial Amount as Unapplied: Apply the receipt to the valid transactions, then import the remaining receipt amount with a status of Unapplied.

2. Reject Entire Receipt: It doesn’t import the invalid receipt and data will remain in Interface table [ Ar_Payments_Interface ]. We can edit the invalid records in the “Lockbox Transmission Data Window”, then resubmit the validation step for the receipts before Lockbox can import it into Receivables.

]

Process:

1) We create Control File for flat data file, we get from bank.

2) Move the .dat file and .ctl file to $AR_TOP/bin

3) After that we first do Import, then validation and finally Post QuickCash.

AutoLockBox is a three step Process:-

1. IMPORT – During this step, Lockbox reads and formats the data from our bank file into

Interface table < AR_PAYMENTS_INTERFACE_ALL> using a SQL*Loader script.

2. Validation– This checks data in the interface table for compatibility with Receivables. Once the

data is validated , the data is transferred into QuickCash tables [Receipt Tables]

(AR_INTERIM_CASH_RECEIPTS_ALL, AR_INTERIM_CASH_RCPT_LINES_ALL).

3. Post Quick Cash - It applies the receipts and update our customer’s balances, So data goes

to Base tables.

Interface tables: AR_PAYMENTS_INTERFACE_ALL

AR_INTERIM_CASH_RECEIPTS_ALL

AR_INTERIM_CASH_RCPT_LINES_ALL

Base Tables: AR_CASH_RECEIPTS_ALL,

AR_CASH_RECEIPTS_HISTORY_ALL,

AP_RECEIVABLES_APPLICATION_ALL

Interface table Cols:

For Header: Status, Record Type, LockBox#, Deposit Date, Origination.

For Payment: Status, Record Type, Customer#, Invoice1, Check#, Remittance Amt, Receipt

Date, Item Number, LockBox Number.

For Trailer: Status, RecordType, LockBox#, Deposit Date, BatchRecordCount, BatchAmt,

Origination.

Validations:

(A) < AR_PAYMENTS_INTERFACE_ALL > -- [ TransmissionRecordID – Pk ]

Base Tables	Interface Cols	Validations
	Record Type	Is NN. Type of Record should exist.(Header(HE) / Payment (DE)/ Trailer (TR))
	LockBox Number	Should Exist.
AR_Batches	Deposit Date	Should be there. Entered by user using “Maintain Lockbox Transmission Date”.
AR Transmissions (Origin)	Origination	-- do --
AP Bank Branches (Bank Name, Bank Branch Name, Bank #)	Trans Routing#	-- do --
AR Cash Receipt	Receipt Date	-- do --

(B) < AR_INTERIM_CASH_RECEIPTS_ALL > -- [Cash Receipt ID – Pk]

Base Tables		Validations
Cash receipt ID	NN	Exists
Amount	NN	Should be there.
Currency Code	NN	Should exist in Fnd_Currencies.
GL Date	NN	Should be open.
Receipt Method ID	NN	Payment Method shod be specified.
Remittance Bank Account ID	NN	Shod have Bank Account, Assigned to receipt.
Who’s Columns	NN
Customer Trx ID	N	Should be there
Receipt Number	N	Receipt# - with Cash receipt should be there.

(C) -[Cash_Receipt_ID, Cash_Receipt_Line_ID-Pk]

Base Tables		Validations
Cash Receipt ID	NN	Should exist. Cash Receipt associated with Line.
Cash receipt Line ID	NN	Identifier of the individual, Cash_Receipt_Lines_All
Payment Sequence ID	NN	Should be there
Who’s Column	NN	Should be there
Sold to Customer	N	Identified of the customer. Associated with the Interim_Cash_Receipt_Line.
Customer Trx ID	N	Should be ther

source scribd.com