After you've scanned your inventory items, and imported the list into Ascend in the Reconcile Inventory area, it's time to deal with any discrepancies.

Count results are automatically sorted by discrepancy. Continue reading to learn more about each discrepancy type.

Note

Quantity changes made in the Reconcile Inventory screen are not saved when exiting without saving (and you shouldn't save until everything is fixed). The [Barcode] SKU/UPC Not Found discrepancy may require the user to exit the Reconcile Inventory screen, so resolve this discrepancy first.

[Barcode] SKU/UPC Not Found

Problem

The barcode scanned does not exist as a UPC or SKU in Ascend (e.g. a Part Number barcode was scanned).

Solution

Navigate to the folder on your computer where you are saving physical inventory results. In the Search field (located in the upper right on the toolbar), enter the barcode. On the keyboard, press Enter. All files which contain the barcode are displayed. You can double-click into a file to edit it and fix the issue.

Note

Always configure inventory scanners with Ascend's recommended settings - this ensures incompatible barcode labels are found as soon as they are scanned, making it easier to identify and re-label the product.

[#] Cross match SKU/UPC

Problem

There are [number] of products in your database that have a UPC matching the in-store SKU of another product. Ascend doesn't know if you scanned the one item's UPC or the other item's SKU.

Solution

Double-click the scanned line, and resolve the discrepancy through the duplicate products utility.

Note

Best practice database maintenance in Ascend includes cleaning up your duplicate products. Make sure to run the Remove Duplicate Products utility regularly. Just navigate to Tools > Advanced Database Function > Remove Duplicate In store Products.

[#] Duplicate SKU/UPC

Problem

As with X Cross Match SKU/UPC this discrepancy has to do with cleaning up duplicate products in your database. This discrepancy refers to X number of products in your database that have the same UPC or in-store SKU as the product scanned.
To resolve this double click the scanned line and resolve the discrepancy through the duplicate products utility.

Solution

To resolve this double click the scanned line and resolve the discrepancy through the duplicate products utility.

Note

Best practice database maintenance in Ascend includes cleaning up your duplicate products. Make sure to run the Remove Duplicate Products utility regularly. Just navigate to Tools > Advanced Database Function > Remove Duplicate In store Products.

Non-Inventory

Problem

A non-inventory item (like a Labor SKU) was scanned.

Solution

If the product's quantity should be tracked you need to go into the product record and uncheck the non-inventory box.

Otherwise, right click on the product and select remove. Please note that this does not remove the product from the database, just from your current reconcile screen.

Not in selected Category

Problem

You've scanned a product outside of the Category you told Ascend you were scanning. Perhaps you were going through and really got into your cycle count... then scanned a lock while scanning your computers.

Solution

Just right-click the Product and select remove if it is not part of that category.

If the item you scanned should be in the Category you scanned, but was categorized incorrectly, simply double-click the Product and move into the appropriate Category to resolve.

Cost equals $0.00

Problem

The Product does not have cost configured. This is especially important to resolve prior to reconciling in order to avoid your average cost for the Product staying at zero!

Solution

Double-click the Product and enter a cost into the estimated cost field. If the product actually does not have a cost, then leave the cost at zero.

Unfortunately, this won’t work if you have an Average Cost of zero; you will have to manually Recalculate the Average Cost for a product. 

Note

The best way to avoid running into this situation is by making sure to import the Cost column when adding new vendor product spreadsheets into your database, or including cost when you create a new individual product. Otherwise, make sure to regularly check the Products with No Cost report under Reports > In-Store Products.

Cost greater than MSRP

Problem

You have a Product in your database where the MSRP is configured as less than its Cost. If reconciled as is, the product would reflect a negative margin - not cool.

Remember that the reconcile feature pulls in items you did not scan and your negative inventory. Once you reconcile, it takes care of all of those products - that's why it's important to pay attention to all discrepancies.

Solution

To resolve this one, you can double-click the product and enter an MSRP greater than the cost.

This one also won’t work if you have an Average Cost of zero, and you will have to manually re-calculate the Average Cost.

Note

Best practice database maintenance in Ascend includes running the Products with Cost Greater than MSRP report regularly. this report can be found in Reports under In-Store Products.

Not Scanned

This discrepancy is a bit different than the rest. You'll want to make sure you're going to stay in the reconcile screen before starting to work on these items.

Problem

This flag refers to Products that have a positive Quantity On Hand in the database, but are not included in your scan file. This typically means that either you missed a few Products, or that these products are no longer in the shop.

Solution

To resolve this one, you need to investigate why the displayed Products, especially those of high value, were not scanned.

Did you forget about your back stock? Did someone forget to put that product on a Layaway? Was it not transferred? You need to take the time to figure this out before moving forward.

If you have a large list of Not Scanned products, you can print the list by clicking Preview in the top toolbar.

If the Product is in the store and not committed to a customer, you will single-click into the New Qty column and enter the correct quantity.

If the Product is a Special Order for a customer (including transfers requested from another multi-store location), verify the quantity column matches the sum of the special order not ordered and special order on order columns. Remember that the special order items are actual negative inventory and should stay at a negative quantity.