Versions Compared

Version Old Version 2 New Version 3
Changes made by

Ghugan Sivaperumal (Unlicensed)

Thirisaah A/P G. Noel Emile (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The diagram below outlines the general flow when using a Stock Take Device.

Image Modified

1. For the very first time after you install Mobile POS software, you need to setup stock take locations in the Mobile POS software by:
1.1a Going to menu File -> Setup Stock Take Locations
1.1b Key in Location 1 as Location1, Location 2 as Location2, Location 3 as Location3. Click on OK.

2. To import the excel file (eg. StockTakeImportData<yyyymmdd>.xls)
2a Go to menu File -> Import -> Stock Take Data
2b Select Microsoft Excel File(.xls), click on Next.
2c Select the file StockTakeImportData<yyyymmdd>.xls file
2d On the Select Table screen, click on Next
2e On the Fields Mapping screen as shown below, check the mapping (eg. 'Stock Code' is mapped to 'Stock Code' and etc). Once satisfied, click on Import.

Image Modified

2f A message box will pop up to inform you how many records are imported.

2.1 Download the item data from Mobile POS Software into the Mobile Stock Take Device.
2.1a Turn on the Mobile Stock Take Device by pressing on the On button. Select 2. Transfer as shown below

Image Modified

2.1b At the Mobile POS Software. You can either click on menu Device -> Download to Terminal or click on the "Download" button. Click on Ok.
2.1c You will be informed once the download is done.

3. You are now ready to perform the stock take. To perform stock take using the device. Select "Stock Take" on the device.

Image Modified

3.1. Press "1" to select the first location.

Image Modified

4. Point the Stock Device Device at the Bar Code of the Stock Item to count and press the "yellow" scan button to scan the Bar Code.

Image Modified

4.1 Key in the quantity of the Stock Item.

Image Modified

5. You may check the data.

...

8. You can now export the data as an excel file by:
8a Kindly ensure that you use a new StockCountExportData.xls file.
8b When you are ready go to menu File -> Export -> Stock Take Data.
8c At the Export screen, select "ODBC". ( To Setup the ODBC connection)
8d At the Data Link Properties, click on Connection. -> select "Use data source name" -> select "stockcountexportdata".

Image Modified

8g After you perform the file export, rename the exported file with the name format of StockCountExportData_<Location>_<yyyymmdd.xls> (For Example: StockCountExportData_NewYork_20110211.xls).

...