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
  • Invoice Line Profit Report

Invoice Line Profit Report

This report displays gross and net profits from individual invoice lines. Choose Reports > Invoice Line Profits to open the conditions window with these fields:

Illustration: invoice line profits

.

Conditions: #

  • Branch: Select the branch whose invoice lines should be displayed.
  • Warehouse: Select the warehouse whose invoice lines should be displayed.
  • From Date / To Date: Specify the report date range.
  • Payment Method: Select a payment method to display invoice lines using it.
  • Sales Representative: Select a representative to display the invoice lines sold by that representative and their profits.
  • Cost Center: Select a cost center to display invoice lines recorded for it.
  • Customer Account: Select a customer account to display invoice lines carrying it in Customer Account.
  • Customer: Select a customer to display invoice lines carrying that customer account.
  • Units: Choose the item unit to display, such as Piece as the first unit or Dozen as the second.
  • Profitable / Loss-Making Invoices: Choices include All, Profitable Only, Loss-Making Only and Break-Even.
  • Description Contains / Does Not Contain: Enter text to include or exclude invoice lines according to the invoice description.

Advanced Conditions: #

  • Advanced Invoice Conditions: Specify advanced conditions, explained in the Detailed Invoice Transactions guide. Two condition groups are available:
  1. Line conditions, such as size or color.
  2. Invoice conditions, such as invoice type or currency.
  • Advanced Customer Conditions: Advanced customer conditions use information from the customer record. 
  • Advanced Audit Conditions: Specify audit conditions, such as invoices added or modified by a particular user.

Item Conditions: #

  • Item: Select the item to display.
  • Item Category: Select the item category to display.
  • Advanced Item Conditions: Advanced item conditions use information from the item record. For example, to filter by origin, open Item Conditions, select Origin, choose Equals and enter the required origin. Save the condition to place it in Advanced Item Conditions.
  • Currency and Exchange Rate: Select the report currency and its exchange rate relative to the base currency.

Options: #

The options section contains:

  • Show Sequence Number: Display sequential report row numbers.
  • Finalized Invoices: Include finalized invoices.
  • Unfinalized Invoices: Include unfinalized invoices.
  • Show Profit as a Percentage of Line Total: Display line net profit divided by the line total.
  • Show Profit as a Percentage of Line Net Total: Display line net profit divided by the line net total.
  • Show Profit as a Percentage of Line Cost: Display line net profit divided by line cost.

Group Results By: #

Group results using one of the following choices:

Time Grouping: None, Daily, Weekly, Monthly or Quarterly.

Invoice Direction: Incoming / Outgoing

  • Invoice Type
  • Representative
  • Payment Method
  • Customer
  • Warehouse
  • Branch
  • Item
  • Item Category

Show Line Count: #

Add a field showing the number of lines in each group.

Break down report totals by invoice type. #

  • Invoice Fields: Fields describing invoice information, such as invoice date and the warehouse from which items were issued.
  • Item Fields: Fields from the item record, such as barcode or volume.
  • Invoice Line Fields: Fields from invoice lines, such as discount and its percentage, surcharge and its percentage, total, net total and quantity.

Invoice Types: #

Only invoice types that affect profits appear in the type selection. More than one type may affect profits.

Illustration: invoice types

.

See: 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.

Examples of Information Available from the Invoice Line Profit Report:

  • Profits for invoice items showing each line total, net total, item cost, gross profit, net profit and other selected fields.
  • Profits for invoice items sold by representative Imad.
  • Profits for items sold to customer Hossam.
  • Profits for items sold for cash.
  • Invoice line profits with percentages relative to total, net total and cost.
  • Profits for items sold for cash during the first month whose Mr./Recipient field contains Ahmad.

.

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
Inactive Items Report: Options and UsesMost Profitable Items Report

Powered by BetterDocs

Contents
  • Conditions:
  • Advanced Conditions:
  • Item Conditions:
  • Options:
  • Group Results By:
  • Show Line Count:
  • Break down report totals by invoice type.
  • 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