Import/export template >  Module Common Data >  Import/export template ITC (Standard Costs)  

Display all Hide all

This information is used to import the provisional costs. It is particularly adapted to the recovery of the costs for purchased products before the launch of the calculations in a BOM.

This function is only available in creation.

 

Prerequisite

Mandatory fields in the template

The costs are imported with the detail of the cost natures.

To import the costs, it is necessary to set up two identifiers, one for the header table ITMCOST, one for the detail table ITCNAT.

The different cost components can be entered as well as the fixed part. (MACCST(i) machine component where the fixed part FXDMACCST(i)

ITC header field:

  site code

  product code

  cost type (1 :standard, 2 :revised 3 :budget, 4 :simulated)

  reference year

  BOM alternative

ICN lines field

  nature code

  amount

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

"Record inexistent Product XXXXX "

"Record inexistent Site XXX"

"Record inexistent Product-site XXXXX YYY "

"Record inexistent Nature XXX"

"You have no rights for this site ..."

The fiscal year in process corresponds to the year number 9999 "

"The total for the cost natures is different to the overheads total "

"Record exists already key … "

"Record locked key … "

"The corresponding standard cost could not be created key ..."

"Creation key …  Natures N1,N2,N3…"

 

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

ECCVAL [EVL]

Versions

FISCALYEAR [FIY]

Fiscal years

ITCMAT [ICC]

Temporary products - cost

ITCNAT [ICN]

Nature detail - costs

ITCWST [IWC]

Temporary products - cost

ITMCATEG [ITG]

Product category

ITMCOST [ITC]

Products-costs

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

OVENAT [ONA]

Overhead category

TABCOSTMET [TCM]

Valuation methods