The Inventory Stock Count Detail generates inventory counts for the selected locations and dates, based on the configured Inventory Template.


Article Topics


  1. In the Reports section of the left navigation pane, select My Reports.
    The My Reports screen appears.
  2. At the top of the My Reports screen, select Purch. & Inv.
    The screen generates a list of reports in alphabetical order.
  3. Locate the Inventory Stock Count Detail.
  4. Select Customize to adjust the report parameters and run the report.


Back to Top


Report Parameters



FieldDescription
Filter ByLocation reporting category by which to filter the report.

Note: Options in the Filter By menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories.
FilterAllows users to apply one or more filter options from the location reporting category that they selected in the Filter By menu. The selected filters determine which locations appear in the generated report.

For example, if Filter By is set to Region, the Filter menu might include options such as North, South, East, and West. A user can select West to display all locations belonging to this reporting category.

Note: Options that appear in the Filter menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories.
Stock Count TypeType assigned to the inventory count template that was used to create the inventory count.
Stock Count DateDate when the inventory count was performed.
View optionsProvides the user with options to select, save, edit, or delete a report view.
For more information about these controls, see My Reports: Using My Reports.
RunGenerates the report.
The green arrow button opens a drop-down from which users can Export, Email, or Print the report.


Back to Top


Report Columns

ColumnsDescription
Location NumberNumber assigned to the location on the Location record.
Location NameName of the location.
Count DateDate when the inventory count was taken.
Count NameName of the inventory count.
Template NameName of the template used to create the inventory count.
FrequencyIndicates whether the inventory count is taken daily, weekly, monthly, or annually.
Item NameName of the item.
GL Account NameName of the GL account that was used to purchase the item.
GL Account NumberNumber used to identify the GL account that was used to purchase the item.
U of M NameUnit of measure of the item. This report uses the items' Inventory UofM 1.
QuantityNumber of units purchased.
Cost Per ItemCost for each unit of the item purchased.
Total AmountTotal amount that was spent purchasing the item.
Total Amount = Quantity x Cost Per Item


Back to Top


Email, Export, or Print the Report



This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.


Back to Top