Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To import Opening stock, we have to use upload GRN function.

STEP 1 : Before upload the file, some configuration need to be done.

Control Panel > System Admin > EMP configuration > Inventory

Image Modified

Scroll down and Search for allow create new item when upload GRN

Image Modified

Then enable it by clicking the the tick box .

After done with the configuration . You will be able to see the upload GRN screen is more detail .

Image Modified

STEP 2 : Prepare the file to be uploaded .

...

Base on the Template file given , you are required to fill in the compulsory field ( written in red )

Image Modified

After the detail information has been fill up . Header , requirement and sample row need to be deleted.

Image Modified

Then , save the file to Text CSV format and don’t forget to tick the edit filter setting checkbox

Image Modified

One dialog box will appear and Click Keep current format .
Change the Field Delimiter to “|” and left blank the Text Delimiter .

Image Modified

Then Click Ok .

The file is ready to be upload in the EMP server .

STEP 3 : Upload GRN

Inventory > Others > Upload GRN

Choose the file and Click Submit

Image Modified

If the file contains any error, it will appear the error and you have to fixed the error and try to re-upload it.

 

 

disable create item.png (10 kB) Delete hafiza Hidayu, 2013-12-10 03:29 PM

delete header, req, and sample row.png (205.7 kB) Delete hafiza Hidayu, 2013-12-10 03:52 PM

delimiter.png (94.3 kB) Delete hafiza Hidayu, 2013-12-10 03:52 PM

edit filter setting.png (169.1 kB) Delete hafiza Hidayu, 2013-12-10 03:52 PM

EMP configuration.png (194.2 kB) Delete hafiza Hidayu, 2013-12-10 03:52 PM

enable create new item when upload.png (102.1 kB) Delete hafiza Hidayu, 2013-12-10 03:52 PM

csv format.png (221.5 kB) Delete hafiza Hidayu, 2013-12-10 03:52 PM

prepare the details.png (203.6 kB) Delete hafiza Hidayu, 2013-12-10 03:54 PM

upload GRN.png (70.7 kB) Delete hafiza Hidayu, 2013-12-10 04:17 PM