Before you begin:

• Make sure your system is set up with any needed Inventory Adjustment Types. Check out our article: Inventory - Understanding & Creating Inventory Adjustment Types for more information.
• Know that margin will not be updated on past sale transactions and sales reports. Past sale transactions were marked as completed in the system and can not be updated.

Accessing Inventory Adjustments

There are three ways you can create Inventory Adjustments.

1. From the Ascend desktop > Inventory Adjustment tile. 
2. From Database Explorer > Search Product > Open Product Record > Click +/- next to Quantity.
3. From the Ascend desktop > View > Inventory Adjustments > Add.

Walk through the Inventory Adjustment Prompt

• Search box: Search for products to adjust (not needed if you are creating the adjustment from within the product record).
  • Note: You can search by product Description, UPC, SKU, and Part Number.
• Description: The selected product's description will display.
• SKU: Product's Ascend In-Store SKU.
• UPC: Product's UPC.
• MSRP: Product's current MSRP/Price in your database.
• Quantity: Current quantity on hand at your location.
• Adjustment Type: All available “manual” inventory adjustment types.
• Action: Defaults to Decrease
• Decrease: To adjust a product OUT of inventory.
• Increase: To adjust a product IN to inventory.
• Unit Cost: The current Average cost of the product.
  • Note: Unit Cost can only be adjusted if the current quantity is 0 or while increasing.
• Value Change: Dollar change based on the Action, Unit Cost, and Quantity.
• Customer: Associate a customer if needed.
• Serial Number: If adjusting a serialized product in or out of inventory you cand associate a serial number to keep the product record and serial number accurate.
• Comment: All Inventory Adjustments require a comment. Enter a comment about why the adjustment is occurring. 
  • Note: This is your “paper trail” for why the adjustment in occurring and something that can be referenced during future inventory investigations.

Creating an Inventory Adjustment

From the Inventory Adjustment prompt

1. Search for the product (not needed if you are creating the adjustment from within the product record).

2. Either the exact product record or product search will be displayed

3. Select the product you need to adjust.
4. The Inventory Adjustment prompt will display with the product description, SKU, UPC, MSRP, Quantity (QOH).
5. Click the Adjustment Type dropdown.
6. Select the appropriate Adjustment Type.
7. Select the appropriate Action.
8. Enter a Unit Cost if adjusting in.
9. Enter a Comment: All Inventory Adjustments require a comment. 
   1. Note: The comment is your paper trail for tracking why the product was adjusted in or out of inventory. It helps you in the future to know why the adjustment happened if questions arise.
10. Click Save.

Fixing Average Cost

When a product is received without a cost or at the incorrect cost, its Average Cost must be manually recalculated in order to adjust its margin when sold.

Know that margin will not be updated on past sale transactions and sales reports. Past sale transactions were marked as completed in the system and can not be updated.

Quick Steps:

1. Adjust the QOH of the product OUT/DECREASE at the INCORRECT Cost.
2. Comment: Fixing Avg Cost.
3. Adjust the QOH of the product IN/INCREASE at the CORRECT Cost.
4. Comment: Fixing Avg Cost.
   1. Note: If the QOH of the item was incorrect as well, fix that when adjusting it back in as well. Update comment to read: Fixing Avg Cost and QOH.

Step-by-Step:

1. Search for the product (not needed if you are creating the adjustment from within the product record).

2. Select Other from the Type dropdown.
3. Action: Decrease.
4. In the Unit Cost field, accept the default value.
5. In the Quantity field, enter the amount you need to fix or current quantity on hand.
6. In the Comments field, explain the reason for the adjustment (such as Fixing Avg Cost, incorrect case qty set).
7. Click Save.

You have successfully removed the incorrectly received products. Now you need to re-add them at the correct cost.

1. Search for the product (not needed if you are creating the adjustment from within the product record).
2. Select Other from the Type dropdown.
3. Action: Increase.
4. In the Unit Cost field, enter the correct cost (e.g.: for case qty item, enter the cost of the individual item).
5. In the Quantity field, enter the amount you need to fix or current quantity on hand.
6. In the Comments field, explain the reason for the adjustment (such as Fixing Avg Cost, incorrect case qty set and Fixing).
7. Click Save.

KB22-070