Inventory Control reports

Inventory Control standard reports provide insight into the Inventory subledger, enabling you to monitor the quantity and value of your inventory items. For example, you can see what's currently in your inventory, analyze the activity that has changed your inventory, and review cost calculations (used for cost of goods sold). You can also determine which items need to be reordered and how many units to reorder.

If you want to investigate transaction discrepancies, troubleshooting reports are available within inventory utilities. Additional reports generated by the maintain inventory valuation feature allow you to view the results of inventory costing updates.

Standard reports are reports that are typical to an application and have already been created for you. You can run them as they are or make slight modifications to them, such as setting filters to specify which items to include and from what time period or selecting from formatting options.

You create standard reports by configuring the filters available in the report settings page. Depending on the report, the report settings page presents 10-30 filter options such as:

  • Accounting period
  • Custom date ranges
  • Detail level
  • Summary views
  • Sorting
  • Grouping
  • Dimensional analysis

Reports about quantity

How much do I have? Use the following reports to check the quantity of your inventory items:

Report Description Sorted by

Inventory Register

Check beginning quantities, the net inventory activity, and the end quantity for each item for a given time period.

What can I learn from this report?
Identify your best-selling products and most-needed items, and reduce the risk of running out.

 

Item, Warehouse

Inventory Status

Status of all inventory available in all of your warehouses. You can see the current quantities for each item: the on-order, on-hand, reserved, and available quantities.

What can I learn from this report?
Gain stocking insight for maximum profitability. Optimize inventory levels to meet demand, and ensure that shelves do not carry low turnover items.


Item, Warehouse

Item Activity

Displays the history of item transactions, both increases and decreases, for a given time period. Like the physical inventory report, you can also see how many on-order, on-hand, and reserved quantities exist.

What can I learn from this report? 
The item activity report shows how transactions increase or decrease inventory levels, for a specific time period (date range). Includes negative inventory values.

 

Item, Warehouse

Kit Analysis

Displays the components of a kit and the number of units per component that are required to create the kit.

What can I learn from this report?
Determine whether you need more inventory. View information about the quantities needed to fulfill kit sales orders and the available quantities.

 

Warehouse, Item

Lot Tracking

Displays the available quantity for each lot number and the documents that increased or decreased that quantity.

 

Lot number, Document ID

Physical Inventory

Displays the current on-hand quantity for each item and the transactions that increased or decreased that quantity. This report helps you compare what in actually in your inventory against what's recorded in Intacct.

If serial, lot, or bin tracking is enabled, group the report results by serial number, lot number, or bin, aisle, or row.

What can I learn from this report?
Negative inventory transactions can impact quantities reported. Run the Maintain Inventory Valuation tool to keep the report updated and avoid quantity discrepancies.

If you allow negative item quantities, refer to the Item Activity report for a report on negative values.

Warehouse, item

You can change this default sort order.

Serial Tracking

Displays the available quantity for each serial number and the documents that increased or decreased that quantity.

Serial number, Document ID

Reports about value and unit cost

What's the current value of my inventory? The following table reports provide information about the total value of your inventory:

Report Description Sorted by

Inventory Costing

Displays all the transactions that increase or decrease the value of your inventory with the cost effect of each transaction. The report provides details about the cost method and cost calculation for each item in a transaction.

Document ID

Inventory Journal

Displays all the transactions that affect your inventory for a given time period. The report provides details about the quantity, per unit cost, and total cost (or value) for each item in a transaction.

Transaction

Inventory Valuation

Displays the on-hand quantity, per unit cost, and total value for each item in your inventory. You can use the total value to check against the inventory value reported in the general ledger.

Item

You can change this default sort order.

Reports about other inventory information

The following table describes the reports that provide other information about your inventory:

Report Description Sorted by

Inventory Analysis

Displays all the inventory transactions, such as adjustments, for a given time period. Order Entry and purchasing transactions are excluded.

Warehouse

You can change this default sort order.

Inventory Reorders

Displays the items in a warehouse that have fallen below their reorder point with a suggested amount to reorder.

Item, Warehouse