Friday, September 10, 2010

AR AutoLockbox



AutoLockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. An AutoLockbox operation can process millions of transactions a month. AutoLockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. You specify how you want this information transmitted and Receivables ensures that the data is valid before creating QuickCash receipt batches.

In more simpler words, Autolockbox is a program available in Oracle Receivables which helps you import payments or receipts. In real world, Banks would provide datafiles which would have information about the payments made by customer’s. Receivable’s autolock box program would help you in importing information from these datafiles into your system

Steps for Lockbox are:

1) Import: The first step involves reading and formatting data from your bank file into AutoLockbox tables. Basically here, a loader program loads data into AR_PAYMENT_INTERFACE_ALL table

2) Validation: The second step involves submitting the validation program which checks data in the AutoLockbox tables for compatibility with Receivables. Once data is validated, it is transferred into QuickCash tables. At this point, you can optionally query your receipts in the QuickCash window and change how they will be applied before submitting the final step.

This step moves the data into AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RECEIPT_LINES_ALLtables

3) Post QuickCash: Use the QuickCash window to review each receipt and use the Applications window to ensure that the application information is correct. After you approve the receipts and their applications, run Post QuickCash to update your customer's account balances. Match is Found or Not Found, Status will be UNAPPLIED.
A matching number can be a transaction number, consolidated billing invoice number, sales order number, purchase order number or another, custom defined number.

This moves the data into the AR base tables like- AR_CASH_RECEIPTS_ALL, AR_RECEIVABLES_APPLICATIONS_ALL, AR_CASH_RECEIPT_HISTORY_ALL
 
4) Action: After a receipt is successfully imported into Receivables, you can reverse and reapply them and apply any unapplied, unidentified, or on-account amounts just like a manually entered receipt

Transmission format


1) AutoLockbox uses the transmission format you specify in the Submit Lockbox Processing window to ensure that data is correctly transferred from the bank file into the AR_PAYMENTS_INTERFACE_ALL table.

2) Transmission formats contain information such as the customer number, bank account number, the amount of each receipt to apply, and transaction numbers to which to apply each receipt

3) Two Windows are important while doing this interface as below
• QuickCash window
• Maintain Transmission Data window
(Receipts that fail validation remain in the AR_PAYMENTS_INTERFACE table until you manually correct errors using the Maintain Transmission Data window)

4) After a receipt is successfully imported into Receivables, you can apply, reverse, remit, or place it on account, just like a manually entered receipt

6 comments:

  1. Hello,

    In the following Post quick cash process, In step 3, The post quick cash is updated the customer balance first.After that it is applying the receipt.

    My question is why the Post quick cash process updating customer balance before applying the receipt. if suppose to apply the receipt first after that it should update customer balance, Is it correct? What am i missing?

    Please let me know.

    Thanks, Raghu.K


    -----------------Begin ----------

    3) Post Quick Cash: Submitting Post Quick Cash updates your customer’s balances. Match is Found or Not Found, Status will be UNAPPLIED.
    A matching number can be a transaction number, consolidated billing invoice number, sales order number, purchase order number or another, custom defined number.

    This moves the data into the AR base tables like- AR_CASH_RECEIPTS_ALL, AR_RECEIVABLES_APPLICATIONS_ALL, AR_CASH_RECEIPT_HISTORY_ALL

    4) Action: After a receipt is successfully imported into Receivables, you can apply, reverse, remit, or place it on account, just like a manually entered receipt

    -----------------End --------------

    ReplyDelete
  2. Updated the post to avoid confusion and make it more correct, please review the same..


    Amit

    ReplyDelete
  3. Dear Amit,

    Wish you happy new year 2012.

    Please correct me if i am wrong on the way i am processing auto lock box.
    1) Read all bank files and insert into interface table AR_PAYMENT_INTERFACE_ALL manually using custom pl/sql then
    2)using FND_REQUEST.SUBMIT_REQUEST
    (application => 'AR'
    ,program => 'ARLPLB'
    I can submit concurrent program. above two steps are working fine but getting many errors.

    Pls let me know this approach correct or not.

    Raj

    ReplyDelete
  4. Thanks for the process steps.

    Now, if I wanted to reverse an entire batch how would I do that? Considering I have followed all of the steps detailed.

    ReplyDelete
  5. Would you happen to know the program that controls the Auto Cash process step? We have two responsibilities created and one of them does not apply the receipts correctly and the other one does - we need to figure out what program we need to add to the responsibility that is not working correctly....any ideas.....(we have Oracle SR opened, but no solution has been provided yet)

    ReplyDelete
  6. Have you tried program - Process Lockboxes?

    ReplyDelete

Note: Only a member of this blog may post a comment.