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 Transactions Report: Options and Uses

Item Transactions Report: Options and Uses

This report displays item receipts, issues, their prices and the remaining stock valued at cost. Open Item Transactions from the Reports menu or click Item Transactions on the main toolbar. The criteria window contains the following options:

Illustration: Item Transactions report options and uses

.

Conditions: #

  • Item: Select the item whose transactions you want to view. This field accepts a single item rather than an item category.
  • Item Group: Enable this option to display transactions for multiple items. Select the group using either of the following options:
  • Item Category: Select an item category to display transactions for its items.
  • Advanced Item Conditions: Set an advanced item filter to display transactions for matching items.
  • Branch: Select a branch to view item transactions within that branch.
  • WarehouseSelect a warehouse to view item transactions within that warehouse.
  • Cost Center: Select the cost center to which or from which items were allocated..
  • From Date / To Date: Specify the date range for the item transactions.
  • Customer Account: Select a customer account to display only that customer’s item transactions.
  • Sales Representative: Select a sales representative to display item transactions associated with that representative.
  • Description Contains / Does Not Contain: Enter text to match against the invoice description. Depending on the selected option, include or exclude invoices containing that text.

Advanced Conditions: #

  • Advanced Invoice Conditions: Set advanced invoice filters to include item transactions only from matching invoices.
  • Advanced Audit Conditions: Set advanced audit filters, such as creation or modification dates, to include transactions from matching invoices.

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.

Units: #

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

  • Show All Units: Enable this option to display the first, second and third units together.
  • Show Independent Unit: Enable this option to display the independent unit in addition to the units selected above.

Fields: #

Select the fields to display in the final report: Invoice Subnumber, Customer, Warehouse, Sales Representative, Description, Free Units, Total and Counterpart Warehouse.

  • Item Fields: Select additional report fields from the item record.
  • Invoice Line Fields: Select additional report fields from invoice lines.

Options: #

The following options are available:

  • Show Sequence Number: Display sequential report row numbers.
  • Finalized Invoices: Enable this option to include item transactions from finalized invoices.
  • Unfinalized Invoices: Enable this option to include item transactions from unfinalized invoices.
  • Compact Report: When this option is disabled, the detailed report displays three column groups: Receipts, Issues and Balance, as shown below:
Illustration: report options

.

When Compact Report is enabled, receipts and issues are combined in the same column group, as shown below:

Illustration: report options

.

Display Options: #

Show Quantities Only: Enable this option to show quantity columns without Price or Total columns.

Exclude Value Added Tax: Enable this option to exclude VAT when calculating totals.

Print Each Item on a Separate Page: Enable this option to print each item’s transactions on a separate page when reporting on multiple items.

Hide Items with No Transactions: Enable this option to hide items without transactions during the current year when reporting on an item group.

Show Transactions Since the Last Zero Balance: Enable this option to show transactions after the most recent point at which the item’s stock quantity was zero.

Show Only Item Transactions from Date…Enable this option to display transactions for one or more items after the specified date and exclude earlier transactions.

Show Only Items with Transactions from Date…Enable this option to exclude items with no transactions after the specified date when reporting on a group.

Invoice Types: #

Select the invoice types to include. For example, to view Fabric item transactions from sales invoices, enable only the Sales invoice type.

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 Transactions report:

  • Detailed Cotton item transactions from the start of the year to the present.
  • Detailed Cotton item transactions from finalized invoices, unfinalized invoices or both.
  • Detailed transactions for the Canned Goods category, printing each item on separate pages.
  • Detailed transactions for the Canned Goods category, hiding items with no transactions.
  • Detailed transactions for the Canned Goods category since each item’s most recent zero stock balance.
  • Detailed transactions for the Canned Goods category, including only items with transactions from July to the present.
  • Detailed Cotton item transactions from cash invoices only.
  • Cotton item transactions from sales and sales return invoices only.
  • Cotton item transactions from sales and sales return invoices associated with the sales representative Imad.
  • Detailed Cotton item transactions for the customer Anas.

.

See the Item Inventory report.

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
Total Transactions Report for Items and CategoriesMonthly Item Transactions Report

Powered by BetterDocs

Contents
  • Conditions:
  • Advanced Conditions:
  • Currency:
  • Units:
  • Fields:
  • Options:
  • Display Options:
  • 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