Substruct Knowledge Base

Note: This article pertains to an older feature of Substruct Utilities. It is no longer supported and this article has been included in the KB for reference purposes.

With a Palm OS based handheld, you can gather data for the Cycle Counts module from anywhere in your store. Before you can use your Palm device, you must make sure it meets all of the following requirements: it must have DDH Software’s HanDBase 3 installed, it must have the Substruct Countsdatabase installed in HanDBase, and it must have an infrared (IrDA) port in order to beam sections to your computer. For assistance meeting these requirements, contact technical support.

Collecting Data for Cycle Counts on a Palm OS Device

HanDBase 3 is a database program designed for use with Palm OS devices. Inside the program you will find the three main Substruct databases: Order, Labels, and Counts. The following steps will walk you through opening HanDBase 3 and using the Counts database to gather data.

Opening HanDBase 3

• Click the Home icon on the screen of you handheld.
• From the top right-hand corner of the screen, select All from the categories list.
• Find and click on HanDBase 3 (it looks like a picture of a thumb). This open the program.

Opening the Counts Database

Once you are in HanDBase 3, you need to get to the main screen of the Counts database. This screen has Counts written on a tab in the top left hand corner of the screen. If you are not at this screen, us the steps below to get there. Otherwise, see the Entering Records into the Counts Database section below to continue.

• If you see Edit Record or New Record instead of Counts, click the OK button in the lower left-hand corner of the screen. You should now be at the main screen of the Counts database.
• If you see a different database name, such as Order or Labels, then you are in a different database altogether. See the Getting to the Home Screen of Handbase 3 section bellow. Once you are at the Home screen of HanDBase, highlight Counts and click Open.

Once you have the Counts database open, see the Entering Records into the Counts Database section below. Beaming a Handheld Counts Database section below.

Deleting One Record from a Database

• From main Counts screen, select the record you wish to delete.
• Click on the Edit Record tab to bring up the menu bar.
• From the Record menu, select Delete Record.
• When asked, “Are you sure you want to delete this record?” click Yes.

Deleting All Records from a Database

When you are ready to start a new order, you must first delete all of your old records from the database.

• From main Counts screen, click on the Counts tab to bring up the menu bar.
• From the Actions menu, select Delete Records.
• When asked, “Delete All Records _Within_ Filter ranges or _Outside_ of Filter range?” click Within.

Important Note: Keep in mind that deleting all records is much different than deleting the entire Counts database - deleting all the records happens frequently, but deleting the database will require you to restore your handheld from backup!

Loading a Handheld Database into Substruct Utilities

After you have beamed your Counts database to your computer, the database needs to be loaded into the Cycle Counts module of Substruct Utilities.

• Open the Substruct Utilities Cycle Counts module.
• Click the Add Handheld button.
• A window asking you to name the cycle counts section will appear. Enter a name for the section, such as “Aisle 4″ or “Tools”, and click OK.
• After the records finishing loading, a window will appear telling you how many records were added. The cycle counts section will then appear in Cycle Counts where it can be viewed, edited, compared, and updating into Cougar Mountain.