Overview - User provides details and generates an inventory adjustment report. User specifies the report by the venue, store, group, or warehouse then provides details such as department and vendor, and enters SKU numbers between which to report items in the to and from boxes. The user then can generate the report or download the CSV file. The generated report will provide the venue name, store/warehouse, department, the SKUs, and the description, category, subcategory, supplier, quantity adjustment, unit cost, and cost value of each item.
This report provides detail of inventory adjustments due to shrinkage or damage. You can run details on specific transactions here or you can also view or reprint the adjustment receipt .
| Tip | ||
|---|---|---|
| ||
Run reports by stores and enterprise level reports to determine if certain items are more prone to shrinkage than others. Compare shrinkage to Periodic Sales reports to determine what the gross margin minus shrinkage numbers are for specific items or stores. What is the impact of shrinkage on your Margin minus Labor , do any specific stores or venues skew those numbers? |
Details
To filter Report by Venue, Store, Group, or Warehouse user selects the appropriate drop down.
Also adjustment can be consolidated by transactions.
To pull items by classifications user selects Department, Category, SubCategory, Vendor, Royalty, Size, Style, Color, Brand or Season. Any combination selected will pull the appropriate items to the report.
To view the report from a begining UPC number to an ending UPC number in numeric order user enteres the beginning UPC into From: and the ending UPC into To:
The generated report will provide
Venue - Name of the Venue
Store/Warehouse - Name of the Store or ware house
Department- Department name
SKU - The SKU of the item
Description - Description of the item
Category- Category of item
SubCategory - Subcat of item
Supplier - Name of vendor
Final QTY - Total amount in location
Adj QTY - Amount that was adjusted
Unit cost - Cost of item
Cost value - The cost of the item multiplied by the amount adjusted
This report displays which inventory and the quantity of inventory that has adjusted during a designated period of time.
DetailsAccess
Access - Access to this function at an enterprise level is limited by default to the System Administrator and Financial users only. Accounting, store managers, warehouse general managers as well as zone managers and human resource managers may view inventory adjustment report at Venues or Store assigned to them.