Page Comparison

Menu Path: Inventory > Item > Upload Item Code

Image Removed

...

Image Added

Step 1: Click file link: 'Upload Item Template'

Image Removed

• The image above shows the pop up page that will be displayed upon clicking the Upload Item Template
• The red highlighted label of Target Fields are compulsory fields that are not allowed to be removed.
• The left section displays Source Fields that can be added and remove from the Target Fields, as per needed.
• Click on Download after completing this section.

Image Removed

• Use Open Office Calc to open the template file

Image Removed

• On the next screen, select by Separated by Comma, Text Qualifier Double Quotes

Image Removed

• Fill in the template content
• Not all the fields on the template are required, some may be optional. Please refer to the EMP Upload Item Code Screen on the required fields
• The new enhancement provides flexibility towards removing the unwanted compulsory fields
• User may now delete the non required fields on the .csv file

Image Removed

• Click on Choose File, upload the filled up template file that has been filled earlier.
• Choose the appropriate Delimiter and Text Qualifier.
• Click on Submit upon completing.
• Kindly refer to EMP Upload Item Code Screen if unclear on the data format.

Image Removed

...

Image Added

Notes:

1. select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
2. default format is “comma” delimiter

Step 2: Fill in the data 

Image Added

Excel sample:

Image Added

Step 3: Save file, save as comma separated values (.csv) format

Image Added

Image Added

Step 4: Upload file

Image Added

Image Added

Notes:

• If you want to update the exisiting information under customer data
• Please Follow Step 1 (download) to Step 4 (Upload)
• If item code exist, the system will overwrite it
• "Option" tickbox uses to check the completeness of the Tax Fields

Sample of Error Message:

• If user tick the "Option" box, and system found missing fields on Tax Column

Image Added

• If the file is not sucessfully uploaded, please refer to the column with RED color background
• Please move the cursor to the RED color background to see the Error Message

Image Added

• If this situation happen, please verify and correct the error eg: in the above case, put the add the PRICE_TAX_OPTION_INPUT Column in the file
• After editing the file, please repeat STEP 4

Related Wiki Page:

...