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
  • Item Inventory Report: Options and Uses

Item Inventory Report: Options and Uses

This report shows item quantities in warehouses. Open Item Inventory from the Reports menu or click Item Inventory on the main toolbar. The following criteria window appears:

Illustration: Item Inventory report options and uses

.

Conditions: #

  • Item: Select the item to inventory.
  • Item Category: Select the category whose items you want to inventory.
  • Branch: Select a branch to include item transactions in its warehouses.
  • Warehouse: Select a warehouse to include item transactions in that warehouse.
  • Cost Center: Select a cost center to inventory items allocated to that cost center.
  • From Date / To Date: Specify the date range for the item transactions included in the inventory report.
  • Customer Account: Select a customer account to report items sold to that customer, or a supplier account to report items purchased from that supplier.
  • Sales Representative: Select a sales representative to report items from invoices associated with that representative.
  • POS Sessions: Select a POS session to report items sold during that session.
  • Advanced Item Conditions: Use item record fields to filter the items included. For example, to inventory items with size M, set an advanced filter where Size equals M, as shown below:
0204- P-207

.

Advanced Conditions: #

  • Advanced Invoice Conditions: Set advanced invoice filters to include only matching invoices.
  • Advanced Audit Conditions: Use audit filters such as the invoice creator’s username or computer name, or the user who last modified the invoice.

Inventory Valuation Price: #

Select the price used to value item quantities. Company Cost is commonly used.

  • Quantity Filter: Available operators are All, Equal To, Not Equal To, Greater Than, Greater Than or Equal To, Less Than, Less Than or Equal To, and Between. Results are filtered accordingly.
  • Independent Quantity Filter: Available operators are All, Equal To, Not Equal To, Greater Than, Greater Than or Equal To, Less Than, Less Than or Equal To, and Between. Results are filtered accordingly.

Sort: #

Sort Results By: Select how to sort the report results. The available options are:

  • Item Code
  • Item Name
  • Category Code, Then Item Name
  • Quantity Ascending
  • Quantity Descending
  • Category Code, Then Quantity Ascending
  • Category Code, Then Quantity Descending

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 original transaction rate. This option is used when requesting the report in the base currency.

Units: #

The following unit options are available:

  • First Unit.
  • Second Unit.
  • Third Unit.

The report is displayed using the selected unit.

  • Default Unit: This option uses the unit marked Default on the Units tab of the item record. It can be the first, second or third unit.
  • Show All Units: This option displays quantity and price in the selected unit, together with quantities in the second and third units, as shown below:
Illustration: unit options

.

  • Show Independent Unit: Enable this option to display warehouse quantity in the independent unit in addition to the selected standard units, as shown below:
Illustration: unit options

.

Fields: #

Select the columns to display in the Fields section.

Options: #

The options section contains:

  • Show Sequence Number: Enable this option to display a sequential number for each item.
  • Show Positive Balances: Enable this option to display items with positive balances.
  • Show Negative Balances: Enable this option to display items with negative balances.
  • Show Zero-Balance Items: Enable this option to include items with zero warehouse stock in the inventory report..
  • Break Down by Warehouse: Enable this option and select the Warehouse field to display separate rows for each warehouse, showing the item quantity in each one, as shown below:
Illustration: report options

.

  • Break Down Quantity from Date: Enable this option to split warehouse quantity into opening quantity, receipts and issues beginning from the From Date value. The report then appears as follows:
Illustration: report options

.

Display Options: #

  • Show Physical Items: Enable this option to include records whose Item Type is Item, representing physical warehouse stock.
  • Show Service Items: Enable this option to include records whose Item Type is Service, representing services without physical warehouse stock.
  • Show Quantities OnlyEnable this option to omit item prices and the Price field. Click Display to view the quantity-only inventory report, as shown below:
Illustration: display options

.

  • Combine Item Code and Name: Combine item code and name in one report field.
  • Show Only Items with Transactions from Date: Enable this option and select the starting date used to identify items with transactions.

Item Quantity Breakdown:  #

  1. No Breakdown: Display each item without breaking its inventory down by subinventory keys.
  2. Use the Subinventory Fields Defined for Each Item: Break down inventory using the subinventory keys selected in the item record, such as color, size, batch, area, item class, expiry date, factory code, height, length, production date, volume or width.
  3. Use Custom Fields: This option lets you select subinventory keys manually rather than using those chosen in each item record. Available keys include color, size, batch, area, item class, expiry date, factory code, height, length, production date, volume and width.

Invoice Types: #

Select the invoice types whose transactions should be included in inventory calculations.

Show: #

Display the report using the preceding conditions.

Print: #

Click this button to print the final report.

Chart: #

Use this button to display inventory as a chart instead of a numeric table.

Close: #

Close the report conditions window.

Practical examples of information available from the Item Inventory report:

  • Total company inventory valued at cost.
  • Inventory of the Cotton item.
  • Inventory restricted to positive quantities, negative quantities or both. 
  • Inventory in the Main Warehouse only.
  • Inventory of the Clothing category only.
  • Quantities sold to the customer Tareq.
  • Quantities sold through the sales representative Imad.
  • Clothing category inventory, broken down into opening quantities, receipts and issues.
  • Inventory of physical items only, service items only or both.
  • Cotton inventory broken down by warehouse, with one row per warehouse.
  • Quantities purchased from the supplier Samer.
  • Clothing category inventory broken down by each item’s color and size.
  • Inventory of red clothing items in size 38.
  • A chart of Clothing category inventory.

.

See the Horizontal Item Inventory 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
Detailed Invoice Transactions ReportMinimum and Maximum Item Levels Report

Powered by BetterDocs

Contents
  • Conditions:
  • Advanced Conditions:
  • Inventory Valuation Price:
  • Sort:
  • Currency:
  • Units:
  • Fields:
  • Options:
  • Display Options:
  • Item Quantity Breakdown: 
  • Invoice Types:
  • Show:
  • Print:
  • Chart:
  • Close:
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