Costs

Cost Import Template

The Cost Import Template is an Excel spreadsheet with columns for each cost attribute that imports multiple costs in one operation.

The template may be used to create new costs or to update existing costs.
The Cost Analyst role in ENOVIA is required to import costs.

When updating existing costs:

Create state costs are simply changed and previous values are overwritten.
Active state costs are retained and a new revision is created for the new imported cost information.

To import costs into ENOVIA, the current Cost Import Template is required.

To ensure you are working with the latest version, download the template from ENOVIA each time you import costs.

Once the data is entered into the template, save the file under a new name and see Cost Import Procedure to perform the import.

Cost Import Template in ENOVIA

As the ENOVIA functionality evolves, the template is updated with fields for new attributes, etc.

Be sure to use the latest, fully functional version of the template, which is always available in ENOVIA.

To locate and download the latest version:

You may click this link, Cost Import Template, to open ENOVIA in a new browser window (log in may be required) and directly access the document with the template.
In ENOVIA you may search for "Cost Import Template" in the Name or Title field.
The various import templates used in ENOVIA are in a Collection in the Collaboration and Approvals App > My Tools > Import Templates. . . .

Cost Import Template Data

The column headers of the Cost Import Template are colored coded:

Red are Required attributes.
Green are Optional attributes.

In the spreadsheet, hover the mouse pointer over a column header for a description of the attribute.

See Create a Part Cost for more information about cost attributes.

Cost Attribute fields	Description
Part Name	All costs: Required. Must precisely match an existing Part Name. Cannot be modified using Mass Edit on the Import Mass Part Cost form.
Part Revision	All costs: Required. Must precisely match an existing Part Revision. Cannot be modified using Mass Edit on the Import Mass Part Cost form.
Part Type	All costs: Required. Must precisely match an existing Part Type. Cannot be modified using Mass Edit on the Import Mass Part Cost form.
Cost Provider	All costs: Required. Must precisely match an existing Company. Enter the Company providing the cost regardless of who is creating it in ENOVIA.
Location / Subsupplier	All costs: Optional. If populated, must precisely match an existing Location of the Cost Provider designated as an Active Costing Site or must precisely match an existing Company understood to be a subsupplier to the Cost Provider for the given part. Cost Family is a special type of Location used to identify costs from a Cost Provider for a particular project.
Location Type	All costs: Required. Location Type options: Default (Create form default) Alternate A part must have one and only one Default cost. Multiple Aternate costs can be created.
Cost Value Type	All costs: Required. Cost Value Type options: Target Estimate (Create form default) Quoted Working Actual
State	All costs: Required. State options: Create (Create form default) Active Cannot be modified using Mass Edit on the Import Mass Part Cost form.
Production Make Buy Code	All costs: Required. PMBC options: Make (Create form default) Buy
Include Children In Rollup	All costs: Required. ICIR options: Yes No (Create form default) If Production Make Buy Code = Buy, then ICIR must equal No.
Item Quoted Material Cost	All costs: Optional.
Item Freight Cost	All costs: Optional.
Item Labor Hours	All costs: Optional.
Item Labor Cost	All costs: Optional.
Item Variable Cost	All costs: Optional.
Item Fixed Cost	All costs: Optional.
Item Adjusted Cost	All costs: Optional.
Adjusted Cost Description	All costs: Optional.
MVA	All costs: Optional.
VMI	All costs: Optional.
Variance	All costs: Optional.
Overhead	All costs: Optional.
SGA	All costs: Optional.
Taxes and Profit	All costs: Optional.
Labor	All costs: Optional.
3PL	All costs: Optional.
Transportation	All costs: Optional.
Insurance	All costs: Optional.
Management Fees	All costs: Optional.