How to Customize Transaction Report Format: Summing Item Discounts in the Footer and Displaying Total Discount Amount ©

Overview:

This guide provides step-by-step instructions on how to customize your transaction report format, specifically focusing on summing the item discounts in the footer section. Additionally, it covers how to display the total discount amount at the end of the report for better clarity and comprehensive reporting. Whether you're working with accounting software, ERP systems, or custom reporting tools, these instructions will help you modify the report to better reflect discounts and enhance your financial overview.

Solution :

Step 1 - Please learn How to Access Report Designer .

Step 2 - In Report Designer Footer already prepared Table, user can change the Wording 

Double Click the Taxable Amount, Change to Subtotal

Before

After

For Column Below Subtotal, Press the Expression Editor Button

Remove the Expression.

Before

After, the Press Apply and OK

Then Double Click the Tax Wording, change to Discount Amount

Before

After

Step 3 - Now, Press Fields > Look for Subtotal > Drag it to the column.

Step 4 - Then look for DiscountTotalAmountLocal field > Drag to the Column.

Step 5 - Press Menu > Press Save.

Result

Step 6 - Please Learn How to Default a format .

OR
Learn How to Use the Default e-Invoice Format Feature for Sales and Purchase Transactions in QNE AI Cloud Accounting ©

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software