Stock Take: Difference between revisions

Latest revision as of 07:43, 10 September 2021

Introduction

This Function & Mobile App which is use for Stock Take

Pros

01. Able to Stock Take/Count using Smartphone

02. Sync to SQL Accounting Stock Adjustment wireless

03. Able to Check Price

Cons

01. Unable to Sync if no WiFi or WiFi signal is very Weak

02. Drain Mobile Phone battery if keep On the Scanner

Requirement

Internet Access
SQL Accounting Version 781 & above
Smart Phone requirement

4 GB RAM & above
32 GB Storage (more Item more storage required)
Android 6 (Marshmallow) and above
Permission - Camera & Storage
IOS 11 and above

Barcode for Each Item Code

Stock Take App

History New/Updates/Changes

***History May direct refer to the Google Play or iTunes Store or Huawei AppGallery****

Steps

SQL Accounting

01. Stock | Stock Take

Click Allow Access if Windows Prompt the above warning

Leave this Screen Open as It will auto sync & update

After Done Scanning

09. Click Calculate Stock Take (System will compare with Month End As At Posted)

10. Click Post Stock Adjustments

Button	Description
New Job	To Start New Stock Take
Load From File	To Load file exported from Stock Take (in Zip) For Offline/No WiFi User use only Normally is in Zip Format
Export Stock List	To Export the Stock List for Stock Take For Offline/No WiFi User use only Normally is in Zip Format
Calculate Stock Take	To Calculate Stock Take
Export To CSV	To Export Grid Result to CSV
Post Stock Adjustments	To Post Grid Result to Stock Adjustment

[top]

Stock Take

02. When to Sync Data

After Done Sycn

03. Click Stock Take

04. Click Scan to begin Scan

05. If the Item Code Had More then 1 UOM it will prompt as Above.

06. Select the UOM & Click Select to Confirm

07. Here User can Adjust the Quantity Field (Optional)

08. Click Stop to End Scanning

[top]

FAQ

How to Reset/Start New Batch/Job of Stock Take?

In SQL Accounting

In Stock Take App

[top]

@@ Line 10: / Line 10: @@
 :01. Unable to Sync if no WiFi or WiFi signal is very Weak
 :02. Drain Mobile Phone battery if keep On the Scanner
-:03. Only support Android
 ==Requirement==
-* Wireless Network with same Network with SQL Accounting
+* Internet Access
 * SQL Accounting Version 781 & above
 * Smart Phone requirement
-:* 4 GB RAM &
+:* 4 GB RAM & above
 :* 32 GB Storage (more Item more storage required)
 :* Android 6 (Marshmallow) and above
-:* Permission - Camera
+:* Permission - Camera & Storage
+:* IOS 11 and above
 * Barcode for Each Item Code
 ==Stock Take App==
-* Last Update : 05 Nov 2019
+* [https://play.google.com/store/apps/details?id=my.com.sql.app.StockTake StockTake - Google Play]
-* Version : 1.1.9
+* [https://apps.apple.com/my/app/sql-stock-take/id1501802090 StockTake - Apple/iTunes Store]
-* [http://www.estream.com.my/downloadfile/StockTake.apk StockTake]
+* [https://appgallery1.huawei.com/#/app/C102639285 StockTake - Huawei AppGallery]
-* MD5 : 3D60BC789C205903D0FDBEF10C94FC2F
 ===History New/Updates/Changes===
---05 Nov 2019(1.1.9)--
+ ***History May direct refer to the Google Play or iTunes Store or Huawei AppGallery****
-* import items list from SQL Account through manual file transfer
-* export stock take items to SQL Account through manual file transfer
---24 Oct 2019(1.1.8)--
-* Fix Discovering server process will not be completed once application is reset (connect to different server or having new job).
-* Fix If problem 1 exist, app restart will have same problem when initiate import by clicking on either Stock Take, Price Check, or Picking List button at home page.
-* Improve Update / resync import data will no longer drop server connection. If the app is currently connected to a server, it'll directly skip to retrieving import data operation.
---21 Oct 2019(1.1.7)--
-* Updated UI for stock take item info frame and item history log info frame.
-* Fixed virtual keyboard doesn't hide when user clicks on item's image in stock take item info frame and item history log info frame.
---18 Oct 2019(1.1.6)--
-* Lengthen server discovery time
---16 Oct 2019(1.1.5)--
-* Speed up import barcode process.
-* Auto close item info and log item info frame when changed info is saved.
-* Fixed Auto disconnect once stock take using camera.
-* UI speed up for search item frame.
---15 Oct 2019--
-* Fixed keyboard will not show up when set reference in camera mode (for picking list mode).
---04 Oct 2019-2--
-* Fixed Price Checker mode does not show dialog when scanning item barcode instead of item code.
-* Fixed Stock Take / Picking List mode will now accept both item code and barcode when barcode format is used.
---04 Oct 2019-1--
-* Fixed scaling problem for Price Checker Dialog UI
---04 Oct 2019--
-* Modified Price Checker Dialog and updated hide filter box icon.
---01 Oct 2019--
-* Fixed First-time tethering will show error Connection Timeout.
 ==Steps==
@@ Line 78: / Line 42: @@
 [[File:StockTake-11.jpg|center|800px]]
 :10. Click '''Post Stock Adjustments'''
+{| class="wikitable" style="margin: 1em auto 1em auto;"
+|-
+! Button !! Description
+|-
+| New Job || To Start New Stock Take
+|-
+| Load From File ||
+* To Load file exported from Stock Take (in Zip)
+* For Offline/No WiFi User use only
+* Normally is in Zip Format
+|-
+| Export Stock List ||
+* To Export the Stock List for Stock Take
+* For Offline/No WiFi User use only
+* Normally is in Zip Format
+|-
+| Calculate Stock Take || To Calculate Stock Take
+|-
+| Export To CSV || To Export Grid Result to CSV
+|-
+| Post Stock Adjustments || To Post Grid Result to Stock Adjustment
+|}
 <div style="float: right;">   [[#top|[top]]]</div>