Skip to content
Contact Us
الميزان دوت نت للمحاسبة والمستودعات
  • Home
  • About the Software
    • About Us
    • Our Clients
  • Products
  • Services
  • Learning
    • Knowledge Base
    • Video Tutorials
  • Blog
  • Downloads
    • Al Mizan .NET
    • Updates
    • Utilities
  • العربية
  • Home
  • About the Software
    • About Us
    • Our Clients
  • Products
  • Services
  • Learning
    • Knowledge Base
    • Video Tutorials
  • Blog
  • Downloads
    • Al Mizan .NET
    • Updates
    • Utilities
  • العربية
  • Home
  • About the Software
    • About Us
    • Our Clients
  • Products
  • Services
  • Learning
    • Knowledge Base
    • Video Tutorials
  • Blog
  • Downloads
    • Al Mizan .NET
    • Updates
    • Utilities
  • العربية

User Guide

  • Knowledge Base
  • Accounting Menu
    • Chart of Accounts and Account Cards in Al Mizan
    • Define Customer and Supplier Records
    • Budgets and Their Uses
    • Account-Specific Analysis in Al Mizan
    • Transfer Account Transactions in Al Mizan
    • Account Analysis: General Analysis
    • Allocation Accounts in Al Mizan
    • Aggregate Accounts
    • Allocate Accounts to Cost Centers
    • Closing Accounts in Al Mizan
  • Accounting Reports
    • Receivables and Payables Aging Report in Al Mizan
    • Customer Balances Report in Al Mizan
    • Customer Statement Report in Al Mizan
    • General Ledger Report in Al Mizan
    • Trial Balance Report in Al Mizan
    • Most Active Customers Report
    • Inactive Customers Report in Al Mizan
    • Journal Daybook Report in Al Mizan
    • Account Transaction Analysis Report in Al Mizan
    • Budget Report
    • Monthly Account Transactions Report
    • Closing Accounts Report in Al Mizan
    • Cost Center Ledger Report
    • Permissions Report: Options and Uses
    • Chart of Accounts Report
  • Archiving
    • Archiving Module in Al Mizan .NET
  • Definitions Menu
    • Invoice Type Settings in Al Mizan
    • Sales Representative Invoice Commissions in Al Mizan
    • Cost Centers in Al Mizan
    • Define Custom Journal Vouchers in Al Mizan
    • Define Commercial Paper Types in Al Mizan
    • Sales Representatives: Journal Entry Commissions
    • Define Branch Records and Configure Their Options
    • Payment Methods in Al Mizan
    • Define the Currency Exchange-Rate Schedule
    • Define Currencies and Configure Their Options
    • Define Bank Records in Al Mizan
    • Define Warehouse Records and Configure Their Options
  • Features
    • Start Page Settings and Panels in Al Mizan
    • Database Rollover in Al Mizan
    • Processing Import Transactions
    • Use Al Mizan Functions in Excel
    • Configure Perpetual Inventory in Al Mizan
    • Define and Use an Item Independent Unit
    • Use Item Subinventory in Invoices
    • Report Toolbar Options
    • Import Items and Accounts from Excel
    • Audit Log: Options and Uses
    • Task List: Options and Uses
    • Design Page and Report Headers and Footers
    • The Calculator in Al Mizan
  • File Menu
    • Delete a Database in Al Mizan
    • Create and Restore a Database Backup
    • Create and Set Up a New Database
    • Attach Database Files
  • Financial Statements
    • Financial Statements in Al Mizan
  • Fixed Assets
    • Fixed Asset Management in Al Mizan
  • Inventory Reports
    • Detailed Invoice Transactions Report
    • Item Inventory Report: Options and Uses
    • Minimum and Maximum Item Levels Report
    • Customer Transactions by Item Report
    • Item Expiry Dates Report
    • Horizontal Item Inventory Report: Options and Uses
    • Item Transaction Analysis Report: Options and Uses
    • Free Units Inventory Report: Options and Uses
    • Total Transactions Report for Items and Categories
    • Item Transactions Report: Options and Uses
    • Monthly Item Transactions Report
    • Inactive Items Report: Options and Uses
    • Invoice Line Profit Report
    • Most Profitable Items Report
    • Most Active Items Report
    • Invoice Profit Report
    • Invoice Totals Report: Options and Uses
    • Serial Number Inventory Report
    • Item and Category Profit Report
    • Quotation Comparison Report
    • Serial Number Transaction Report
    • Item List Report in Al Mizan
  • Invoices Menu
    • Detailed Invoice Fields and Settings in Al Mizan
    • Manage Invoices
  • Items Menu
    • Item Accounting Groups in Al Mizan
    • Define Item Cards and Categories in Al Mizan
    • Item Barcode Schemas in Al Mizan
    • Invoice Operations in Al Mizan
    • Compare Warehouse Stocktakes
    • Update Item Prices
    • Carried-Forward Item–Branch Statistics
    • Carried-Forward Item–Customer Statistics
    • Manage Items in Al Mizan
    • Transfer Item Transactions
    • Minimum and Maximum Item Levels
    • Arrange Invoices in Al Mizan
    • Update Information for a Group of Items
  • Journal Entries Menu
    • Use Custom Journal Vouchers in Al Mizan
    • Process Commercial Papers in Al Mizan
    • Define and Use Commercial Papers in Al Mizan
    • Manage Currency Exchange Differences
    • Manage Custom Journal Vouchers
    • Manage Journal Vouchers in Al Mizan
    • Journal Operations in Al Mizan
    • Enter Journal Data and Configure Entry Settings
  • Manufacturing
    • Manufacturing Management in Al Mizan
  • Orders
    • Order Management in Al Mizan
  • Permissions Menu
    • Permissions: Options and Uses
    • Posting Policies in Al Mizan
    • Field Permissions in Al Mizan
    • Confidentiality Levels and Password Changes
  • Point of Sale
    • Point of Sale in Al Mizan
  • Real Estate
    • Real Estate Management in Al Mizan
  • Tools Menu
    • General Program Settings in Al Mizan .NET
    • Print Designer in Al Mizan
    • Advanced Print Designer Properties
    • Manage Print Design Groups
  • Training Courses
    • Training Course Management in Al Mizan
Show Categories
  • Home
  • Knowledge Base
  • User Guide
  • Inventory Reports
  • Inactive Items Report: Options and Uses

Inactive Items Report: Options and Uses

This report provides statistical information about slow-moving or inactive items. Set an inactivity threshold suited to your business. For high-value products, inactivity might mean no units sold during the report period; for inexpensive products sold in large quantities, it might mean fewer than 1,000 units sold. Choose Inactive Items from the Reports menu to open the criteria window shown below, which contains the following fields:

Illustration: Inactive Items report options and uses

.

Conditions: #

  • Item Category: Select a category to display inactive items within that category.
  • Branch: Select a branch to display inactive items in warehouses belonging to that branch.
  • Warehouse: Select a warehouse to display inactive items in that warehouse.
  • Cost Center: Select a cost center to analyze item transactions on invoices associated with that cost center.
  • From Date, To Date: Set a date range to include invoices dated within that period.
  • Description Contains: Enter text to include invoices whose description contains that text.
  • Description Does Not Contain: Enter text to exclude invoices whose description contains that text.

Report Type: #

Two options are available:

  • Statistical (Add Receipts and Issues): Statistical mode adds receipt and issue quantities to measure transaction activity. For example, purchasing 3 units at 100 lira each and selling 1 unit at 200 lira produces a statistical quantity of 4 units. Their reported value is calculated using the price selected in the Inventory Valuation Price field.
  • Inventory (Subtract Issues from Receipts): Inventory mode subtracts issues from receipts. For example, purchasing 3 units at 100 lira each and selling 1 unit at 200 lira produces an inventory quantity of 2 units. Their value is calculated using the inventory valuation price selected in the next field.

Advanced Conditions: #

  • Advanced Item Conditions: Set an advanced item filter to include only inactive items matching that filter.
  • Advanced Invoice Conditions: Set an advanced invoice filter to include item transactions only from matching invoices.
  • Advanced Audit Conditions: Set an advanced audit filter to include transactions only from invoices matching that filter.
  • Number of Items: Set the number of items to display. Entering 10, for example, displays the ten least active items according to quantity, value or invoice count.

Criterion: #

Choose the measure to which the inactivity threshold will apply:

  • Total Quantity: This option ranks inactive items by their total quantity across the selected invoices, in ascending order.
  • Number of Invoices: This option ranks inactive items by invoice count, in ascending order.
  • Total Value: This option ranks inactive items by total value across the selected invoices, in ascending order.

Inactivity Threshold: #

Enter a quantity, value or invoice count threshold according to the selected criterion. Items with activity at or below that threshold are considered inactive. For example, selecting Invoice Count and entering 10 includes items appearing on ten invoices or fewer during the report period.

Unit: Select the unit used to display the report and calculate the inactivity threshold: First Unit, Second Unit, Third Unit or Default Unit.

Currency: #

Select the currency in which the report should be displayed.

Exchange Rate: Specify the rate relative to the base currency. This field is available only for a secondary currency and offers two choices:

  1. Use the Exchange-Rate Schedule: Retrieve exchange rates automatically from the schedule, using the rate applicable on each transaction date.
  2. Use a Specified Exchange Rate: Enter a rate in the field that appears and use it to display the report.
  • Use the Scheduled Currency Rate Instead of the Transaction Rate: Use the rate from the exchange-rate schedule instead of the rate entered in the original transaction. This option is used when requesting the report in the base currency.

Item Fields: #

Choose the fields to display. Most come from the item record, alongside report fields such as Total Value and Invoice Count.

Options: #

The options section contains:

  • Show Sequence Number: Display a Sequence field with sequential item row numbers.
  • Finalized Invoices: Enable this option to include transactions from finalized invoices.
  •  Unfinalized Invoices: Enable this option to include transactions from unfinalized invoices.
  • Show Total Quantity: Enable this option to display Total Quantity. To use it, select one of the item unit fields.
  • Show Inventory Quantity: Enable this option to display the item’s inventory quantity. Unlike Total Quantity, Inventory Quantity includes free or bonus units. Total Quantity also follows the selected statistical or inventory report mode, whereas Inventory Quantity always shows the inventory balance.
  • Combine Item Code and Name: Combine item code and name in one report field.

Invoice Types: #

Select the invoice types whose item transactions should be included.

Show: Display the report using the preceding conditions.

Print: Click this button to print the final report.

Chart: Display the results as a chart instead of numbers. See the chart section of the reports guide.

Close: Use this button to close the report criteria window. 

The following example shows a report ranked by invoice count, with an inactivity threshold of 9 invoices:

.

Illustration: invoice types

.

Practical examples of information available from the Inactive Items report:

  • Items whose sales value is below 10,000 currency units.
  • Items whose sales quantity is below 150 units.
  • Items appearing on fewer than 25 sales invoices.
  • The least active items based on finalized invoices, unfinalized invoices or both.
  • Inactive items during the first three months or another specified period.
  • The least active items in the Canned Goods category.
  • The least active items for a specified customer account.
  • The least active items for a specified branch, based only on transactions in its warehouses.
  • The least active items for a specified warehouse, based only on its transactions.

.

See the Most Active Items report section.

Follow our YouTube channel

Share This Article

  • Facebook
  • X
  • LinkedIn
  • Pinterest
Could not find what you need? Contact us

How can we help you?

Updated on October 2, 2026
Monthly Item Transactions ReportInvoice Line Profit Report

Powered by BetterDocs

Contents
  • Conditions:
  • Report Type:
  • Advanced Conditions:
  • Criterion:
  • Inactivity Threshold:
  • Currency:
  • Item Fields:
  • Options:
  • Invoice Types:
Mizan logo black1

Al Mizan .NET Accounting and Inventory: take the next step toward more effective business management

Quick Links

  • Knowledge Base
  • Privacy Policy (Arabic)
  • Terms and Conditions (Arabic)
  • Contact Us

Stay Informed

Get the latest news and offers from our website 

  • Abdurrahman Nafiz Gürman, No:05
    Güngören/İstanbul
  • +905360652643
  • info@hadarasoft.net
© 2026 Hadarasoft
Instagram Facebook-f Youtube
Need help? Contact us