Internal Inventory Audit

A common business practice is to periodically take an inventory of all of the assets that are in an internal location. Some users will do this every month and some every year and some just as needed.

This is done to make the system more accurate and to find lost assets.

There are two ways to conduct Internal audits with TrackAbout

Using TrackAbout's Physical Inventory handheld functionality. Includes website audit reconciliation process
Using TrackAbout's Locate action. Does not include reconciliation assistance.

Using the Physical Inventory feature

As of Spring 2015, handheld users can now conduct Internal Audits (Physical Inventories) through TrackAbout's Mobile application.

Creation

Inventory Audits are created automatically when Physical Inventory actions are saved from TAMobile 6. If an open audit does not exist for the Location, Inventory Type as Asset Family Collection (if Inventory Type of Cycle is chosen), one is created upon Physical Inventory record save. If one does exist that matches those three criteria, the saved record is added to open audit.

Open Audits

Audits are 'open' until a user completes reconciliation.

Summary

The Open Inventory Audit Summary screen lists the basic details (Location, Date, Inventory Type, and Asset Family Collection), the Physical Inventory records created by TAMoblie 6, and a summarized list of assets grouped by product code. The grouped lists shows the quantity expected to be found, actually found, and the following values:

Difference: simply the number of expected assets minus those found. Note that the found assets may not be the same as the expected assets.
Absolute Difference: the number of missing assets plus the surprise finds.
Missing Assets: unique assets that were thought to be at the location but were not counted during the audit.
Surprise Finds: unique assets that were thought to be an a different location or customer but were scanned the audit location.

Surprise Empty Assets

Surprise finds and missing assets are the primary irregularities found during audits, but there is a third type of problem: 'Surprise Empties.' These are assets thought to be full but scanned as part of an empty audit record. Upon reconciliation, we locate these assets as empty, changing their use states. For clients that use empty product codes, this will change the product code to the appropriate empty one. Therefore, the asset is tallied using its empty product code, on a different line item.

Expected assets and surprise finds can both be surprise empties.

Counted Assets

The counted assets page shows all the assets scanned during an audit, divided into two groups:

Surprise Finds: unique assets that were thought to be an a different location or customer but were scanned the audit location. When this tab is active, the grid displays an extra column: 'Last Known Location'.
Expected Assets: unique assets confirmed to be at the audit location.

This page highlights 'surprise empties' (by marking them with an asterisk and emphasizing the 'Scanned Status' text).

Missing Assets

This page displays unique assets thought to be at the audit location that were not counted during the audit.

Reconciliation

When reconciliation starts, a snapshot of the state of the audit is saved. If any information is added, changed, or deleted (new Physical Inventory records, reclassified assets, etc), the user is prompted the start the reconciliation over.

Reconciliation consists of three parts:

Surprise Finds - Lists assets that were scanned as part of the audit but are not located at the location the audit is for. These will be located at the location when the audit is completed.
Lost Assets - Assets that were thought to be at the location but where not scanned as part of the audit. If client config InventoryAuditHideLeaveAtLocationOption is set to True, the user is not given an option on how to handle the assets and all are marked lost at the completion of the audit. If InventoryAuditHideLeaveAtLocationOption is set to False, the user can choose which assets to mark lost and which ones to leave at the location (do nothing).
Completion of reconciliation - When an audit is completed, the system creates new records that mark the selected missing assets as lost, and locates assets as full or empty, depending on how they were classified during the Physical Inventory action on TAMobile 6. A special case exists for assets thought to be full but scanned as empty. Those are located empty during the completion of the reconciliation.

Reconciled Audit Summary

When an audit is reconciled, the summary screen shows the same basic details and summary (expected, found, difference) as the open audit. It also contains a list of newly created records that indicate which assets where Marked Lost, Located Full, or Located Empty.

Without the Physical Inventory Handheld feature

Scan the assets in "Locate" actions from handhelds.
- It is ok if you scan the same asset multiple times, the goal is just to get them all scanned.
- It is ok if this scanning take more than a day to complete.

From the website, use the "Remove Stale Inventory" page to find and remove stale assets.
- This page lets you find the assets that have not been scanned in X number of days
- Once you find the assets, you can mark them all as lost.

The balance for this location should now be accurate

Note: If you want to compare what TrackAbout thought was at the location with what actually was at the location the best way is to take a snapshot of the "Current Inventory" report before you start this scanning and then again after you finish removing the stale inventory.