Skip to content

Adjustments (Activity)

What the Adjustments (Activity) Report Shows

Reports → Inventory → Adjustments (Activity)

The Adjustments (Activity) report (titled Adjustment Log on the page) is the transaction-level log of inventory adjustments. Where the Adjustments report summarizes adjustment dollars by department, this report lists every individual adjustment in a date range — which item, which employee, which store, what type of adjustment, and the quantity and cost involved.

Use it to:

  • Investigate a surprising variance number on the Adjustments report or the Accounting report — drill to the exact transactions behind it.
  • Audit a single employee's adjustment activity.
  • Review everything that was trashed, used in-store, or given as warranty replacements in a period.

Running the Adjustment Log

  1. Enter a Start date (required — the report returns nothing without one) and, optionally, an End date. With no End date, the log runs from the Start date forward.
  2. Optionally narrow the results with the Employee, Store, and Type dropdowns.
  3. Click View.

After the results load, each column header also has a filter box (or dropdown) so you can narrow the table further — for example to a single department or a single PLU. The TOTALS row at the bottom recalculates automatically as you filter.

Click the download icon above the table to export the results as a CSV file (Adj Log.csv).

Columns on the Adjustment Log

  • Date — when the adjustment was recorded.
  • Type — the kind of adjustment, shown as its system code: MANUAL COST ADJ (manual average-cost change), MANUAL QTY ADJ (manual quantity change), MANUAL SALE (manual sale), PHY QTY (physical inventory count variance), REPLACEMENT (warranty replacement), STORE USE (store use), TRASH (item trashed), plus any client-specific types your business uses. (The Type dropdown above the results lists these same types under shorter names: Cost, Qty, Sale, Inv, Warranty, Store, Trash.)
  • Department / Sub Dept — the item's department and sub department.
  • PLU — the item number; click it to open the item page.
  • Description — the item description.
  • Qty — quantity adjusted (negative when inventory was removed).
  • Unit Cost — the item's average cost used for the adjustment.
  • Total Cost — Qty × Unit Cost (negative when inventory was removed).
  • Abs Cost — the absolute (unsigned) value of Total Cost; useful for totaling gross adjustment activity regardless of direction.
  • Retail (Now) — the item's current retail price. This is today's price, not the price at the time of the adjustment.
  • Employee — who made the adjustment.
  • PO# — the purchase order the adjustment is tied to, if any.
  • Store — which store the adjustment applies to.
  • Note — the note entered with the adjustment, if any.

Some clients see additional columns: Location and Lot Name (for businesses tracking inventory lots and locations) and Vendor. These are enabled per-client by VMX — contact help@vmxllc.com if you need them.

What the Adjustment Log Does NOT Include

  • Receiving activity is excluded. Adjustments generated by receiving purchase orders (including receive-to-zero corrections) do not appear here — use your PO and receiving reports for those. Selecting Rcv. 0 in the Type filter will return no rows for this reason.
  • Zero-quantity adjustments are excluded. Cost-only changes with no quantity movement do not appear.
  • Adjustments — adjustment dollars summarized by department and period, with drill-down to items.
  • Inventory Log — the log of item field changes (price, cost, descriptions), as opposed to quantity/cost adjustments.