Tuesday, 10 April 2018

Return to Vendor in Oracle apps R12

Following description will take you to the RETURN TO VENDOR transaction, which is in synchronization with Purchasing, Inventory and Payable modules. It has all the required information in order to practice this cycle in EBS R12.



Return to Vendor
RTV is used for to return the items to supplier. If buyer had made PO for certain items and after receiving at inspection section buyer found that some of the ordered items are defective, then returning of those items is transacted by RTV.
Let’s start from beginning
Create purchase requisition. Go to Purchasing responsibility > Requisitions > Requisitions



Click on Approve  and it goes for approval.



To create PO, go to Auto create and enter the requisition number.
And then click on Automatic



Enter supplier name and site and then click on create.



Then the PO form will be open and after checking all the information on PO form approve it. So status of PO will be approved.



Now as per simple P2P process we have to make receipt of ordered item .
Go to purchasing > Receiving > Receipts
Enter the PO number and click on Find
Then check the flags for lines in receipt form and save it so receipt number will be generated.



Now go for receiving transactions and again enter PO number or receipt number. Then check the flags at lines and save it so those items would be received and added to on hand quantity in inventory.



Now all three items has been received, then buyer found that 40 quantity of win01 are defective and buyer wants to return it. For that,
Go to Purchasing > Receiving > Returns



Enter PO number and click on Find button.



Clicking on find button, following window will be opened. In that we can return items which we have ordered in desired quantity.
Here we want to return win01 items in 40 quantities so we will check line of win01 and enter 40 numbers of quantity. Then save it.



Here we had completed part of purchasing module and now we have to create AP invoice for win01 (60 quantity), win02 (200 quantity), win03 (300 quantity) and credit memo for win01 (40 quantity).
First of all, go to payables > invoices > Entry > Invoices
Enter required information.
Then press match button and enter PO number then press Find button.
Then check all three item flags and press Match button.



Now the following screen will be shown, and we need to validate it by going Actions tab.


Press actions button.
 



Check on validate and press OK.
So the status of the invoice will be changed to Validated.



Now again click on Actions and select pay in full and create accounting then press OK.
Following dialogue box will be appeared.



At payments window fill all the required information and click on Actions.
Check on create accounting and final post



At payments form, following form will be generated.
Here buyer had paid for its 600 quantities but now buyer need to create credit memo for 40 quantities of win01 which was returned.



To create credit memo,
Go to Payables > Invoices > Entry > Invoices
Enter all the information including PO number and change type to credit memo.



Then click on Match and enter the required information and minus amount of quantity at Match form. Then the following form will be generated.



Now invoice needs to be validated. To validate invoice click on Actions button and check on validate flag.
Then click on OK button.



So the status of invoice will be changed to Validated.
Now again click on Actions and check the flags : Pay in full and create accounting, then click on OK.



At payment form fill the required information and save it.



Then click on Actions and check the flag create accounting and final post.
So here we have generated credit memo for 40 quantities of win01.


9 comments:

  1. It’s too informative blog .All the Details were explained in clear manner.Thanks for sharing this blog. Internal Audit | Warehouse Audit | Fixed Assets Audit


    ReplyDelete
  2. Your blog was very interesting & easy to understand. Thank you so much sharing that valuable blog. AP Vendor Helpdesk
    Duplicate Payment Audit
    Duplicate Invoice Audit

    ReplyDelete
  3. Very informative.
    But for some reason, I can't see almost half of the images.
    Thanks anyway. The text is self explaining.

    ReplyDelete
  4. After half of the page can't show the image.

    ReplyDelete
  5. Hello -- Am looking for a set-up where you can prevent the user from using "return to vendor" when the Receipt already had APV.
    is it available in R12?

    ReplyDelete
  6. I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Fusion Financials.Actually I was looking for the same information on internet for Oracle Fusion Financials and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  7. Some of Images are not visible, From "Press actions button".

    ReplyDelete
  8. Really lovely information. Thank you for posting this article, and please continue to do so. Really lovely information. ERP Software in Chennai

    ReplyDelete
  9. Cool and I have a swell offer: House Renovation Designer Near Me old home renovation

    ReplyDelete