Inventory Adjustments (xls) Report

Owned by Nicholas Cook, created
Sept 07, 2022
3 min read

The Inventory Adjustments (xls) Report is used to show what adjustments have been made to inventory between two dates. This report is typically used to help determine why your inventory valuation has changed between two points in time.

 FAQ

  • If you run the report for today, it will show the difference between the start of today and the time you ran the report at.

  • This report shows only the inventory adjustments from the period, it does not include changes to inventory valuation from invoices (sales, returns, layaways), receivings, transfers, or orders.

 Summary Worksheet Field Definitions

  • By Employee - Location: This is the location (report code) associated with the Employee making the adjustment.

  • By Employee - Employee: This is the employee associated with the adjustment.

  • By Employee - # Adjs: This is how many adjustments this employee made in the period.

  • By Employee - Adj Qty Total: This is the total summed inventory quantity of the adjustments made by the employee during the period.

  • By Employee - Adj Ext Cost Total: This is the total summed extended cost of the adjustments made by the employee during the period.

  • By Adjustment Reason - Location: This is the location associated with the Adjustment Reason

  • By Adjustment Reason - Adj Reason: This is the adjustment reason. This list includes

  • By Adjustment Reason - # Adjs: This is how many adjustments for this reason got made in the period.

  • By Adjustment Reason - Adj Qty Total: This is the total summed inventory quantity of the adjustments made for this adjustment reason during the period.

  • By Adjustment Reason - Adj Ext Cost Total: This is the total summed extended cost of the adjustments made for this adjustment reason during the period.

 Details Worksheet Field Definitions

  • Location: This is the report code associated with the

  • Invoice Date: This is the date associated with the inventory adjustment.

  • Adj Reason: The reason for this adjustment.

  • Employee: The employee making this adjustment.

  • SKU: This is the product’s SKU.

  • Barcode: This is the barcode of product from the time of the adjustment.

  • Description: This is the products description from the time of the adjustment.

  • Category: This is the products category from the time of the adjustment.

  • Manufacturer: This is the products manufacturer from the time of the adjustment.

  • Brand: This is the products brand from the time of the adjustment.

  • Unit Cost: Last unit cost in that day

  • Prev Qty: Quantity on hand before the adjustment.

  • Prev Ext Cost: Quantity on hand before the adjustment times the cost tied to the product at the time of the adjustment.

  • Adj Qty: Total Adjusted Quantity

  • Adj Ext Cost: Total Adjusted Quantity times the cost tied to the product at the time of the adjustment.

  • Non Inv Adj Qty Changes: Total Quantity changes during period from non inventory adjustments (Sales, Purchases, Returns, Transfers, Orders)

  • Non Inv Adj Ext Cost: Total Quantity changes during period from non inventory adjustments times the cost tied to the product at the time of the adjustment

  • Adj % Qty: Total Adjusted Quantity divided by Prev Qty (if Prev Qty is 0, it returns 100%)

  • After Qty: Total Qty at the end of period of adjustment

  • After Ext Cost: Total Qty at the end of period of adjustment times the cost tied to the product at the time of the adjustment

  • Notes: This is the notes that got added tied to the individual inventory adjustment.

 Known Issues

  • Multiple inventory adjustments on the same day on the same product at the same location will result in the following fields being wrong:

    • Prev Qty, Prev Ext Cost, After Qty, and After Ext Cost: These fields will show the values from the last inventory adjustment made.

    • Non Inv Adj Qty Changes, Non Inv Adj Ext Cost: These fields will show an inaccurate non inventory adjustment movement.

 Related articles