Managing your business with anyPiece/Inventory system for recycle business/Upload existing package to the warehouse

From Wikibooks, open books for an open world
Jump to navigation Jump to search

Introduction[edit | edit source]

This tutorial will cover on how to import old data (from other system) or physical count to the system

Steps[edit | edit source]

  1. Go to Inventory Management > Warehouse
  2. Select the location of the warehouse to show all the storage location
  3. Pick one of the storage location and you will be able to see "upload" button shown at the bottom of the tab
  4. Upload the CSV file
  5. Once complete, the system will show number of record uploaded

CSV file format[edit | edit source]

 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[edit | edit source]

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