logo

Inventory

John’s Journal, Issue #10 – SMARTScan your inventory

John’s Journal is a newsletter to provide SMARTSystem™ Users with the latest software highlights and solutions to improve business operations.

The SMART Mobile Suite is a collection of software programs for specific types of wireless bar code scanning devices that extend the functionality of the SMARTSystem Software.  The Motorola MC-3190 is the commonly used wireless barcode scanning computer that operates Windows Mobile 6 and the SMART Mobile programs:

SMARTScan is a major component of the SMART Mobile Suite:


The SMARTScan program is used for counting Physical Inventory by scanning the SKU, accumulating physical counts and locations. The Handheld display looks like this:


When completed the Handheld device is cradled to upload the scanned data directly to the Inventory Reconciliation program where the “Quantity” field is populated.  Multiple Handheld devices can be staged to accumulate quantities of like products.


This Inventory Reconciliation program has many options and can be used with the Handheld scanner, a laptop with scanner attached, tablet with scanner attached, quantities filled in an Excel spreadsheet and more.  It is a great tool to manage the status of your inventory. Please contact us if you would like more information or training on Inventory Reconciliation.  

Our goal is to provide you with software tools to make your job easier and improve your success with quality service delivered quickly. I would like your feedback and let me know if I can be of assistance.

Sincerely, John Henderson

John’s Journal, Issue #9 – Bar Code Scanning and Wireless Technology

John’s Journal is a newsletter to provide SMARTSystem™ Users with the latest software highlights and solutions to improve business operations.

The SMART Mobile Suite is a collection of software programs for specific types of wireless bar code scanning devices that extend the functionality of the SMARTSystem Software.  The Motorola MC-3190 is the commonly used wireless barcode scanning computer that operates Windows Mobile 6 and the SMART Mobile programs.

The software programs that comprise the SMART Mobile Suite are:

  • SMART Mobile Suite Menu
  • SMARTInventory Receiving
  • SMARTScan
  • SMARTPrice Check
  • SMARTShip

The SMART Mobile Suite Menu looks like this:


The SMARTInventory Receiving program collects the scanned SKUs until the user taps the “Upload Data” button.  The data is uploaded wirelessly to the Server application that combines all of the like SKUs to create a single receiving record for each product representing the Total Quantity scanned.

The SMARTScan program is used for counting Physical Inventory by scanning the SKU, accumulating physical counts and locations. When completed the device is cradled to upload the scanned data directly to our Inventory Reconciliation application in SMARTSystem.

The SMARTPrice Check program provides real time price lookups and the ability to print price labels directly from the MC-3190 device.  Simply scan the product SKU with the device and the system wirelessly communicates with the SMARTSystem database to return the Product Code, Product Description, Quantity On-Hand, Price and UPC Code instantly.  Once a product has been looked up, the user can choose to print labels directly to the Label Printer, with or without Prices.

The SMARTShip program will scan the SKU on boxes staged to load on a truck. When scanning is completed the user taps the “Upload Data” button to reconcile each scanned order and verify fulfilled orders or identify incomplete orders.

In all cases, the product SKU can be the SMARTSystem Product Code, UPC, or GTIN Code.

Our goal is to provide you with software tools to make your job easier and improve your success with quality service delivered quickly. Let us know if we can be of assistance to you.

Sincerely, John Henderson

John’s Journal, Issue #8 – About Inventory Control

John’s Journal is a weekly newsletter to provide SMARTSystem™ Users with the latest software highlights and solutions to improve their business operations.

You can achieve a perfect inventory without overbuying by allocating pre-book sales to purchase orders.

The Allocation of products will maintain the integrity of the orders without having to break orders up to adjust for “this and that.”  As you know, all types of changes usually occur when products are received.  By using our Allocation feature less changes are needed to fulfill orders. Here is one example of how to use the Allocation feature:


There is no other System that will keep everything in balance:  allocate product for the holidays, receive a large number of products, keep up with your current business activity, customers ordering on the website using SMARTSite, the inventory stays in-balance and you can still go home at a reasonable time each night because you know your inventory is under control. Also, with less stress you can treat your customers better.

Our goal is to provide you with software tools to make your job easier and improve your success with quality service delivered quickly. Let us know if we can be of assistance.

Sincerely, John Henderson

Inventory Flow Chart

Inventory Adjustments, Types of

There are two types of Inventory Adjustments:

  • Type 1 – Quantity Adjustments
  • Type 2 – Cost only Adjustments

Rapi.dll Error Message When Using SMARTScan

Problem:  When working with Inventory Reconciliation, you click on the “Get Data from SMARTScan” button.  Your program freezes and a Windows error message appears informing you the SMARTSystem program has closed.

The following error message will be logged in the SMARTSystem log files:

Message:Unable to load DLL ‘rapi.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)

 

Solution:  To use a scanner, the “rapi.dll” file will need to be installed.  A Microsoft program – Windows Mobile Device Center – will need to be installed on the computer that will be using the scanner before it will interface properly with the SMARTSystem.  The Windows Mobile Device Center program may be downloaded at the following link:  https://support.microsoft.com/en-us/kb/931937.

Before downloading and installing the Windows Mobile Device Center software program, verify which type of Windows operating system you are using – 32 bit or 64 bit.  This can be done by going into the Windows “Control Panel” and clicking on “System.”  Download the appropriate version for your operating system.

Once installed, you will see the icon on your Start menu for the software, as shown below:

WindowsMobileDeviceCenter-Icon

Should you get the message “Device driver software was not successfully installed,” you may safely ignore it.  The software has installed the rapi.dll file needed to run the SMARTScan function.

The Windows Mobile Device Center still needs to be configured.  Launch the program and accept the License Terms.

msLicense

If you do not have the scanner attached to the computer, you will see the following screen:

setUp

With your mouse, hover over the menu item “Mobile Device Settings.” Click on the “Connections settings” menu item and configure as you see in the screen below:

settings

The scanner will now work within SMARTSystem.

 

 

 

SMARTScan™ Introduction

Introduction to SMARTScan

SMARTScan is physical inventory software that was developed for the Motorola MC3190 mobile computing platform. The software was developed to fill the industries need to maintain accurate physical inventory counts and minimize labor costs.

SMARTScan allows the user of the MC3190 to scan the barcode on a product, enter its shelf location, the Quantity, then save the item and move on to the next product.

SMARTScan interfaces directly with the SMARTSystem line of PC Software applications for hand’s free inventory reconciliation.

The layout of the data that is collected by the mobile device is at the end of this document for easy integration with your existing inventory software.

SMARTScan™ V1.2 Operating Instructions

To start SMARTScan:

Turn on the unit
Press the Red button on the lower right corner of the unit

With your Finger or the Stylus:
Tap the “Start Button”
Then Tap the SMARTScan icon.

** If your Mobile Device is equipped with the Motorola App Center you can simply tap the SMARTScan icon to start the program.

 

SMARTScan Operation

After the SMARTScan software is started the following instructions can be followed for to enter Physical Inventory Counts and Locations.

Refer to the figures in the SMARTScan™ Device Screen Reference for visual aids.

Entering Inventory Counts:

The following instructions describe how to enter physical inventory items:

  • Enter the product Shelf location
  • Repeat until done with Shelf
    1. Scan the barcode
    2. Use the numeric Keypad to enter quantity
    3. Press ENTER on the keypad or tap save button

 

Starting a new Shelf:

These instructions describe how to complete the current shelf and start working with a new shelf:

  • Tap New Shelf button
  • Enter the product Shelf location
  • Repeat until done with Shelf
    1. Scan the barcode
    2. Use the numeric Keypad to enter quantity
    3. Press ENTER on the keypad or tap save button

 

Editing Detail Records / Making Corrections

Follow these instructions to make changes to data stored in the mobile device:

  • Locate the item in the Data Grid in lower portion of the screen
  • Tap the item you wish to modify with Finger or Stylus
  • Edit the desired information by tapping into the field containing the incorrect information
  • Press enter in Quantity field or tap Save to complete the correction

CLEAR ALL SCANNED ITEMS

WARNING! Performing this action will PERMANENTLY delete all of the physical inventory records stored in the device.

To PERMANENTLY DELETE all physical inventory data stored in the mobile device follow these instructions:

  • Double tap the Data Grid with your finger or Stylus
  • You will be prompted twice to confirm
    • See Figure 2 and Figure 3 in the Device Screen Reference
  • Confirm both times and data will be cleared
    • See Figure 2 and Figure 3 in the Device Screen Reference

 

SMARTScan™ Device Screen Reference

Overview

This section contains screen shots of the SMARTScan™ device screens for user reference.

Reference Screen Shots

Figure 1:

Main SMARTScan Inventory Screen:

invScreen

Figure 2:

If a data line is double-tapped the following screen appears to confirm that the user wants to delete all of the data in the device:

invDel

Figure 3:

If the user confirms that they want to delete all of the data in the device they are prompted a second time to be absolutely sure that they know all data will be permanently deleted:

invDelConfirm

 

 

 

SMARTScan™ Programmer Data Schema Reference

How the Data is Stored

The data collected by the SMARTScan software is stored as XML files in the root folder of the device. This is generally denoted as “\” when looking at the device.

All edits and modifications are stored in InventoryQuantities.xml

XML Record Layout (Schema):

The fields contained in each XML record of InventoryQuantities.xml are:

GUID:

Globally Unique Identification Value for the record

 

ScannedCode:

UPC value scanned by barcode reader (note these do not always contain  the check digit from the scanned barcode)

 

Shelf Location:

            The shelf location entered by the user

 

Quantity

The quantity entered by the user

 

DateTimeStamp:

The Date and Time according to the Mobile Device at the time the record was written.

Quick Way To Change Pricing For Several Inventory Items

I have a price increase on an inventory item. There are many different colors and three different sizes for this item.  Is there a quick way that I could change the pricing instead of having to change each item individually?

By using the Sales Price Maintenance screen, you can filter it to show all of the affected inventory items.  The price increase can then be updated individually, or you may increase or decrease the price by a percentage for all of them.

The Sales Price Maintenance screen is accessed by clicking on Management>Sales Price Maintenance

spmScreen