411 REFERENCE · Wikibooks
Managing your business with anyPiece/Inventory system for recycle business/Upload existing package to the warehouse
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
Introduction
This tutorial will cover on how to import old data (from other system) or physical count to the system
Steps
Go to Inventory Management > Warehouse
Select the location of the warehouse to show all the storage location
Pick one of the storage location and you will be able to see "upload" button shown at the bottom of the tab
Upload the CSV file
Once complete, the system will show number of record uploaded
CSV file format
GRN,DATE,SUPPLIERTYPE,SUPPLIER,ITEM,QTY,PRICE,STORAGETYPE,STORAGEPACKAGE,PO
IMPORT-C1,19-Feb-13,Company,ABC,AUDIO BOARD,170.5,, Jumbo Bag ,,
CSV field explanation
Field name Description Required GRN To indicate which GRN that it is belong to Yes DATE Receiving date Yes SupplierType To indicate if this supplier is a company or just person. This field only accept two parameter which is
Company
NonCompany
Yes SUPPLIER Supplier name Yes Item Product name Yes QTY Quantity in KIG YES Price Price of the goods. If there is invalid price or blank, it will set as 0 No STORAGETYPE (ignore this field) No STORAGEPACKAGE Type of product that will be receive Yes