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.

Fullscreen_1_22_25__2_24 PM.jpg

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
    • The extracted item_id is recorded as the project_uid for the created BOM list, ensuring consistency and traceability.
  • 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

Screenshot_1_13_25__10_47 AM.jpg

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.

Screenshot_1_13_25__10_36 AM.jpg

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. 

Fullscreen_1_21_25__4_20 PM.jpg

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.

Fullscreen_1_13_25__10_33 AM.jpg

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.

Screenshot_1_13_25__10_35 AM.jpg

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.

Fullscreen_1_22_25__12_00 PM.jpg

Internal Assignee Added to Quote History Report

The detail of "Assignee" has been added as a new column in the Quote History Report.

Cursor.jpg

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".

Cursor_and_Project___Bom___Supplyframe_DSI.jpg