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
  • Accounting Reports
  • Most Active Customers Report

Most Active Customers Report

This statistical report summarizes customer transactions and ranks customers in descending order of activity. Flexible settings provide reports on the highest sales by value, quantity or invoice count, customers with the most returns, suppliers with the highest purchase activity, and similar measures.

Choose Most Active Customers from Reports / Statistical Accounting Reports to open the following criteria window:

Illustration: Most Active Customers report

.

Conditions: #

  • Parent Account: Select a parent account, such as Customers or Suppliers.
  • Item: Select an item to rank customers based only on transactions involving that item.
  • Item Category: Select an item category to rank customers based only on that category.
  • Branch: Select a branch to include only invoices issued in its warehouses.
  • Warehouse: Select a warehouse to include only invoices issued in that warehouse.
  • Cost Center: Select a cost center to include invoices involving that cost center.
  • From Date / To Date: Specify the report date range.
  • 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.

Calculation Method: #

Three calculation methods are available:

  1. Incoming Positive / Outgoing Positive: Add the results of receipt and issue invoices, combining transactions that increase and decrease quantities.
  2. Incoming Positive / Outgoing Negative: Subtract issue invoice results from receipt invoice results, subtracting quantity decreases from quantity increases..
  3. Outgoing Positive / Incoming Negative: Subtract receipt invoice results from issue invoice results, subtracting quantity increases from quantity decreases.

Advanced Customer FiltersSet filters using customer record fields, such as name, mobile number, telephone number or city. Only matching customers are included.

0179- P-175

.

  • Advanced Item Conditions: Use item record fields to filter the items included in the report. For example, to rank customers for items with size M, set an advanced filter where Size equals M.
  • Advanced Invoice Conditions: Set advanced invoice filters based on invoice fields, such as payment method or date. Only matching invoices are included.
  • Number of Customers: Set the number of customers to display. Entering 10 displays the ten most active customers.

Sort By: #

Choose the ranking criterion: Total Quantity, Invoice Count or Total Value.

Currency: #

Select the currency in which the report should be displayed.

Exchange Rate: Specify the exchange rate relative to the base currency. This 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: This option uses the rate from the exchange rate table instead of the rate recorded in the original transaction.

Options: #

The options section contains:

  • Show Sequence Number: Enable this option to display a sequential number for each customer in the report.
  • Finalized Invoices: Enable this option to include finalized invoices.
  • Unfinalized Invoices: Enable this option to include invoices that have not yet been finalized.
  • Show Account Code: Enable this option to display the customer account code.
  • Show Account: Enable this option to display the customer account.
  • Show Total Quantity: Enable this option to display the total quantity of items on customer invoices.
  • Show Invoice Count: Enable this option to display the number of invoices.
  • Show Total Value: Enable this option to display the total value of items on customer invoices.
  • Combine Account Code and Name: Enable this option to combine the customer account code and name in one field.
  • Hide Inactive Customers: Enable this option to hide customers with no transactions in the invoice types selected for the report.
  • Show the Customer’s Last Transaction:

Transaction Type: #

The invoice type of the customer’s most recent transaction: sale, purchase, sales return or purchase return.

Transaction Date: Displays The date of the customer’s most recent transaction.

Transaction Value: Displays The value of the customer’s most recent transaction.

Customer Fields:

Use this section to display details from the customer record, such as telephone, fax, mobile number or city.

Invoice Types:

Select invoice types in the Invoices section. Choose sales invoices to rank customers by sales activity, or purchase invoices to rank suppliers by purchases.

  • Show: Display the report.
  • Print: Print the report.
  • Chart: Display report information as a chart.
  • Close: Close the report.

The following image shows an example of the Most Active Customers report:

Illustration: transaction type

.

Important Note:

This is a statistical report rather than an inventory balance report. Interpret the results according to the selected calculation method.

Practical examples of information available from the Most Active Customers report:

  • The top ten customers by sales quantity, value or invoice count.
  • The top ten suppliers by purchase value, invoice count or quantity.
  • The top ten customers based on wholesale sales invoices.
  • The top ten customers based on finalized invoices, unfinalized invoices or both.
  • The customers with the highest sales during the first three months or another specified period.
  • The customers with the highest sales within a specified parent account.
  • The customers with the highest sales for a particular item.
  • The customers with the highest sales for a particular item category.
  • The customers with the highest sales for a particular branch, based only on its warehouse transactions.
  • The customers with the highest sales for a particular warehouse, based only on its transactions.

.

See the Define Customer Records 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
Trial Balance Report in Al MizanInactive Customers Report in Al Mizan

Powered by BetterDocs

Contents
  • Conditions:
  • Calculation Method:
  • Sort By:
  • Currency:
  • Options:
  • Transaction Type:
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