Overview
YAKTA required the Integration of SolidWork with Goldfinch to import and create Item formulas as per the design in SolidWorks. The Purpose of this integration is to have an updated Bill of Materials which will be used to process Production Work Orders.
Integration Mappings
Object Name: GFCON__Import_Item_Formula__c | |||
SolidWork Field Name | GF Field Name | GF API | GF Field Type / String Length |
Level | Level | Level__c | Text(255) |
File Name | File Name | File_Name__c | Text(255) |
????? | Parent | GFCON__Parent__c | Text(80) |
Part Number | Component | GFCON__Component__c | Text(80) |
Revision | Revision | Revision__c | Text(255) |
Qty. | Quantity Per | GFCON__Quantity_Per__c | Text(80) |
State | State | State__c | Picklist |
Description | Description | Description__c | Text Area(255) |
Category | Category | Category__c | Text(255) |
Final Assembly Bool | Final Assembly Bool | Final_Assembly_Bool__c | Picklist |
Finish | Finish | Finish__c | Text(255) |
Material Size | Material Size | Material_Size__c | Text(255) |
Material | Material | Material__c | Text(255) |
Weight | Weight | Weight__c | Number(15, 3) |
Configuration | Configuration | Configuration__c | Text(255) |
???? | Link to Operation No. | GFCON__Link_to_Operation_No__c | Text(80) |
???? | Unit of Measure | GFCON__Unit_of_Measure__c | Text(80) |
Please refer to the sample data that will feed in Import Item Table
Sample Data
Processing Item Formulas
Item Formulas are the components that are used to create the parent item.
One Item Formula is defined for each component used to create a parent item. You can create Item Formulas directly from the parent item or from the Formula Version.
At a minimum, you need to enter Component, Unit of Measure, and Per for each component.
Formula Unit of Measure Consideration
You can define a Unit of Measure for your formula. For example, you may have a manufactured item that comes in both EACH and CASE.
The Formula for a Standard Manufactured Item is based on the Base Unit of Measure for the Item. It is recommended to consider making your Base Unit of Measure for Manufactured Finished Goods as the Unit of Measure that you sell most often, such as Case or Bag. This helps you to easily define the packaging used for each formula. It also helps with your forecasting and supply planning.