How to Generate a Customer/Supplier Balance Summary Report Using Note to Account ©

Overview：

Many users have asked if the Customer Aging Report can display only the company name and balance amount without other details. Instead of modifying the aging report, users can achieve this by using the Note to Account Report, which provides the required information in a simplified format.

This guide will walk you through how to generate a Note to Account Report to meet this requirement.

Scenario：

User Request:
"May I know if the customer aging report can have another type that only shows the company name and balance amount?"

Instead of customizing the aging report, users can use the Note to Account Report, which already includes a format that displays only the company name and balance.

This scenario applies when:
✔️ The user needs a simplified aging report with only essential details.
✔️ The user wants to exclude transaction details, invoice numbers, or due dates.
✔️ The user prefers a quick and easy solution without additional customization.

Solution：

Step 1 - Expand Reporting > Press Report Center > In General Ledger Tab, Expand Note to Account > then Press Note To Accounts.

Step 2 - After Access into Note to Account report, user can filter Trade Debtors for Customer Balance Summary, or Filter Trade Creditors for Creditor Balance Summary > then Press Preview.

Result

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software