Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

AR Deposit : Details, setup, Flow, Accounting and API

Posted on September 3rd, 2008 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Oracle AR supports two types of commitments:

  • Deposit – This records a customer’s prepayment for goods or services that you will provide in the future.
  • Guarantee : This records a contractual agreement with your customer to conduct a specific amount of business over a defined period of time.

Oracle Define these two Receivables Transactions as:

  • Deposit :Bill Customers for Contractual Agreements
  • Guarantee :A Contractual Agreement that is referenced by invoices.Bill Customers for the items on the invoices not the Guarantee

Therefore ,deposits is Money Received in advance from a Customer for supplying goods to the Customer. Once Invoice is raised on Customer, that Deposit money is adjusted against the Invoices we raise onto Customer.

dgreybarrowStandard AR Deposits Procedure

  • Step 1 Create Deposit
    Once in the Transactions window the initial entries will be very similar to that required for an invoice. The only differences here are transaction Class should be Deposit and the Type should be Commitment.
  • Step 2 Bill Customer for Deposit
    This is the stage when customer needs to make a payment for the deposit.
  • Step 3 Create Invoice
    An invoice is created for same or related customer.
  • Step 4 Apply Deposit to Invoice
    Deposits can be applied against invoices. Deposit balances refer to the amount due remaining on a deposit. The balance is reduced by receipts and credits.
  • Step 5 Collect Deposit from Customer
    Deposits should be collected from customers and applied like any other receipt.

dgreybarrowHow its work :Accounting Flows and Transactions

  1. Lets assume customer agrees to pay 500 as deposit. Deposit for $500 is created. (Not received)
  2. Customer billed for deposit. Deposit and commitment balance $500.
  3. Invoice for $100 is created for customer.
  4. Deposit applied to invoice. Invoice balance =0, Deposit balance=$500, and commitment balance=$400.
  5. Customer pays deposit. Invoice balance=$0, Deposit balance=$0, and commitment=$400
  • EVENT 1 : Customer agrees to pay deposit:
    Dr Receivables (deposit) 500
    Cr Unearned revenue 500
  • EVENT 2 : When an invoice of 100 is applied to the deposit
    Dr Receivables (invoice) 100
    Cr Revenue 100
  • EVENT 3
    Dr Unearned revenues 100
    Cr Receivables (invoice) 100
  • EVENT 4
    When payment of $500 is received
    Dr Cash 500

Journal Entries

Deposite Accounting entry

dgreybarrowDeposit Application Program Interface (API)

  • A new approach for creating deposit commitments
  • Assigns non-revenue sales credits

dgreybarrowDeposit Application Program Interface benefits

  • Control over how and when deposits are created
  • Minimize the amount of parameters needed
  • Validate to ensure quality data
  • Provide messages to aid in exception handling
  • Immediate Results

dgreybarrowThe API’S

Public API’s is AR_DEPOSIT_API_PUB

These APIs provide an extension to existing functionality of creating and manipulating deposits.

  • tickar_deposit_api_pub.create_deposit: creates a single deposit and completes it.
  • tick ar_deposit_api_pub.insert_non_rev_salescredit: Creates non revenue sales credit for a deposit.

dgreybarrowThe API’S Availability

This API works both in R11i and R12.You can check the details at irep. Here is sample code for Deposite creation.

dgreybarrowTechnical Flow

Once you create Commitment(Deposit) , these are Oracle table get affected.

  • RA_CUSTOMER_TRX_ALL
  • RA_CUSTOMER_TRX_LINES_ALL
  • RA_CUST_TRX_LINE_GL_DIST_ALL
  • AR_PAYMENT_SCHEDULES_ALL

Lets analyse how data entry affect tables.

Deposit number : HubDep01
Bill to : OracleAppsHub.com
Deposit Date : 15-Jul-2008
Amount : 100

Once you enter these table get affected.

1 RA_CUSTOMER_TRX_ALL

1

2 RA_CUSTOMER_TRX_LINES_ALL

2

3 RA_CUST_TRX_LINE_GL_DIST_ALL

3

4 AR_PAYMENT_SCHEDULES_ALL
4

 

dgreybarrowOracle Documentation

dgreybarrowSimilar Post

Related Posts

Posted in Oracle Receivable | 4 Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
4 Responses
  1. Jouke Says:

    Sanjit,

    One addition: it is also possible to enter the commitment number in Order Management (Sales Order Line level, field must be made visible with the Folder tools). Once the order is shipped, AutoInvoice will apply the commitment against the new invoice. This will automatically reduce the balance of the invoice.

  2. GtG Says:

    I have a question on deposit date, once the batch is posted, can I change the deposit date? What is the impact if deposit date is changed.

    Thanks,

  3. Kelly Says:

    If the commitment/deposit total doesn’t cover the AR invoice total, can you display the reduction in balance on the invoice?

  4. Yogesh Says:

    Thanks. Very Helpful

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.