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
  • Minimum and Maximum Item Levels Report

Minimum and Maximum Item Levels Report

This report compares warehouse stock against levels defined in the item record, including minimum, maximum and ideal quantities. It also provides supplier and purchase price information. Choose Minimum and Maximum Item Levels from the Reports menu to open the following criteria window:

Illustration: Minimum and Maximum Item Levels report

.

Conditions: #

  • Item: Select a specific item to display.
  • Item Category: Select a parent item category to include only its items.
  • Branch: Select a branch to include stock in its warehouses and transactions within that branch.
  • Warehouse: Select a warehouse to report stock at that warehouse.
  • Advanced Item Conditions: Use item record fields to filter the items included. For example, to include items in the Kia parent category, set an advanced filter where Category equals Kia, as shown below:
0217- P-214

.

For Items That: #

The following options are available:

  • At Minimum Level: Include items whose actual stock is less than or equal to their minimum level.
  • At Reorder Level: Include items whose actual stock is less than or equal to their reorder level.
  • Below Ideal Quantity: Include items whose actual stock is below their ideal quantity.
  • Above Ideal Quantity: Include items whose actual stock is above their ideal quantity.
  • At Maximum Level: Include items whose actual stock is greater than or equal to their maximum level.
  • Balance: Enable this option to define a custom stock quantity condition. Select the unit, then choose a comparison operator:

  <   means Less Than.

  <= means Less Than or Equal To.

         >   means Greater Than.

>= means Greater Than or Equal To.

        =    means Equal To.

<> means Between two specified values.

Then enter the required comparison quantity.

Units: #

The following unit options are available:

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

Enable the required unit options to display quantities in each selected unit separately, as shown below:

0218- P-215

.

Best Supplier: The report identifies the supplier offering the lowest recorded purchase price for each item. If there are no purchase transactions, it displays the Main Supplier selected on the Information tab of the item record. Enable Customer Information to display supplier details.

The following fields are available:

  • Consider Invoices from Date to DateSet the date range within which purchase invoices are searched for the lowest purchase prices and their suppliers.
  • Number of SuppliersSet how many suppliers to display. Entering 2, for example, displays the two best recorded purchase prices and their suppliers.

Fields: #

Enable the required report fields in the Fields section. Most come from the item record.

Customer Information: #

Enable the required supplier information fields, which come from the customer/supplier record. Two options are available:

  • Show Customer Information: Enable this option to display the best supplier for the item. If disabled, best supplier information is hidden.
  • Show Price: Enable this option to display the purchase price for the supplier shown. Customer Information must also be enabled; a price cannot be shown without its supplier.

Options: #

The available options include:

  • Show Sequence Number: Enable this option to display sequential row numbers.
  • Show Items with No Stock: These are items with zero warehouse balances or no recorded transactions.
  • Show Unit: Enable this option to display the unit next to the quantity.
  • Combine Item Code and Name: Combine item code and name in one report field.
  • Show Difference From: Enable this option to display the difference between actual warehouse stock and one of the following levels:
    • Minimum Level.
    • Reorder Level.
    • Ideal Quantity.
    • Maximum Level.

Show: #

Display the report using the preceding conditions.

Print: #

Click this button to print the final report.

Generate Invoices: #

Use this button to generate a purchase invoice or purchase order, for example to replenish shortages. The generated quantity is the difference between actual stock and the level selected in Show Difference From. If actual stock is 5 units and the reorder level is 25, the shortage is 20 units; Generate Invoices creates a purchase invoice for those 20 units.

Click Generate Invoices to choose the customer/supplier account, invoice type, line order, maximum lines per generated invoice, pricing method, currency and exchange rate, as shown below:

Close:

Close the report conditions window.

Illustration: generate invoices

.

Practical examples of information available from the Minimum and Maximum Item Levels report:

  • Items that have reached their reorder level.
  • Items in the Clothing category that have reached their minimum level.
  • Items in the Main Warehouse that have reached their reorder level.
  • Items above their ideal quantity whose Origin field is Chinese.
  • Items with balances between 35 and 150 units in the first unit.
  • Clothing items at their reorder level, showing the difference between current stock and reorder quantity.
  • Items at their reorder level, displaying the best supplier for each item according to purchase price.
  • Items at their minimum level, with the option to generate purchase invoices or purchase orders.

.

See the Define Items in the Item Tree 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
Item Inventory Report: Options and UsesCustomer Transactions by Item Report

Powered by BetterDocs

Contents
  • Conditions:
  • For Items That:
  • Units:
  • Fields:
  • Customer Information:
  • Options:
  • Show:
  • Print:
  • Generate Invoices:
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