Lockbox in Oracle Applications

Lockbox  

Simple and easy steps to oracle Lockbox

A beginners guide for oracle lockbox.

Introduction

–Lockbox is kind of a service which is provided by banks by which your company can gets the customers payments directly to a lockbox interface tables and creates receipt for the payments deposited into your account. If you have an Auto Lockbox, the bank records the information that you request such as check number, check amount, numbers and amount for the invoices to be paid and keep record of that.

Lockbox process flow

Lockbox process flow

Transmission format of a Flat file

Matching rules

Lockbox uses the Match Receipts By method specified for this Lockbox and your customer or customer site when determining how to apply each receipt. If the customer number or MICR number is not provided in your transmission, Lockbox tries to identify the customer and the invoice to which each receipt should be applied based on whatever information is included




Transaction Number :-
Transaction number is MICR (Combination of branch number and account number )number by which one can identify branch number, bank code and customer account number.

Sales Order Number :-
If the matched number is a sales order number, Lockbox searches for the first invoice that belongs to this order.

Purchase Order Number:-
If the matched number is a purchase order number, Lockbox searches for a reference number that refers to this purchase order.

with the help Oracle lockbox process standardisation while applying the receipt can be followed