DSI Release 2.11.0 - November 25, 2024
BOM Insight
Self-Serve Specific Price with Supplier Connect
Supplier Connect (SC) is a new price lookup functionality built right into Supplyframe. You will be able to automatically pull your contract specific pricing (as available) directly from major distributors' API into your supplier pricing details.
This new functionality replaces the existing API used to pull prices. Supplier Connect is developed on existing API connections that major distributors have begun offering. This is a self-service tool. All you need to do is to enter your supplier pricing credentials to authorize Supplyframe to pull prices on your behalf.
Supplier Connect is accessible for admins and account owners. These connections can be set up in System Settings → Supplier Connect.
More information on how to set up the different Supplier Connect credentials can be found in their respective articles in the knowledge base.
After everything is set up, then prices and data are retrieved as available in BOM insight with all of the details in the Specific Pricing details table.
All existing connections through the API are automatically transitioned by Supplyframe on release. Also, to assist with any new or additional Supplier Connect API connections, help documents are created for every Supplier API that is currently supported by Supplier Connect.
There may be supplier specific rate limits based on vendor agreements. Please refer to your contracted rate limits with each vendor for details.
Part Master: Multiple File Uploads
This enhancement streamlines document management by enabling you to select and upload multiple attachments for an Internal Part Number (IPN) in a single action. Additionally, Supplyframe improved the document deletion functionality, along with maintaining an audit trail for all document changes.
1. Multiple File Uploads
- File Manager Modal: You can now select multiple files simultaneously using the file manager modal and click on the “Openˮ button to upload them.
- Supported Formats: Various file formats are supported, including PDFs, images, spreadsheets, and CAD files.
- File Size Limit: The maximum file size for uploads is 10MB per file, with a total limit of 100MB per upload session.
- Multiple Documents: You can upload up to 10 documents per part in a single session.
2. Deletion Functionality
- Delete Documents: You can delete individual documents attached to parts directly from the Upload Documents modal.
3. Audit Trail
- An audit trail is maintained for all multiple document uploads and deletions, including the date of upload and any deletions made.
4. Error Handling
- If you attempt to upload more than 10 files or exceeds the file size limit, then you will receive an error message:
- For single file size limit: “The file exceeds the maximum size limit set by the application."
- For multiple files: “The total number of files exceeds the maximum size limit set by the application.ˮ
Quoting
Validation Behavior on Responses Page
The validation behavior has been refined on the Responses page and synced with other modules to make it more intuitive. There will be an error message guiding you to correct the data entry via manual and file upload method.
Also, a tooltip will be provided to the field (system/user defined) if the field has any min/max values defined. If you enter an incorrect value, then the cell is highlighted and a tooltip is displayed about the error.
API
OAuth 2.0
OAuth 2.0 is an industry-standard authorization protocol that enhances security and flexibility by allowing third-party applications to access resources on behalf of users without sharing their credentials. This is a requirement for TcPCM integration.
BOM Line Item - Add external_id Parameter
There is a new optional parameter, external_id, to the existing BOM Insight Items API. This enhancement allows you to integrate and manage BOM items more effectively with external systems by using an additional identifier.
The external_id will serve as a unique reference for BOM items, enabling better tracking and filtering capabilities when integrating with third-party systems.
Endpoints Affected
The following API endpoints have been updated to support the new external_id parameter:
- GET /api/BOM-insight/{bom_id}/items/{item_id}: Retrieve a single BOM item.
- GET /api/BOM-insight/{bom_id}/items: Retrieve a list of all BOM items.
BOM Insight Search by UID Endpoint
There is a new API feature that allows you to search for BOMs in Supplyframe using your internal UID. This enhancement is designed to improve integration with external systems that store BOMs using their own BOM internal ID.
The UID will be stored in Supplyframe's database within the existing UID fields in the lists table, and this new API route will allow you to query BOMs based on internal IDs.
New Endpoint
- Method: GET
- Route: /api/BOM-insight/uid/:project_uid
This endpoint enables you to retrieve BOMs based on an internal UID.
Response Details
The response from this new endpoint will return the same fields as the existing /api/BOM-insight route, with the addition of a new field, project_uid, which represents the UID used in the request. This helps you track which UID was used for each result.
Key Considerations
- Multiple Results: Since the UID field in the Supplyframe database is not unique, this API may return multiple results. You should expect an array of BOMs when querying by UID.
- Customer-Specific Data: The API will consider the customer_id when fetching data, ensuring that you only retrieve results relevant to your specific customer account.
Key Benefits
- Enhanced Search Capabilities: You can now search for BOMs using your internal UID, making it easier to integrate and manage data between systems.
- Improved Data Access: This feature allows for more flexible and efficient retrieval of BOMs, especially for managing large datasets across multiple systems.
Removal of Unnecessary CO2 Fields from BOM Insight Items API
Supplyframe is streamlining the data returned by the BOM Insight Items API by removing unnecessary CO2-related fields. This update focuses on simplifying the API responses and retaining only essential information, making it easier for you to manage and interpret BOM data.
Affected API Endpoints
The following endpoints will be updated to reflect these changes:
- GET /api/BOM-insight/:bomId/items: Retrieve a list of all BOM items.
- GET /api/BOM-insight/:bomId/items/:itemId: Retrieve a single BOM item.
Fields Removed
- Average Weight (mg): This field is no longer relevant and has been removed from the response.
- kg CO2e/kg: This field has been removed as it is no longer required.
Field Retained
- CO2e (mg): This field will remain in the response as it provides essential information about the carbon footprint of the BOM item.
Addition of price_currency and Excess Cost Fields to BOM Insight Items Endpoint
We are introducing two key enhancements to the BOM Insight Items API:
- excess_cost Fields for Quantity Breaks (Qty2 - Qty6): You can now retrieve excess cost data for all six quantity breaks, providing more granular cost information for better decision-making.
- price_currency Field: A new field has been added to specify the currency of the BOM item price using ISO 4217 standard three-letter currency codes (e.g., USD for US Dollar, EUR for Euro). This update improves financial analysis and reporting for users across different regions.
New Fields Added
- excess_cost2: Excess cost for Qty2
- excess_cost3: Excess cost for Qty3
- excess_cost4: Excess cost for Qty4
- excess_cost5: Excess cost for Qty5
- excess_cost6: Excess cost for Qty6
- price_currency: The currency of the price of the BOM item, represented by ISO 4217 codes (e.g., USD, EUR).
Affected API Endpoints
The following API endpoints have been updated to include these new fields:
- GET /api/BOM-insight/{bom_id}/items/{item_id}: Retrieve a single BOM item.
- GET /api/BOM-insight/{bom_id}/items: Retrieve a list of all BOM items.
Changes to API Responses
The response structure for the affected endpoints will now include the new fields.
Improvements
Increase Supplier Tags limit
Based on feedback, the majority of suppliers have 6-8 tags and some up to 10 tags. Therefore, the tags per Supplier Qty has been increased to 10 and the total tags to 1000.
Ability to export 10K RFQs as XLSX in Supplier Portal
Within Supplier Portal, you can now export up to 10K files as XLSX.
Output of .csv vs .xls export based on exported items vs entire RFQ items
The export of .csv vs .xls has been adjusted to work with filters/views applied when exporting.
Round to 5 decimal places for Spend & Savings
As low prices and quantities Spend and Savings can result in zeros, calculations were adjusted to round up to decimals on the Responses and Review & Implement tabs.
The columns below have been adjusted at the line level. Aggregations of these at the RFQ level or Supplier level will still be displayed in two decimal places.
- Ref. AUC
- Ref. A2A Savings %
- Ref. AUC Savings %
- A2A Savings %
- AUC Savings %
- Ref. A2A Target Savings %
- Ref. AUC Target Savings %
- Ref. A2A Spend
- Ref. A2A Savings
- Ref. AUC Spend
- Ref. AUC Savings
- Ref. Actual Spend
- Actual Spend
- A2A Savings
- A2A Spend
- Ref. A2A Target Savings
- AUC Spend
- AUC Savings
- AUC YRLY SAVINGS
- Ref. AUC Target Savings