*Bidding is available in Version 374+*
This document will review enabling, configuring, and using the bidding feature in Yellow Dog. The bidding feature allows users easily import bid pricing from multiple vendors that the system will then sort through and select the best vendor & price based on the customers chosen bid selection method.
Along with being enabling bidding for a system there are some additional configuration options users can set in the Global section of Options under System Setup
This section will review creating Bid Selection methods. Bid selection methods are the user generated priority lists that indicate which criteria the system should look to to determine the winning vendor & price.
` 1.
From
within Yellow Dog navigate to Bid Selection Methods under System Setup
2. Select Create New
Bidding Method
This section will review enabling the bidding feature for stores
1. Navigate to Stores under System Setup
This section will review the new item configuration options for bidding within the Vendor Products tab of the item editor.
1. From with Yellow Dog navigate to the inventory items screen, filter to the item in question and double click to open the item editor or highlight the item and select Edit on the right2. Show PO Blocked item sizes – will allow users to view sizes that have been blocked from being added to Purchasing documents. Note: when these items are included, users will have the opportunity to unblock them by unchecking the Size PO Blocked box.
3. Size – will be the size assigned to that product
4. Count – will be the relationship between that product and the parent item
5. Size PO Blocked – will indicate whether the item is allowed to be added to purchasing documents.
6. Vendor – will indicate which vendor is assigned to that the product size
7. Primary Vendor – will allow users to indicate which vendor they consider the primary vendor. Note: Primary Vendor is one of the options for Bid Selection Method
8. Vendor PN – will be where users can enter the part number or vendor SKU for the item
9. Preferred Vendor Product – will allow users to indicate their preferred product or size. Note: Preferred Vendor Product is one of the options for Bid Selection Method
10. Vendor Product Active – will allow users to indicate whether a particular size is still needed or ‘active’. Items that have been discontinued by the vendor or no longer in use the customer can be made inactive by unchecking the box
11. Vendor Product Brand – is a text field and will be where users can indicate the manufacturer or brand of the item. It is not uncommon for a vendor to carry multiple brands of one product for example – Sysco carries Sysco brand lemons, and Sunkist Lemons.
12. Vendor Product Description – is a text field and will be where users can add the vendors description for that size.
13. Vendor Product Notes – is a text field and will be where users can add notes for that size as needed
14. Vendor Product Price – will be the vendor price used most recently on a purchasing document for that size
15. Unit Price – is calculated based on the relationship between that size and the parent item. Note: Best Unit Price is one of the options for Bid Selection Method
16. Price Last Updated – will indicate the last time the bid price was most recently updated.
17. Contracted – will allow users to indicate whether there is a contract with the vendor for the price of that item. Note: Contract price is one of the options for Bid Selection Method
18. Bid Price – will display the most recently updated bid price from the vendor
19. Bid Start – will display when the Bid Price for that item starts
20. Bid End – will display when the Bid Price for that item expires.
21. Price Allowance – will be where users can set an allowance value – this means that if the product is more expensive than the winning product in the bid worksheet up to the selected dollar value this product would be the winner. This field works in conjunction with the price allowance checkbox in the Bid Selection Method editor.
22. Priority – will allow users to rank their products lowest to highest. Note: Priority is one of the options for Bid Selection Method.
23. Create New/Remove Products – will allow users to add or remove sizes
24. Show Vendor Price History -will generate a report for users that displays historical vendor price changes that have occurred for that product
25. Clear Vendor Price History – will clear all vendor history. This should only be done if there are serious errors, as all historical data will be lost.
26. Clear bidding fields – will clear all bid prices, and dates
27. Add another vendor – will create an additional line for the highlighted size, with the chosen vendorNote: Not visible on the screen are columns for:
· Negative/Positive Deviation – where users can set the percentage values that you want to report on, if a vendor price fluctuates more than this percent.
· Order Qty Minimum & Order Qty Multiple – will be where users can set the minimum amount that they can order of a product and the amount they must order in multiples of.
· EDI dimension – allows users to track a vendors size when using split cases.
This section
will review updating Bid Prices. Users will have the ability to import the bid
prices quickly and easily from their vendors. A list of items that need to have
their vendor price updated can be exported from the vendor editor, provided to
the vendor to insert the current bid prices, and imported into Yellow Dog.
1.
From
within Yellow Dog navigate to Vendors & Manufacturers under Common Setup
4.
On
the right Select bidding export
a.
Note:
It is always
recommended to export Formatted data when exporting to excel.
8. . Once the updated file has been updated and returned it can be imported into Yellow Dog to update bid prices.
Navigate to the Vendor Products tab within the vendor editor and select Bidding Import on the right1. From within Yellow Dog navigate to Bidding under worksheets
2.
Select
Create New Bidding Worksheet on the Right
2. Description – will be the description that was entered at the beginning of the worksheet wizard. This can be updated within the worksheet editor.
3. Reference – will be a text field users can take advantage of
4. Order To Store – will be the store that is ordering product
5. Bid Selection Method – will be the bidding method chosen to generate POs for this worksheet
6. Committed – will be the date/time POs were generated from this worksheet
7. Notes – will be a text field users can add notes to about this worksheet
8. Regenerate Worksheet – will allow users to regenerate the worksheet when the bid selection method has been updated.
9. Requests tab – will display any requests that were selected to generate this worksheet based on
10. Items Requested tab –will display the items that need to be ordered. The source column will indicate whether the items was added from a request or manually. Users will see a variety of information including the Par & Re-Order points for the items in the purchasing store, the stores current on hand, when the item was last purchased, and any line notes included on the Request. Users will note the qty requested populates the qty to order column and that that qty can be edited as needed.
11. Bidding Results tab – will display which vendor was selected as the winner based on the Bid Selection Method selected for the worksheet. This tab will also display the bid period, the bid price for the item, the method used to select the winner, and the number of vendors assigned to the item
12. Vendors tab - will display the vendors that POs will be generated for. This tab will also display the number of items on each PO, the total qty being ordered the qty requested the purchase price and the total cost. The purchase price will be the total of the bid prices and the total cost will be the total cost of the PO – or the qty times the bid price for each item added together. Users will also be able to remove a vendor from this tab, and the worksheet will recalculate the results to exclude that vendor. Note: The vendor can be added back after the fact if needed.
13. Add/Edit/Remove – will be where users can add additional requests to the worksheet if needed, edit the highlighted request, or remove a request for the worksheet
14. Save/Save & Close – will be where users can save their progress on a worksheet or close the worksheet without generating POs
15. Print – will be where users can print the worksheet
16. Generate Purchase Orders – will be where users can generate Purchase Orders once the worksheet has been filled out
This section
will review generating bidding worksheets, and purchase order from within the
Request area of purchasing.
1. From within Yellow Dog navigate to Requests under
Purchasing
1. The Bidding Worksheet editor will open, with the highlighted Request(s) included.
Bidding worksheet
overview
2. Description – will be the description that was entered at the beginning of the worksheet wizard. This can be updated within the worksheet editor.
3. Reference – will be a text field users can take advantage of
4. Order To Store – will be the store that is ordering product
5. Bid Selection Method – will be the bidding method chosen to generate POs for this worksheet
6. Committed – will be the date/time POs were generated from this worksheet
7. Notes – will be a text field users can add notes to about this worksheet
8. Regenerate Worksheet – will allow users to regenerate the worksheet when the bid selection method has been updated.
9. Requests tab – will display any requests that were selected to generate this worksheet based on
10. Items Requested tab –will display the items that need to be ordered. The source column will indicate whether the items was added from a request or manually. Users will see a variety of information including the Par & Re-Order points for the items in the purchasing store, the stores current on hand, when the item was last purchased, and any line notes included on the Request. Users will note the qty requested populates the qty to order column and that that qty can be edited as needed.
11. Bidding Results tab – will display which vendor was selected as the winner based on the Bid Selection Method selected for the worksheet. This tab will also display the bid period, the bid price for the item, the method used to select the winner, and the number of vendors assigned to the item
12. Vendors tab - will display the vendors that POs will be generated for. This tab will also display the number of items on each PO, the total qty being ordered the qty requested the purchase price and the total cost. The purchase price will be the total of the bid prices and the total cost will be the total cost of the PO – or the qty times the bid price for each item added together. Users will also be able to remove a vendor from this tab, and the worksheet will recalculate the results to exclude that vendor. Note: The vendor can be added back after the fact if needed.
13. Add/Edit/Remove – will be where users can add additional requests to the worksheet if needed, edit the highlighted request, or remove a request for the worksheet
14. Save/Save & Close – will be where users can save their progress on a worksheet or close the worksheet without generating POs
15. Print – will be where users can print the worksheet
16. Generate Purchase Orders – will be where users can generate Purchase Orders once the worksheet has been filled out