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 Expiry Dates Report

Item Expiry Dates Report

This report identifies expired items, items approaching expiry and items with sufficient remaining shelf life. Its criteria window contains the following options:

Illustration: Item Expiry Dates report

.

Conditions: #

  • Item: Select an item to view its expiry information.
  • Item Category: Select a category to view expiry information for its items.
  • Branch: Select a branch to include invoices involving its warehouses.
  • Warehouse: Select a warehouse to include expiry information only from invoices involving that warehouse.
  • Cost Center: Select a cost center to include expiry information only from invoices associated with it.
  • To Date: Set a cutoff date to include expiry information from invoices dated before that date.
  • 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.

Sort By: #

Two sorting options are available: 

  1. Item Code, then Expiry Date: Sort primarily by item code.
  2. Expiry Date, then Item Code: Sort primarily by expiry date, using item code where expiry dates match.
  • Advanced Item Conditions: Set advanced item filters to include expiry information only for matching items. See the earlier report guide for instructions on creating advanced item filters.
  • Advanced Invoice Conditions: Set advanced invoice filters to include expiry information only from matching invoices. See the earlier report guide for instructions on creating advanced invoice filters.
  • Advanced Audit Conditions: Set advanced audit filters to restrict results according to the user who created or modified the relevant invoices.

For Items That: #

Filter items using the following expiry options:

  • Have Expired: Include only items whose expiry date has passed.
  • Have Not Expired: Include items whose expiry date has not yet passed.
  • Have More Than … Days Until Expiry: Include items with at least the specified number of days remaining before expiry.
  • Have Fewer Than … Days Until Expiry: Include items with no more than the specified number of days remaining before expiry.
  • Have Between … and … Days Until Expiry: Include items whose remaining shelf life falls within the specified range.
  • Item FieldsSelect the fields to display and use the up and down arrows to change their order. Most come from the item record, such as item code, item name and source.

Options Section: #

The following options are available:

  • Show Sequence Number: Display sequential row numbers in the report.
  • Finalized Invoices: Enable this option to include finalized invoices.
  • Unfinalized Invoices: Enable this option to include unfinalized invoices.
  • Show Positive Quantities: Enable this option to display items with positive quantities.
  • Show Negative Quantities: Enable this option to display items with negative quantities.
  • Show Zero Balances: Enable this option to display items whose quantity is 0.
  • Combine Item Code and Name: Enable this option to combine item code and name in one field.

Report Type: #

Two issue allocation methods are available:

1. Allocate Issues to the Earliest Expiry Date: #

With this option, issues are allocated first to the oldest available expiry date. You do not need to specify an expiry date for each issued unit for this report allocation method.

2. Use Manually Specified Expiry Dates for Issues: #

With this option, specify the expiry date when issuing items. The report deducts quantities from the expiry date selected on the issue transaction.

The following historical example illustrates the difference between these methods:

Assume two quantities of paracetamol were purchased with the following expiry dates:

50 units expiring on 1 January 2021

40 units expiring on 1 June 2021, as shown below:

Illustration: manually specified expiry dates for issues

.

Assume 5 units were sold with the expiry date set to 1 June 2021, as shown below:

Illustration: manually specified expiry dates for issues

.

If the report is requested using “Allocate Issues to the Earliest Expiry Date”, the expiry date selected on the sales invoice is ignored for allocation. The five units are deducted from the earliest date, 1 January 2021, and the report appears as follows:

Illustration: manually specified expiry dates for issues

.

If the report is requested using the second method, “Use Manually Specified Expiry Dates for Issues”, the five units are deducted from the date specified on the invoice, 1 June 2021, and the report appears as follows:

Illustration: manually specified expiry dates for issues

.

Invoice Types: #

Select the invoice types included in the expiry report. Selecting only purchase invoices, for example, includes expiry dates from item receipts on purchase invoices only.

Show: #

Display the report using the preceding conditions.

Print: #

Click this button to print the final report.

Close: #

Close the report conditions window.

Practical examples of information available from the Item Expiry Dates report:

  • Items that have expired.
  • Items that have not yet expired.
  • Items with more than 60 days remaining before expiry.
  • Items with fewer than 15 days remaining before expiry.
  • Items with between 7 and 25 days remaining before expiry.
  • Expiry dates and remaining quantities for each expiry date, using finalized invoices only.
  • Expiry dates for items purchased from the supplier Samer.
  • Expiry dates for items whose names contain “Medicine”.
  • Expiry dates for items held in the company’s Main Warehouse.

.

See: Define Items

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
Customer Transactions by Item ReportHorizontal Item Inventory Report: Options and Uses

Powered by BetterDocs

Contents
  • Conditions:
  • Sort By:
  • For Items That:
  • Options Section:
  • Report Type:
    • 1. Allocate Issues to the Earliest Expiry Date:
    • 2. Use Manually Specified Expiry Dates for Issues:
  • Invoice Types:
  • Show:
  • Print:
  • 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