Itemized Inventory Report

This section describes the specifics of accessing and interpreting the Itemized Inventory Report.

Opening Report

This report can be found at Reports > Store > Inventory > Volume and state > Itemized Inventory. For more information, see Viewing Reports.

Viewing Report

The Itemized Inventory Report provides the detailed information on book and physical inventory matching selected report criteria for the defined period.

The Itemized Inventory Report contains the following information:

Items data: PLU, UPC, Description, Size, Categories, Groups, Departments
Open (Book) Inventory:
QTY
Ext.Cost
Ext.Retail
Cost: Calculated depending on the inventory accounting method applied to the current account:
If the FIFO method is not set up in the account settings, the item cost value is taken from the last invoice on the station.
If the FIFO method is set up in the account settings, the item cost value is calculated based on the FIFO method.

For more information on calculating the item cost, see Item Cost Calculation.

Purchased:
QTY
Ext.Cost
Ext.Retail
Buydown
Price Change
Write-Offs: Retail, Cost
MA Transfer
Sold
QTY
Ext.Retail
GPM %
Over/Short:
QTY
Ext.Retail
Cost
Ending (Book) Inventory:
QTY
Ext.Retail
Cost

Filtering and Sorting Report Data

To get the exact desired information, it is possible to apply filters to the report. To set up a filter, select one or more filtering options. Once the filter is set up, at the bottom of the filter section, click the Show or Refresh button to display the report data by the filter criteria.

The report provides the following filtering and sorting options:

Date: Specify the desired period for which the calendar is to be used or use one of the available filtering options. Then click Show. These are the available filtering periods:
Custom Date
Yesterday
Current Month
Current Quarter
Current Year
Last Month
Last Quarter
Last Year
Last 12 Months
Advanced: Click the advanced button, select the desired filtering option, and then click Refresh: These are the available advanced filtering options:
Filter By: Select one or several filtering options - by Category, Price Group, Promo Group, or Manufacturer - for the further breakdown of the results.
Sort by: Select the desired order of the report columns.
Subtotal By: Select Price Groups and/or Promo Groups for calculating the report's subtotals.

Press CTRL, to select several items at a time.

For more information on additional report features, see Reports.

Additional Actions

To view the totals only or the detailed data for the whole period, click the Show Totals Only or Show Detailed Data button correspondingly.