Supplier Part Costs
.png){kind=small}
Supplier Part Costs - 3 minutesSupplier Part Costs - 3 minutes
The Supplier Part Cost table stores part/core costs by the supplier and can be populated by importing a file using DFIU (Data File Import Utility) or manually by entering part costs in the SUPPLIER PART COSTS screen. By setting up the part costs, orders can be created for the supplier giving the best purchase price.
Menu Path: Inventory, Part Entry, Supplier Part Costs, SUPPLIER PART COSTS screen
Supplier Part Costs Setup
Multiple supplier order profiles (one per supplier), can be set up and run with the same list of parts ordered.
The 'Best Price' Order Create option is used to evaluate any number of supplier costs per part and to automatically remove parts from the order if the supplier does not have the lowest part cost. Only parts remain on the order where the supplier has the lowest part cost.
For example, to determine which supplier has the lowest cost per part, 75 parts are ordered from eight different suppliers. Using the 'Best Price' option, if eight different supplier profiles are run, only three purchase orders would be created if three of the eight suppliers had the lowest costs for the 75 parts; 65 parts on one supplier order, nine parts on the second supplier order, and one part on the third supplier order.
The 'Lowest Cost Profile' order method can be used to create one supplier order for the supplier with the lowest total cost for all parts ordered. Using the example above, since the first supplier had the lowest cost for 65 parts, that would most likely be the supplier chosen by the system for all 75 parts even though that supplier had a higher cost for 10 of the 75 parts.
An unlimited number of supplier part costs, per part, can be set up on the SUPPLIER PART COSTS screen and compared for the lowest cost ordering. Only parts that already exist in the store's inventory or virtual inventory can be added. NIF parts cannot be added.
Enter a 'Line' and 'P/N'. 'Description 1' and 'Description 2' display for the part.
The display grid columns display: 'Supplier' (code), 'Sup Part Cost' (supplier part cost), 'Sup Core Cost' (supplier core cost), and 'Use Best Price' with a value of 'Yes' or 'No'.
Note: The 'USE BEST PRICE' flag must be checked to use the option to order by Best Price.
- With a part in focus, click the ‘Add’ button and the ‘Supplier Part Cost’ pop-up opens.
- Enter a ‘Supplier’ code or select one by clicking the ‘Supplier’ button.
- Enter the cost of the part in the ‘Sup Part Cost’ field and any core cost in the ‘Sup Core Cost’ if purchased from the supplier.
- The ‘Use Best Price’ field defaults to checked and can be unchecked as needed.
- Click the ‘OK’ button to add the value to the grid and to close the pop-up.
- Repeat for each supplier.
- With a part in focus, highlight a supplier row in the grid and click the ‘Edit’ button and the ‘Supplier Part Cost’ pop-up opens.
- Edit the part/core cost as needed and/or check/uncheck the 'Use Best Price' flag.
With a part in focus:
- Highlight a supplier row in the grid and click the 'Delete' button. The system prompts to delete the supplier. Answer 'YES' and the highlighted supplier row is removed from the grid.
- Click the 'Clear' button and the system prompts to clear all suppliers from the grid. Answer 'YES' and all supplier rows are deleted from the grid.
When suppliers are added, edited, deleted, or cleared, click the 'Save' button to save the changes.
View Supplier Part Costs Per Part
Click the 'SUPPLIER PART COSTS' button on the ORDER-COST screen to open a pop-up displaying the part/core cost used for Best Price ordering across all vendors the part is ordered from.
Click the 'SUPPLIER PART COSTS' button to open a pop-up displaying the part/core cost and best price accross all vendors the current part may be purchased from.
If the 'Best Price' flag is set to 'Yes', then that supplier part cost is used in the comparison logic performed during order creation when the option 'Best Price' is selected.
Creating Best Price Orders
Reporting Supplier Part Costs
The ‘SUPPLIER PART COSTS’ ‘Quick Reporting Options’ on the VENDOR LINE REPORTS screen is used to report all parts set up with one or all Supplier Part Costs, and for multi-store, for one or more stores.
DFIU
The 'Supplier Part Cost' and 'Delete Supplier Part Cost' records are included in DFIU. Note: Refer to the DFIU User Guide for more information.
Audit Report
Audit records for updates processed on the SUPPLIER PART COSTS screen are tracked to the AUDIT REPORT.