< 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
- 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
|
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 |
This article is issued from
Wikibooks.
The text is licensed under Creative
Commons - Attribution - Sharealike.
Additional terms may apply for the media files.