The ability to display the Grand Total Amount in some reports including A/R Payment History by Payment and A/R Payment History by Invoice is currently logged under Enhancement Request #69993.
As an alternate solution, users can customize the A/R Register report instead to determine how much total payment is received for a specific period. The following are the detailed steps:
1. Navigate to Reports > Customer/Receivables > A/R Register > Customize (Administrator).
2. In the Report Builder page, name the report and do the following:
Edit Columns section:
-Add Grand Total box must be checked under the Amount Chrg/Amt Paid column.
-Group by Customer Name.
-Remove any unnecessary report columns.
-Add any other needed report columns.
Filters section:
-Set preferred date range.
3. Preview/Save the custom report. The Amt Paid column returns the total payment received for a specific period.
NOTE: Users can further customize the report to add any other filters such as Transaction Type, depending on one's specific requirement.
No comments:
Post a Comment