While working on your RFQ, you may encounter errors when responding to the quote. You can use these link shortcuts to quickly read a specific section in the article.
- Manually Entering within Supplyframe
- Highlighted Errors
- Required Fields
-
Troubleshooting Column Responses
- MPN/Manufacturer (Alternates/Crosses/Part Corrections)
- Integers (Numeric Only)
- Package Type
- Flags
- Start / End Dates
- Upload File Formatting
Manually Entering within Supplyframe
When responding directly within Supplyframe manually, you will need to:
- Double click on the cell that you want to edit.
- Type in your response within the cell field.
- Click the "Enter" (or "Return") key on your keyboard to save your entry.
Highlighted Errors
After entering or uploading your responses, Supplyframe will display line items with errors by their rows being highlighted in red. Click on the Filter dropdown and select Show Errors Only Items to easily see which line items need to be corrected. The specific column(s) in a row that needs to be updated will have a red border line around the specific line item's cell.
Hovering over the cell will provide more details regarding the errors for that field.
You can easily make any needed corrections on the page within Supplyframe. Click into the cell to update the field as needed and then hit enter to save your correction.
Required Fields
If your customer has columns in the RFQ that are required, then it will display an error when those required columns are missing data. Be sure to fill in all the columns marked as required, which will display as highlighted in the RFQ. The columns will be highlighted as displayed below.
Within Supplyframe "Required" Fields
Uploading in Excel "Required" Fields
Troubleshooting Column Responses
MPN/MFR - Alternates / Crosses / Part Corrections
When suggesting alternates or part number corrections for MPNs or Manufacturers, these should only be entered in the "Recommended MPN" or "Recommend Manufacturer" fields.
Allow Crosses
Be sure to check if "Allow Crosses" in RFQ Details says "Yes" (accepted) before quoting alternates.
Recommended Fields
The Recommended columns will be as displayed below.
Within Supplyframe "Recommended" Fields
Uploading in Excel "Recommended" Field
Integers / Numeric Only
For the columns of Stock, LT(WKS), MIN/MULT, and PRICE: these entries must all be numeric only (integers). Do not add extra text such as "7 Weeks", "3 months", or "2 thousand".
STOCK
Quantity available for sale. (Integers only) You can see a correct example and then wrong (error) example below.
Correct
Wrong (Will Show as an Error)
LT(WKS)
Lead time in weeks. (Integers only) You can see a correct example and then wrong (error) example below.
Correct
Wrong (Will Show as an Error)
MIN/MULT
Minimum and multiple order quantities. (Integers only)
Correct
Wrong (Will Show as an Error)
PRICE
The price you're quoting for the requested quantity. (Integers only) You can see a correct example and then wrong (error) example below.
Correct
Wrong (Will Show as an Error)
PACKAGE TYPE
For the Package Type, you can use the dropdown to select the corresponding response.
Within Supplyframe Dropdown
Hovering over the cell will display its accepted values.
Uploading in Excel Dropdown
Clicking on the cell will display its dropdown of accepted values.
In addition, these are the acceptable options that can be entered:
Ammo, am, ammo pk, ammo pack, ammo pkg
Bulk, b, bk, blk, bl
T/R, tape/reel, tape & reel, t&r, tape, reel, t, rl, r
Tube, tu, tb, rail, ral
Tray, ty, try
Cut Tape, ct, ctape, cuttape, cut
These are not case sensitive.
FLAGS
You can flag an item as: No Bid, RoHS compliant, Lead Free, NC/NR (Non-cancellable/Non-returnable), Obsolete, or Tariff if applicable.
Within an Excel upload, you can respond by putting "Yes", "Y" or "1" in the corresponding cell.
You can see a correct example and then wrong (error) example below.
Correct
Wrong (Will Show as an Error)
START / END DATES
For the Start Date / Expire Date, you can enter in one of the formats:
- MM/DD/YYYY
- MM-DD-YYYY
- MM/DD/YY
- MM-DD-YY
Please spot check one of the dates following your upload to ensure that other Excel regional settings have not interfered with the expected format during upload. If you do see an issue, please ensure that you have selected "English" (United States) for the "Date" setting in Excel.
Upload File Formatting
Make sure you do not remove the Row ID number, change headers or add tabs. This will create issues and errors when uploading.