Saturday 28 September 2013

Request for Quotation

RFQs are sent to the suppliers so that they can send the quotations for the items required. RFQ can be created either Manually or Automatically & it of 3 types

1.)   Standard RFQ: It is used for normal orders & suppliers will send the quotes only for those items for which the RFQ has been sent
2.)   Catalog RFQ: It is also used for normal orders & suppliers along with the quote of the requested items, will be sending catalog for other items as well
3.)   Bid RFQ: This is generally used when amount at stake is high & we need to buy goods only once


First we’ll create RFQs using Autocreate option. Navigate to Autocreate à click on find. You can see a list of requisitions been created.




Here also we have an option of Manual or Automatic. First we’ll see the Manual option.

Note that the document type has to be RFQ before you can proceed further


Click on Manual > Select the line & click on Add to Document


Click on Create & give supplier list name



Click on create

With this the RFQ is created



In the above mentioned form we have following fields

Due Date: It is the date from which we want our suppliers to start sending us the quotations
Quote effectivity: This includes a date range during which the price of items will not change
Close date: This is the date from which the quote will be considered as closed.

Check the Quote Approval required check box & click on Price Breaks



In this form split the item quantity in as many lines as you wish. The supplier will tell that on buying items mentioned in each line how much discount can He give. Save the record & close the Price Breaks form.

Now manually change the status to Active



& click on Suppliers



Here we can see that the suppliers name has been populated



Now we’ll create requisition using Autocreate option

Navigate to Autocreate & click on Find. From the list of requisitions select 2 requisitions



& click on Automatic

Give Supplier list name



Click on Create. A RFQ will be created


Here we have only 1 line unlike 2 lines when we have created RFQ Manually. Click on Price Break & you can see both the lines


Change the status of this RFQ to Active



& Save the record.

Now submit a concurrent request ‘Printed RFQ Report(Portrait)’ & give parameters as shown below



Once the concurrent program completes, the status of RFQ will change to Printed





Now the RFQs have been sent to suppliers. Suppliers will receive it & send back the quotations. In order to fetch the data sent by the suppliers, we will navigate to RFQ’s and Quotations > RFQ’s à Query for RFQ à Tools > Copy Document & give details as shown below


& press OK.


Similarly do for other RFQ as well



Open the quotations & click on price break. Give price break as shown below



Save the record & do the same for other quotation as well



Once done change the status of quotation to Active





Approving the quotations

Quotes can be approved in following ways

1.)   Navigate to RFQ’s and Quotations > Quote Analysis à Click on Find



Select the line you want to approve & give line details



2.) Click on Approve Entire Quotation & give details as shown below



With ‘Approve Entire Quotation’ option only the lines corresponding to that quotation will be approved.

3.)   Navigate to RFQ’s and Quotations > Quotations à Query for Quotation à Click on Price Breaks



Click on Approve & give details as shown below



4.) Navigate to RFQ’s and Quotations > Quotations à Query for Quotation à Click on Approve & give details as shown below



We use Approval process in Quotations so that the approved prices will be reflected in Purchase orders.

With this RFQ setups are completed


The base table impacted is PO_HEADERS_ALL. This table will have details of  RFQs, Quotations & PO. Some of the important columns are

1.)   TYPE_LOOKUP_CODE: It will have details of document type. PO will be present by the name of its type (Standard, Planned etc.)
2.)   SEGMENT1: It will have the corresponding document number
3.)   STATUS_LOOKUP_CODE: It will have the status code of the document
4.)   QUOTE_TYPE_LOOKUP_CODE: It will have details of type of RFQ

4 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Nice Explanation, can you include the screen showing the PO creation based on the Quote, how the quote is link to PO

    ReplyDelete
  3. Thanks for your help vipul. Its been a good explanation by you with proper steps and explanation

    ReplyDelete
  4. This is helpful for me. TQ

    ReplyDelete