Skip to main content

Auto Lock Box Pre-Configuration and setups with Pictures

 

Accounts Receivables Basic Configuration should be completed

Auto Lock Box Pre-Configuration

Accounts Payables Side:-

1.       Bank Related Setups

¤  Manage Banks

¤  Manage Bank Branches

¤  Manage Bank Accounts

 

2.       Manage Business Unit Set Assignment

 

¤  Reference Data Object > Receivables Lockbox > “Common Set” Should be Assign/Own Set (Reference Data Set)

Accounts Receivables Side:-

3.       Manage Receipt Classes and Methods

Click + (Receipt Class)

¤  Name                               :             KIA_LOCK_BOX

¤  Creation Method           :             Manual

¤  Remittance Method      :             No Remittance

¤  Clearance Method         :             Directly

 

¤  Click + (Receipt Methods)

¤  Click + (Remittance Bank Accounts)

¤  Assign the existing bank account and relevant account combination

 

4.       Manage Receipt Sources

 

¤  Receipt Source Type                    :             Manual

¤  Assign the Receipt Class, Receipt Method and Bank Account

¤  Batch Numbering                         :             Automatic

¤  Batch Number Starts After         :             1

 

5.       Manage Lockboxes

6.       Manage Transmission Formats for Lockbox

7.       Create New Customer/ identify an existing customer

Value used to uniquely identify the Bill-to customer site for the transaction.

o   To identify an existing customer site:

o   Navigate to Billing Work Area.

o   Click Manage Customers in the task pane.

o   Review the available sites for the account on the Sites table on Manage Customer page.

o   Provide a Site Number that has a Bill-To Purpose assigned.

Value used to uniquely identify the Ship-to customer account for the transaction.

o   To identify an existing customer account:

o   Navigate to Billing Work Area.

o   Click Manage Customers in the task pane.

o   Review the available accounts in the Accounts table on the Manage Customer page.

o   Provide an Account Number that has a site defined with Ship-To Purpose assigned.

 

8.       Manage Daily Rates for (USD to Any-Currency)

9.       Current Receivables Period should be Open

10.   Create One New AR Transaction

BP

*     Load Interface File for Import

*     Process Receipts through Lockbox > elect Submit Post Receipt = Yes

*     2nd Time also run if you’re not posted the receipt > Process Receipts Through Lockbox

 

 

A service that is provided by commercial banks to their corporate customers so that they can process payments in their accounts receivable. It helps in auto processing of receipts eliminating manual entry and the money is sent directly to the bank.


Auto Lock Box Setups





Search for your bank account



 

         


    






































Download FBDI file from Oracle OER

Receivables Standard Receipt Import

Fill the required data and convert the zip file to upload the file


Comments

Post a Comment

Popular posts from this blog

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more