Friday, 5 July 2019

Recording a Refund of a Prepayment or Advance - Oracle EBS R12

https://aporaclepayables.blogspot.com/2019/07/recording-refund-of-prepayment-or.html

Go through the section of "Recording a Refund of a Prepayment or Advance" in Payables user guide.

Note: We recommend that to record a refund, you enter a standard invoice and apply the prepayment to it. Then enter a debit memo and pay it with a Refund payment in the Payments window.

See: Refunds for Prepayments: page 6 – 10. 

Alternatively, record the refund by using the following method. Recording Refunds by Paying a Standard Invoice You can record a refund from a supplier that pays back an unused prepayment or part of a prepayment. When you do this, Payables reverses the prepayment so that it is no longer outstanding and so that you can no longer apply the prepayment to an invoice. The net effect is a debit to your cash (asset) account in the amount of the refund and a credit to the prepayment account in the amount of the refund.

You can use exactly the same method to record a refund from an employee for an advance. 

Invoices 4 – 245 
Prerequisites 

1. You have entered and paid a prepayment or advance. 

2. The supplier or employee has refunded the unused portion of the prepayment. 

3. If the supplier or employee has not refunded the entire prepayment, apply the appropriate amount of the prepayment to an invoice or expense report. 

To record a refund of a prepayment: 

1. In the Invoices window, enter an invoice in the amount of the refund from the supplier. Enter Standard for the type. Enter a description on the invoice to indicate that you are retiring a prepayment. Create an Invoice distribution for the amount of the refund to debit your cash account. 

2. Choose the Actions button to navigate to the Invoice Actions window. Select the Apply/Unapply Prepayment check box and choose OK. 

3. Select the prepayment you want to apply. Enter the refund amount in the Amount To Apply field. Optionally change the GL Date. 

4. Choose the Apply/Unapply button to apply the prepayment amount to the invoice you entered for the refund and to save your work. 

This fully retires the prepayment. This credit balances the debit you entered on the invoice (Step 1) to the Cash account. 

4 – 246 Oracle Payables User Guide

Suppose, you have given an Advance of Rs. 1000 to a contractor and the Total Expenses were made of Rs. 500. Now the remaining Rs. 500 have to be refunded from Supplier.

Prepayment Invoice
01-001-000-248111100-000-00-0000-0000
Liability

1000
01-001-000-112121501-000-00-0000-0000
Prepaid expense
1000

Prepayment Payment
01-001-000-248311403-000-00-0000-0000
Cash

1000
01-001-000-248111100-000-00-0000-0000
Liability
1000

Standard Invoice
01-001-000-581139210-000-00-0000-0000
Item expense
500

01-001-000-248111100-000-00-0000-0000
Liability

500
Apply Prepayment
01-001-000-248111100-000-00-0000-0000
Liability
500

01-001-000-112121501-000-00-0000-0000
Prepaid Expense

500

                Refund Recommended Method




Standard Invoice
01-001-000-101990105-000-00-0000-0000
Item expense
500

Invoice Distribution Clearing Account
01-001-000-248111100-000-00-0000-0000
Liability

500
Apply Prepayment
01-001-000-248111100-000-00-0000-0000
Liability
500

01-001-000-112121501-000-00-0000-0000
Prepaid Expense

500
Debit Memo
01-001-000-101990105-000-00-0000-0000
Item expense

500
Invoice Distribution Clearing Account
01-001-000-248111100-000-00-0000-0000
Liability
500

Debit Memo Payment
01-001-000-248311403-000-00-0000-0000
Cash
500

01-001-000-248111100-000-00-0000-0000
Liability

500

                         Refund Direct Method




Standard Invoice
01-001-000-248311403-000-00-0000-0000
Cash
500

Invoice Distribution Clearing Account
01-001-000-248111100-000-00-0000-0000
Liability

500
Apply Prepayment
01-001-000-248111100-000-00-0000-0000
Liability
500

01-001-000-112121501-000-00-0000-0000
Prepaid Expense

500

1 comment:

  1. Thanks Tariq,
    there is another way in diff scenario,
    if the prepayment was permanent and employee want to return it all,
    we can create a mixed invoice and apply it to prepayment then make a refund.
    ref:

    https://www.youtube.com/watch?v=xLxuRI_L4XA

    Thanks again .......
    Ali

    ReplyDelete