Sold products

Prerequisite

Mandatory fields in the template

For ITMS import table, there are two mandatory field types:

Mandatory fields:

• Product category: TCLCOD table product ITMMASTER,
• Product code: ITMREF table product ITMMASTER,
• Product description: DES1AXX table product ITMMASTER.

Potential mandatory fields if the product category associated with the imported product does not define them:

• Stock unit: STU table product ITMMASTER,
• Sales unit: SAU table product ITMMASTER
• SAL-STK coefficient: SAUSTUCOE table product ITMMASTER if STU<>SAU otherwise set to 1,
• Account code: ACCCOD table product ITMMASTER,
• Tax level: VACITM table product ITMMASTER.

The units depend on the product category. If the product is bought:

• the product purchase unit and the PUR-STK coefficient must be specified,
• or the product purchase unit must be specified within the product category.

Error messages

The only error messages are the generic ones.

Tables used

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