1. First you need to get to the pricing/costing import page in your environment.
2. You'll need to click on the Parts module located at the top of the page. Next click on the Pricing Maintenance submodule to populate a dropdown menu. In that dropdown menu you'll click on the Pricing/Costing Import link.
3. You're now at the pricing/costing import page and ready to start adding those resale/cost breaks!
4. Start up an .xls file on your computer and input the following column headers to use - Prc, Part, Qty, Cost, and Resale. These will be the headers that you're going to use and match in the import tool. You can also combine the PRC & Part columns together into a Prcpart column if desired.
5. Below is a screenshot of an example that has been formatted to implement the multiple cost/resale price breaks you're wanting to implement in your system.
6. You'll see in each row the PRC, Part, Qty, Cost, and Resale headers have been repeated 3 times in succession for each row of data. This will import 3 different resale/cost price breaks according to the qty input into the Qty header.
7. For BOMExamplePart a value of 10 is set in the Qty Field so the Cost of 100 and Resale of 1000 will be set for any qty of 10-19. This stops at 19 due to the second section of headers indicating a cost of 200 and resale value of 2000 is set to start at Qty 20. That cost and resale value of 200/2000 will be set for any qty between 20-29. This stops at 29 due to the third section of headers indicating a cost of 300 and resale value of 3000 is set at Qty 30 and so forth.
8. Once you've finished formatting your .xls or .csv file, selecting the file in the pricing/costing import tool, and matching the headers to its respective columns you're set to press Update and Finish to complete the import!
9. After the import pushes through head to the Pricing page on the prcpart record left hand-nav menu to check those changes out (found under the Price/Cost+ dropdown!