< Managing your business with anyPiece < Inventory system for recycle business

Introduction

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

Steps

  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

 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 nameDescriptionRequired
GRNTo indicate which GRN that it is belong toYes
DATEReceiving dateYes
SupplierTypeTo indicate if this supplier is a company or just person. This field only accept two parameter which is
  • Company
  • NonCompany
Yes
SUPPLIERSupplier nameYes
ItemProduct nameYes
QTYQuantity in KIGYES
PricePrice of the goods. If there is invalid price or blank, it will set as 0No
STORAGETYPE(ignore this field)No
STORAGEPACKAGEType of product that will be receiveYes
This article is issued from Wikibooks. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.