Inventory Adjustment Audit

Overview

In this article, you will learn about Sellercloud’s Inventory Adjustment Audit. This report is useful for tracking adjustments to your product inventory.

You can see information about:

  • Products and warehouses – SKU, product name, warehouse, warehouse ID, bin, and bin ID.
  • Inventory adjustments – date, quantity, adjusted by, user name, and adjustment reason.
  • Value – inventory cost and site cost.
For key points about Sellercloud’s Inventory reports, see the Inventory Value Reports Overview.
For more information about Sellercloud’s Financial Reporting Suite, see the Reports FAQ.

Access and Customize the Report

To use the report, follow these steps:

  1. Navigate to Reports > Inventory > Inventory Adjustment Audit.
  2. Set up the Default and Custom filters to have the report show precisely what you need.
  3. Click Search. Each filter you apply gets highlighted in a different color. If a filter is gray or not displayed at all, it’s not active.
  4. To manage the columns in the report, click the three dots icon on the top right and select Customize Columns. You can:
    1. Reorder columns by dragging them up or down in the list;
    2. Hide columns by clicking the Trash icons;
    3. Add columns by clicking Add column.
  5. To sort the data differently, use the Sort by menu.
  6. To save your filtering and sorting options, click Save view, then type a Name and click Save.
  7. To export the full report to a spreadsheet, click Actions on the bottom right and select Export to Excel. Spreadsheets include all columns, including those hidden in the report.

Filter and Column Descriptions

Click the drop-downs below for filter and column descriptions.

Default Filters
FILTERDESCRIPTION
CompanyInclude adjustments for products in one or more companies.
Date RangeInclude only adjustments from a preset time period. Choose from Yesterday to Last Year.
DateInclude only adjustments from a custom time range. Enter the Start and End dates. For a single date, choose the same Start and End date.

Custom Filters
FILTERDESCRIPTION
BinInclude only adjustments in a specific bin.
Bin EnabledInclude only adjustments in bin-enabled or non-enabled warehouses.
Company GroupInclude only adjustments in one or more company groups.
PurchaserInclude only adjustments bought by a specific purchaser.
SKUInclude only adjustments to one or more SKUs.
WarehouseInclude only adjustments in one or more warehouses.

Report Data
COLUMNDESCRIPTION
CompanyShows the company where an adjustment was made.
SKUShows the unique Stock Keeping Unit (SKU) code assigned to the product.
Product NameShows the product’s name.
WarehouseShows the name of the warehouse where inventory was adjusted.
Warehouse IDShows the unique ID of the warehouse in Sellercloud.
BinShows the bin where the adjustment was made.
Bin IDShows the unique ID of the bin in Sellercloud.
QtyShows the product quantity change.
Adjusted OnShows the date of adjustment.
Adjusted ByShows the ID of the adjustment operation.
User NameShows the email address of the person who made the adjustment.
Adjustment ReasonShows the reason for the adjustment.
Inventory CostShows the cost of the product inventory.
Site CostCorresponds to the Site Cost field in the Purchasing section of the product details page.

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support