DSI Release 2.12 - December 24, 2024
BOM Insight
Line Level BOM Comparison Export
You can now export the BOM Line-Level Comparison with the BOM Comparison Report as an Excel file for further analysis or sharing with stakeholders.
Export Format
The Excel file includes 4 tabs: Summary, Line Level Comparison, BOM Intelligence Comparison and Comparison Cost Breakdown. The export is based on the UI view. For Line Level Comparison, data for CPN, MPN, Manufacturer, and Supplier are always included, regardless if one is not checked for the grouping. Sorting is based on the first checked item in the group (e.g., IPN, MPN, Manufacturer).
PCN Alerts
On top of the previously added Life Cycle Alert, there are now alerts for "End-of-Life" notices and all other product change notifications (PCNs).
All 3 alerts are separated out from Stock Alerts and have their own Alert Frequency and Alert expiration date.
You can now be choose to be notified if one of the parts in your BOMs incurs LC/EOL/PCN changes. This is available based on viewership roles. If you can see the BOM, then you can also view alerts information.
- You will set those by opening Alert Settings.
- Navigate to PCN Tab.
- Then select the Name, Frequency and toggle the desired alert on.
- All 3 alerts work with items selected inside BOM. You can set an alert for all items in BOM.
- You will receive email alert whenever any product(s) incurred selected alert change
Quantity Validation Update
We have enhanced the quantity validation logic within BOM Insight. This update increases the maximum allowable quantity to 200,000,000,000,000 (2e14), thereby ensuring more flexibility in managing large-scale inventory data.
Updated Error Message: The error message now reflects the new maximum quantity limit, guiding you to input quantities less than 2e14.
Quoting
Automatic RFQ Reminder to Supplier
The new feature is designed to streamline communication and improve supplier engagement during the RFQ process. It provides you with enhanced control over automated email notifications to suppliers, ensuring timely submissions and smoother supply chain operations.
- Customizable Reminder in RFQ “Detailsˮ Section
- Timing: Set reminders to be sent a specific number of days before the RFQ supplier due date.
- Optionally, continue reminders for a specified number of days after the due date if the RFQ is incomplete.
- Default: "Do not send" for both pre- and post-due date reminders.
- Flexible Frequency Options
- Timing: Set reminders to be sent a specific number of days before the RFQ supplier due date.
- Automated Email Notifications
- Sent to all supplier contacts linked to an RFQ who have not marked their submission as complete.
- Notifications include:
- RFQ number
- RFQ name
- Due date
- Direct link to view the RFQ
- Email Template
- Subject Line: RFQ [RFQ_NUMBER] for [CUSTOMER_NAME] is due on [SUPPLIER_SPECIFIC_DUE_DATE].
- Body:
Hello,
This message is a reminder that [CUSTOMER_NAME]is awaiting your response for RFQ [RFQ_NUMBER] - [RFQ_NAME] ([link to RFQ)] due on [SUPPLIER_SPECIFIC_DUE_DATE].
RFQ Number: [RFQ_NUMBER]
RFQ Name: [RFQ_NAME]
Created By: [RFQ_CREATOR]
RFQ Due By: [MM/DD/YYYY]
If you are not the correct contact person for [CUSTOMER_NAME], please notify [RFQ_CREATOR_NAME].
VIEW RFQ (button)
API
Password Validation for API User Updates
This new feature allows password validation when updating the API user password in System Settings to enhance security and improve your experience.
- Password Requirements
- Passwords must be at least 8 characters long.
- They must include at least 3 of the following character types:
- Lowercase letters (a-z)
- Uppercase letters (A-Z)
- Numbers (0-9)
- Special characters (!#$%^&*)
- Enhanced User Experience
- A pop-up now displays password requirements when you click into the password field.
- The pop-up dynamically updates as each requirement is satisfied, providing real-time feedback.
- The pop-up disappears once all requirements are met.
This feature ensures better security compliance while making it easier for you to create valid passwords.
Additional Pricing Fields in RFQ Items Route
We have enhanced the RFQ Items API endpoints to include additional price-related and supplier related fields. This update aims to provide you with more comprehensive pricing information, enabling better decision-making and analysis.
New Fields Added:
- Converted Price: Displays the price converted into a standard currency for easier comparison.
- Lowest Current Cost: Shows the lowest cost currently available for the item.
- Lowest Current Cost Savings: Indicates the savings achieved compared to previous costs.
- Lowest Current Cost Savings %: Represents the percentage of savings compared to previous costs.
Endpoints Affected:
- GET /api/rfq/:rfq_id/items
- GET /api/rfq/:rfq_id/items/:item_id
Response Definition Updates:
The response JSON structure for both endpoints now includes these new fields. The data types are consistent with existing pricing fields—prices are in decimal format, and savings percentages are appropriately formatted.
Supplier Data in RFQ Endpoint
The RFQ API endpoints were updated by introducing the "Supplierˮ field as an array which significantly improves supplier tracking and management. This feature allows you to effectively monitor supplier commitments and timelines, providing greater visibility into the RFQ process.
Supplier Object Enhancement:
- Field Name: suppliers
- Data Type: Array of Supplier Objects
- Description: Each RFQ can have multiple suppliers. The suppliers array includes objects representing each supplier's details, including due dates and statuses.
Supplier Object Structure:
- supplier_id: The unique ID of the supplier (Integer)
- supplier_name: The name of the supplier (String)
- supplier_due_date: The date by which the supplier is expected to fulfill the RFQ (Date, GMT)
- supplier_status: The RFQ progress on the customer side, with possible values such as Notified, Opened, Responded, Completed, Accepted.
API Response Changes:
Both GET /api/rfq/{id} and GET /api/rfq endpoints now include a new field suppliers in their responses.
Improvements
Account for LT in Risk index based on source (if weeks or days)
In CP and PO, the Lead Time is represented in "Days". In QH, SP, and WP, the Lead Time is represented as Weeks. Through this enhancement, Supplyframe now factors in the lead time parameter based on the price source during the evaluation process.
We have also added an option for you to check if the parameter should be evaluated based on the Estimated Lead Time. The estimated lead time will be calculated from all other sources, whenever the Lead Time does not exist. Supplyframe uses the "estimate" icon to identify in the Risk Index side panel if the Lead Time is an estimate.
Filters at the top in BOM Intelligence Charts
Filtering has been moved at the top of the chart. Also, they are available now for Country of Origin and Supplier Lead Times. The filtering input box will show only if there are more than 10 results.
SP & WP Channel Stock with Manufacturer
We have adjusted the channel stock calculation based on the MPN & Manufacturer combination. We are accounting for manufacturer aliases to ensure we include all relevant names, both within the BOM and in Part Intelligence data.
Calculation for Orderable Qty in BOM
This enhancement aligns the calculation of Orderable Quantity within BOM Insight, for the purpose of excess cost calculation, to match the methodology used in the RFQ process.
Calculation going forward is:
- When Req. Qty is <=MIN, Orderable Qty = Min (no change)
- When Req. Qty is > MIN , Orderable Qty = (Req Qty / Mult) roundup * Mult
Updated from:- When Req. Qty is > MIN and < Min+Mult, Orderable Qty = Min+Mult
- When Req. Qty is > MIN and > Min+Mult, Orderable Qty = Min+ (Mult*n), where n will increment to minimally satisfy Orderable Qty =or > Req. Qty.
This improvement accounts for the industry practice of not considering the Minimum quantity for Excess Cost calculations within an RFQ, once the Requested Quantity exceeds the Minimum. In such cases, the Orderable Quantity is calculated solely based on the Multiplier and rounded to the nearest applicable quantity.
Fixed columns in modal for CP, PO, and QH
Columns for the Contract Price, Purchase History and Quote History modal in BOM Insight have been fixed, so that you donʼt lose context of the important identifiers for the line item, as you scroll to the right.
- PN/CPN, MPN, Manufacturer and Supplier
Adjusting Template Permissions
- If a field is not viewable, then it is set as not editable for a System, Demand and Part Category template.
- If data type for a field is set as integer/numeric and if that field is set for accepted list values, then it will not not accept string values.