DSI Release 2.3.0 - April 15, 2024
BOM Insight
"Best Price at quantity" New Price Option for WP and SP
There is a new cost option for the SP (Specific Price) and WP (Web Price) sources. This option allows you to price items based on the best available price, while at the same time taking into account the requested quantity that falls within the distributor’s correct quantity break limit.
This cost option will work with the Req. Manufacturer rules. For WP, it will also consider your preferences settings for preferred supplier choices.
This new option is available under Cost Prioritization for System Settings, as well as when working within a BOM. Your other cost options in a BOM have remained the same.
Req. Manufacturer Rule with IPN/CPN Cost Prioritization
There is a new rule regarding the use of Requested Manufacturer when pricing a BOM by IPN/CPN and utilizing CP, PO, or QH sources. If there are two MPNs with the same IPNs, then the Req. Manufacturers will not be utilized in the pricing selection. Regardless if the setting for “Lowest Price" (across all) is selected or “Requested Manufacturer Settings” is checked for IPN/CPN, Supplyframe will ignore the Req. Manufacturer if it exists on the BOM line.
This rule is only for IPN/CPN pricing when based on CP, PO, or QH. It does not affect WP and SP, since these price sources are based on MPN matching.
Quoting
Filter for “Recommended” MPNs
There is a new option to filter all the line items that have a recommendation from a supplier. This filter will display the line items that have recommendations for either MPN or manufacturer fields, which will make it easier for you to see all the recommendations at one glance.
Search Under the Suppliers Tab
Functionality has been added to search for suppliers after they submit their line items. This helps you to look for specific suppliers and their progress on the RFQs. This search supplier option is located on the “Supplier” tab on an RFQ's “Responses” page.
When you enter a supplier's name in the search box, then matching supplier rows are displayed in the resulting set of line items. This search is not case-sensitive.
Reference Tables / Part Master
PO File Upload Validation Update
The PO_Number uniqueness validation logic has been enhanced during a PO file upload. This enhancement ensures that entries with the same CPN but different MPNs are treated as unique. With this enhancement, the MPN and CPN/IPN are both taken into account during a PO_Number validation, alongside the other fields, to determine the uniqueness of a PO entry.
Updated Validation Criteria
To ensure the uniqueness of each PO entry, the system will now validate the following fields together:
- Manufacturer Part Number (MPN)
- Customer Part Number (CPN/IPN)
- PO Date
- Supplier
- Quantity
Part Master - New Column
A new column of "Created By" has been added to the Part Master table, displaying the name of the member who added each item. This enhancement allows for greater visibility and accountability within your team's workflow. The "Created By" column has been strategically placed before the "Created Date" column for easy visibility.
Understanding who added an item to the Part Master can be crucial for several reasons:
- Enhanced Accountability: Knowing who added an item can help in understanding decision-making processes and in tracking changes.
- Consistency Across Tables: As the "Created By" column is already present in other tables (CP/PO/Mapping Table, etc.), this enhancement to Part Master ensures a uniform experience.
- Improved Usability: This additional data point can be valuable for audits, historical data analysis, and day-to-day operations.
For items added to Part Master before this enhancement, the "Created By" field will show an empty state to indicate that the data was not captured at the time of creation.
API Updates
To support this enhancement, the following API endpoints have been updated to include the new “Created By” field in the response:
- GET {{base_url}}/api/part-master/items/{id}: List a single Part Master Item.
- GET {{base_url}}/api/part-master/items: List all Part Master Items available for the
customer. - POST {{base_url}}/api/part-master/items: Create a Part Master Item.
- PUT {{base_url}}/api/part-master/items/{id}: Update an existing Part Master Item.
- DEL {{base_url}}/api/part-master/items/{id}: Delete a Part Master Item.
System Enhancements
Sticky Headers/Columns
Sticky headers and columns have been added in tables throughout Supplyframe. This functionality enhances your experience by providing persistent visibility of important information, even as you scroll through lengthy BOMs, CPs, POs and other tables with lots of data.
Sticky columns will dynamically adjust so they don’t cover more than 50% of the screen. The first column with checkboxes to select specific items will always be sticky. Display Views in RFQ don’t have sticky columns.
Below are the main areas in Supplyframe that have sticky headers implemented and a corresponding list of sticky columns:
BOM Insight:
- Multilevel BOM - “Parent PN”, “Level” & IPN”
- Flat BOM - “IPN”, “MPN”
- Parametric Search - Category icon, “Part Number” and “Doc”
Quoting
- Line Items
- Responses
- Assignments
- Review & Implement - “Err, IPN & Plant”
- Template Columns: Part Categories and Demand Templates
- Sticky columns - Letter + “Name”
Demand Management
- Sticky columns - “Rule”, “IPN” and “MPN”
Suppliers
- Sticky columns - Supplier ID, Parent ID and Name
Reference Tables
- CP List- Sticky columns: “CPN”, “MPN” and “Manufacturer” (order in CP was adjusted so these are the first three columns)
- PO List- Sticky columns: “PO Number”, “CPN”, “MPN” (order in PO was adjusted so these are the first three columns)
- AML List- Sticky columns: CPN, Manufacturer
- AVL List- Sticky columns: CPN, Manufacturer
- Sourcing Level List- Sticky columns: Category
- Internal Assignment List- Sticky columns: Assignee Email
Reports
- Quote History - Sticky columns: first three RFQ #, RFQ Name and CPN
- Users & Activity - Sticky column: User Name
- Award Implementation - Sticky column: Category
- Savings - Sticky column: Category
- Historic TAM & SAM - Sticky column: Year and Supplier
- Demand Spend Comparison - Sticky column: IPN and Plant
- Spend - Sticky column: Category
- RFQ - BOM Cost Review Sticky column (first three): Level, Parent, IPN
Supplier Portal
- RFQ Responses Sticky columns: Comments, Doc, IPN, MPN and Manufacturer
Reports
Quote History - Accounting for Items Priced but not Submitted
This Quote History Report enhancement will include items that have a price (P1, P2...P6), whether with a status of Submitted or Not-Submitted. A column of “Response” is now added before the existing “Response Submitted Date” column. This will list the items' status of Submitted or Not Submitted from the supplier portal.
The column “Response Submitted Date” has been renamed to “Response Date”, as it will print the date the price item was updated from your side or supplier portal.