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
Scroll down and Search for allow create new item when upload GRN
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 .
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 )
After the detail information has been fill up . Header , requirement and sample row need to be deleted.
Then , save the file to Text CSV format and don’t forget to tick the edit filter setting checkbox
One dialog box will appear and Click Keep current format .
Change the Field Delimiter to “|” and left blank the Text Delimiter .
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
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 header, req, and sample row.png (205.7 kB)
delimiter.png (94.3 kB)
edit filter setting.png (169.1 kB)
EMP configuration.png (194.2 kB)
enable create new item when upload.png (102.1 kB)
csv format.png (221.5 kB)
prepare the details.png (203.6 kB)
upload GRN.png (70.7 kB)