AR Auto LockBox in oracle apps

AR Auto LockBox

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 > 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) [ 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) [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 there