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

Item Transaction Analysis Report: Options and Uses

This report tracks changes in the activity of an item or group of items across periods specified by the user. Rows represent time periods rather than individual items, allowing you to analyze transactions over time. The criteria window contains the following fields:

Illustration: Item Transaction Analysis report options and uses

.

Conditions: #

  • Item: Select an item to analyze its transactions.
  • Item Category: Select an item category to analyze its transactions.
  • Branch: Select a branch to analyze item transactions in its warehouses.
  • Warehouse: Select a warehouse to analyze item transactions in that warehouse.
  • Cost Center: Select a cost center to analyze item transactions associated with it.
  • From Date / To Date: Specify the report date range.
  • Units: Select the unit used to display the report.
  • Customer Account: Select a customer or supplier account to analyze item transactions from that account’s invoices.
  • Sales Representative: Select a sales representative to analyze transactions from invoices associated with that representative.
  • 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.

Advanced Conditions: #

  • Advanced Item Filters: Set item filters, such as specifications, class, source or origin, to include only matching items.
  • 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.
  • Payment Method: Select a payment method: Cash, Credit or Commercial Paper. Only invoices using that method are included.

Report Type: Two options are available: #

  • Statistical (Add Receipts and Issues): Statistical mode adds receipt and issue quantities to measure transaction activity. For example, purchasing 3 units at 100 lira each and selling 1 unit at 200 lira produces a statistical quantity of 4 units. Their reported value is calculated using the price selected in the Inventory Valuation Price field.
  • Inventory (Subtract Issues from Receipts): Inventory mode subtracts issues from receipts. For example, purchasing 3 units at 100 lira each and selling 1 unit at 200 lira produces an inventory quantity of 2 units. Their value is calculated using the inventory valuation price selected in the next field.

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.

Options: #

The options section contains:

  • Show Sequence Number: Display sequential row numbers in the report.
  • Finalized Invoices: Enable this option to include transactions from finalized invoices.
  • Unfinalized InvoicesEnable this option to include item transactions from unfinalized invoices.
  • Exclude Value Added TaxEnable this option to exclude VAT when calculating values.
  • Show Empty Periods: Enable this option to display periods with no item transactions. Disable it to hide them.

Period: #

Choose the reporting interval. Daily results use one row per day; weekly results aggregate each week into one row; monthly results aggregate each month into one row:

(Daily, Monthly, Weekly)

Display Columns: #

The following quantity display options are available:

Quantity Including Free Units: Enable this option to combine the main quantity and free units in one column.

Quantity Only: Enable this option to display the main quantity separately from free units in the 

report.

Free Units Only: Enable this option to display free units separately from the main quantity in the 

report.

TotalEnable this option to display the Total column.

Inventory Valuation Price: Select the pricing method used to value the items in the Total column.

Total Fields: #

Choose which of the following three measures to display:

ReceiptsThe quantity or value of incoming transactions.

IssuesThe quantity or value of outgoing transactions.

BalanceThe difference between receipts and issues.

  • When cumulative values are enabled, each period includes the quantities from preceding periods. For example, if issues are 10 units in the first month and 15 in the second, cumulative issues for the second month are 25 units. The following images illustrate the difference:

The report with Use Cumulative Values disabled

Illustration: total fields

.

The report with Use Cumulative Values disabled

Illustration: total fields

.

Invoice Types: #

Select the required invoice types. Choose only sales invoices to analyze sales transactions, or only purchase invoices to analyze purchases.

Show: #

Use this button to display the report using the selected criteria. 

Print: #

Click this button to print the final report.

Chart: #

Use this button to display the report as a chart.

Close: #

Close the report conditions window.

The following images illustrate the available chart presentation:

Illustration: closing the report

Illustration: closing the report

.

Practical examples of information available from the Item Transaction Analysis report:

  • Monthly analysis of Cotton sales by value during the first six months.
  • Weekly analysis of purchases in the Household Goods category by quantity during the first month.
  • Analysis of Sugar sales quantities during the first six months, showing receipts, issues and balance.
  • Analysis of Cotton sales quantities for the customer Tareq.
  • A chart showing increases and decreases in Cotton sales during a one-month period.

.

See the Invoice Totals report.

Visit 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
Horizontal Item Inventory Report: Options and UsesFree Units Inventory Report: Options and Uses

Powered by BetterDocs

Contents
  • Conditions:
  • Advanced Conditions:
  • Report Type: Two options are available:
  • Currency:
  • Options:
  • Period:
  • Display Columns:
  • Total Fields:
  • 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