Material Type - DTW - oItems

[Former Member]

The <Material Type> field does not exists in template oItems(Items.csv) on DTW...

How can i import this field?

[former_member186095]

The MaterialType Property applicable for SAP Business One 2004.2B (country-specific for Brazil only).

it is valid value of BoMaterialTypes that determines current material state from Raw Material to Finished Goods.

are you an end user that using the cluster B ?

Rgds,

[Former Member]

Yes, i use 2005 B...I work in Brazil...any idea?

Thanks for reply

[former_member186095]

I suggest you to disregard the material type. I have checked here by using this query:

select MatType, * from oitm

you will find '1' in that column which it means that it is finished goods.

The decision to exclude this field in the DTW solely caused by its irrelevant use and standard definition and or SBO business rule. There have been item group and Purchase Item [Yes/No], Sales Item [Yes/No], and 2 others fields that will be more useful rather that mattype. you could use that or use UDF to replace the field matype. add UDF in the master data and then add U_Mattype near the latest object/field column of oitm excel template

Rgds,