Stock: Can I import the Item, Item UOM’s UDF (User Defined Field) contents through “import from excel”?

From AutoCount Resource Center
Jump to navigation Jump to search

Question : When I import Stock Item from excel, can I import Item’s UDF and Item UOM’s UDF as well?


Answer :

Yes. You may refer to the following for the header name to be used in Excel template for UDF.


Import Stock Item

Stock Item UDF : UDF_NAME
Eg : UDF_DESC3

Stock Item UOM UDF : UDF_UOM_NAME
Eg : UDF_UOM_MARGIN

Import item udf1.png


Import item udf2.png


Item’s UDF contents and Item UOM’s UDF contents successful import and updated.


Import item udf3.png


Here are header name for import Cash Book’s UDF and Cash Book Detail’s UDF

Import G/L Cash Book

Cash Book UDF : UDF_NAME
Eg : UDF_REF

Cash Book Detail UDF : UDF_DETAIL_NAME
Eg : UDF_DETAIL_REMARK

Import item udf4.png


Import item udf5.jpg


Cash Book’s UDF contents and Cash Book Detail’s UDF contents successful import and updated

Import item udf6.png

Import item udf7.png


By : Lay Swan 180514, P190110



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations