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
  • Total Transactions Report for Items and Categories

Total Transactions Report for Items and Categories

This report summarizes transactions by individual item, by category, or by both. The main criteria window contains the following fields:

Illustration: Total Transactions report for items and categories

.

Conditions: #

  • Item: Select an item to display its total transactions.
  • Item Category: Select an item category to display total transactions for that category.
  • Branch: Select a branch to include item and category transactions through its warehouses.
  • Warehouse: Select a warehouse to include item and category transactions through that warehouse.
  • Cost Center: Select a cost center to include invoices associated with that cost center.
  • From Date / To Date: Set the date range for the total transactions.
  • 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.
  • POS Sessions: Select a POS session to include item and category transactions from that session.

Advanced Conditions: #

  • Advanced Item Conditions: Set item filters, such as specifications, class, source or origin, to include only matching items and categories.
  • Advanced Invoice Conditions: Set invoice header or invoice line filters to include only matching transactions.
  • Advanced Audit Conditions: Set audit filters, such as invoice creation date or creator, to include only matching transactions.

Inventory Valuation Price: #

Select the valuation method for quantities in the Balance column.

Note: The Receipts and Issues columns use the average prices of the actual item transactions.

Sort: #

Sort Results By: Choose how to sort the report results. The available sorting 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

Units: #

Select the unit used to display the report. The available options are:

  • First Unit.
  • Second Unit.
  • Third Unit.
  • Default Unit.
  • Show All Units.
  • Show Independent 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 Conversion Factor: enable this option to enter a factor and display the report using that value.
  • Use the Scheduled Currency Rate Instead of the Transaction Rate: Use the rate from the exchange-rate schedule instead of the rate recorded in the original transaction.
  • Item Fields: Select fields from the item record to display in the report and adjust their order.

Options: #

The following options are available in this section:

  • Show Sequence Number: Display sequential numbers for report rows.
  • Finalized Invoices: Enable this option to include finalized invoices.
  • Unfinalized Invoices: Enable this option to include unfinalized invoices.

Break Down Invoice Types: #

Enable this option to show the defined invoice types separately, classified as receipts or issues, as shown below:

.

Illustration: break down invoice types

.

Separate Opening Inventory Invoices: #

Enable this option to display opening inventory invoices in a separate field rather than combining them with other receipt invoices. The following images show the difference:

With the option disabled, the report appears as follows:

.

Illustration: separate opening inventory invoices

.

With the option enabled, the report appears as follows: 

.

Illustration: separate opening inventory invoices

.

Display and Merge Options #

Show Item Categories: Display item categories in the report.

Hide Empty Categories: Enable this option to hide item categories without transactions.

  • Show Items: Display item-level details in the report.
  • Hide Items with No Transactions: This option controls the display of individual items in the category report.
  • Combine Item Code and Name: When both fields are selected, display item code and name together in one report field.
  • Show Balance: Enable this option to display an additional field showing the remaining quantity for items or categories.
  • Exclude Value Added Tax: Enable this option to exclude VAT when calculating totals.
  • Display Columns: Choose which transaction columns to display: Quantity, Price, Total and Free Units. You can enable one or more columns.
  • Merge Quantity with Free Units: Enable this option to combine the main quantity and free units in one column.

Invoice Types: #

Use the Invoice Types section to select the invoices included in the report.

Enable Also Show Invoice Types That Do Not Affect Quantity to include both quantity-affecting and non-quantity-affecting types. When disabled, non-quantity-affecting types are omitted, as shown below:

.

Illustration: invoice types

.

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

  • Total sales by item category, showing each category’s total sales quantity.
  • Total transactions by category, breaking down quantities and totals by the invoice types defined in the database.
  • Total purchases by category received into the Main Warehouse.
  • Total sales by category, displaying the individual items within each category.
  • Total sales for items and categories from finalized invoices only.

.

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
Free Units Inventory Report: Options and UsesItem Transactions Report: Options and Uses

Powered by BetterDocs

Contents
  • Conditions:
  • Advanced Conditions:
  • Inventory Valuation Price:
  • Sort:
  • Units:
  • Currency:
  • Options:
  • Break Down Invoice Types:
  • Separate Opening Inventory Invoices:
  • Display and Merge 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