DSI Release 2.13.0 - January 21, 2025
General
Korean and Japanese languages Now Available
New languages are available in Supplyframe for Korean and Japanese.
BOM Insight
TcPCM - BOM Integration with External ID Mapping
The latest update introduces enhanced BOM processing capabilities for TcPCM. This feature enables automated mapping of external IDs and improved traceability by extracting key identifiers from BOM file names. With intelligent file name recognition and seamless external ID mapping, you can efficiently manage and integrate enriched BOM data into your workflows.
Key Features
-
File Name Pattern Recognition and Database Mapping
- The system now recognizes BOM files with the following naming convention, tcpcm_<item_id>_<part_name>.xlsx and will extract the <item_id> and map it to the bom_uid field in the database:
- For Example:
File name used : tcpcm_72312321_part.xlsx
item_id: 72312321
item_id is mapped to project_uid
GET /api/BOM-insight/uid/72312321
- For Example:
- The extracted item_id is recorded as the project_uid for the created BOM list, ensuring consistency and traceability.
- The system now recognizes BOM files with the following naming convention, tcpcm_<item_id>_<part_name>.xlsx and will extract the <item_id> and map it to the bom_uid field in the database:
-
Automated External ID Mapping
- When a BOM file with a specific naming convention (tcpcm_<item_id>_<part_name>.xlsx) is uploaded, you can now map an additional 'external_id' column, and the data will be stored for each BOM line item.
- Mapped external_id should be available in the api, while fetching BOM line items
GET /api/BOM-insight/39845/items
- Mapped external_id should be available in the api, while fetching BOM line items
- When a BOM file with a specific naming convention (tcpcm_<item_id>_<part_name>.xlsx) is uploaded, you can now map an additional 'external_id' column, and the data will be stored for each BOM line item.
Extended Price and Excess Cost Calculations for Qty 2 and Beyond
This update introduces improved handling of Extended Price and Excess Cost calculations for BOM line items starting from "Qty 2" and beyond, while addressing specific scenarios for better data consistency.
Handling Zero Quantities
If Qty 2 (or subsequent quantities) is changed to 0, then Supplyframe will now display the Extended Price and Excess Cost as 0.0000 instead of leaving it blank, ensuring clarity and consistency.
Quoting
Identify IPN-Plant Combos that Remain Not Awarded in an RFQ
There is a new filter of ”Not Awarded Group”, which will display any lines not awarded based on its IPN, Plant and Subcontractor group. A line item belonging to the same group would have the same IPN, Plant and Subcontractor. If any of the values are different then that line would be considered
to have a separate group.
When a line item has the same IPN, Plant and Subcontractor for a group, yet one of the lines in that group is not awarded, then it is still considered as awarded per the group. Therefore, the unawarded lines will not appear in the ”Not Awarded Group” filter when in they're in an awarded grouping.
Whereas if the line item has the same IPN, but different a Plant or Subcontractor, then the lines are considered to have separate groups. If any of the lines are not awarded, then that line will appear in the ”Not Awarded Group” filter.
In below screenshot, IPN 011-2533-533, has three lines with the same IPN, Plant and Subcontractor. Only one of them is awarded, but since they belong to the same group, the other lines will not appear when the ”Not Awarded Group” filter is applied.
Whereas IPN 011-7443-353, has three lines, but each line has different Plant and Subcontractor, so they are considered to be separate groups. Since the line with MPN GCM216R72A103KA37D is not awarded, this line will appear in ”Not Awarded Group” filter.
Uploading Status in RFQ on Responses Page
Currently, you can edit a Status in an RFQ on the Responses tab within the UI. This new functionality enables you to make changes via upload as well. On the exported Excel, you will be able to select the status from the dropdown to one of the following values: None, NG (Negotiated), or FO (Final Offer).
Update Internal Assignee in Bulk via Group Edit
This new functionality provides you the ability to manually assign the Internal Assignee in bulk. There is a new option in the Group Edit dropdown of “Internal Assignment Manually”, which will let you select multiple lines and assign an assignee to them.
Internal Assignee Added to Quote History Report
The detail of "Assignee" has been added as a new column in the Quote History Report.
Improvements
Ability to Add Requested Manufacturer When Adding a Part
When adding a new part to the BOM, this release provides the ability to now add the "Requested Manufacturer".