Place Quote from PQM in Requisition Worksheet

The Purchase Quote Manager can also be used for Requisitions Worksheet lines. Similar to the running the functions on the PQM page, purchase quotes can be created for each assigned vendor and then the quote that is most cost-effective and/or provides the best delivery time can be chosen for order placement.

This topic describes how to use COSMO Purchase Quote Manager with the Requisition Worksheet. It expects that the PQM Setup is complete and vendors have been assigned to the item to be quoted. For more information, see Setup. Furthermore, it expects that the item is set up with a Reorder Quantity so that a line is created in the Requisition Worksheet when the Calculate Plan function is run.

To create PQM for an item using the Requisition Worksheet

Choose the icon, enter Requisition Worksheets, and then choose the related link.
On the Home menu, choose the Calculate Plan action and then enter the correct date range and filter for the item that needs quotes.
Select the line for the item and then choose PQM > Create on the Related menu.
With the option for Selected lines only selected, choose the OK button.
Notice that the No. and Description fields are populated in the General FastTab and the PQM Lines FastTab contains the following information from the Requisition Worksheet line:
- Item number and description
- Quantity
- Vendor No.
- Unit Cost
- Order Date
- Total Direct Cost (field is not shown by default)
Choose the Assigned Vendors action and then enter the vendors to include in the quoting process. Assign a vendor as a 100% Bidder as needed.
Close the Assigned Vendors page.
On the Actions menu, choose Functions > Assigned Vendors > Copy from Header to Lines. Notice that the Assigned Vendors field is updated in the Lines FastTab.

To create purchase quotes for the PQM lines

Choose the Create Purch. Quotes action. The PQM Placing Matrix page opens.

The unit cost and purchase line amount display the current values from the document. For each vendor quote, the price is populated based on the purchase price of the quantity in the PQM page. The calculated availability based on lead time is also shown.

Based on the settings in the Options FastTab of the PQM page, the complete purchase amount, the difference percentage, and a summary line are shown for each quote. In addition, the vendor with the lowest cost is shown in bold green text (depending on outlier highlighting). You can also show ideal, average, and median prices via the toggles in the Settings section.

Tip

On the PQM page, the toggles in the Options FastTab can be turned on or off to view different information in the PQM Placing Matrix page.

If a vendor offers a different price, choose the value below the vendor to open the quote and change the unit cost. It will be updated automatically in the PQM Placing Matrix page.
Close the PQM Placing Matrix page to return to the PQM page.
In the Lines FastTab, notice that the:
- Status Created field = Yes
- Status Verified, Status Placed, and Status Not Placed fields = No

To change the quote status

Depending on business processes, the status of each quote can be changed to Verified once the quotes are validated by the vendors.

In the Lines FastTab, choose the value in the Status Created field to open the PQM Vendors page.
Choose the Edit List action.
For each quote, change the Status to Verified.
Close the PQM Vendors page.
If necessary, refresh the PQM page and notice that the:
- Status Verified field = Yes
- Status Created, Status Placed, and Status Not Placed fields = No

To place the best quote

The quote for the vendor with the best price and delivery date should be chosen but can be overridden manually.

Choose the Purchase Quotes Matrix action to open the PQM Placing Matrix page.
Choose the Placing action.
Choose the OK button to select all lines for placement.
In the Placing of Purchase Quotes page, turn on the Select Best Price toggle to automatically select the vendor with the best price. Alternatively, turn off the toggle and enter the winning vendor in the Vendor No. field.
In the Options FastTab, turn on the Update Source Data toggle.
Choose the OK button.
In the PQM Placing Matrix page, notice that the:
- Assigned checkbox is selected
- Values are cleared for the vendors that were not selected
Close the PQM Placing Matrix page to the PQM page.
In the Lines FastTab, notice that the:
- Status Created and Status Verified fields = No
- Status Placed and Status Not Placed fields = Yes
- Placing Vendor No. = winning vendor
- Placing Unit Cost = direct unit cost from placed purchase quote
- Difference Unit Cost = sum of Source Unit Cost - Placing Unit Cost
- Assigned checkbox is selected
- Source Status = Updated (due to turning on the Update Source Data toggle)
Choose the value in the Status Placed and/or Status Not Placed fields to see quote information for all vendors. In the PQM Vendors page, the status indicates the winning/losing quotes. From this page, the quotes can be opened by choosing the value in the Quote No. field.
Go back to the PQM page.
If no further changes need to be made, choose the Finish action to complete the processing for this PQM.

To review the Requisition Worksheet line

Choose the icon, enter Requisition Worksheets, and then choose the related link.
Notice that the:
- Vendor No. = winning vendor
- Direct Unit Cost = direct unit cost from placed purchase quote

To access the PQM again at any time for this Requisition Worksheet line, choose PQM > Show PQM on the Related menu.