Payment Transaction Report
Payment Transaction Report
Payment Transaction Report
Module: Accounting
Overview
Use Payment Transaction Report to list payment transactions, sorted by account branch.
You may generate this report for a specific payment type.
To access this report, select Payment Transaction Report (report #1910) from the main menu of SBN.
The Payment Transaction Report
This window contains two panes: use the upper pane to define the content of the report; use the lower pane to define the job output - how, when, and where you want to print the report.
Note: See Report Parameters Pane for information on the fields in the lower pane, which are the same in every report.
Field Descriptions
The following table describes the fields used in the Payment Transaction Report.
Note: You can use wildcard characters in selected fields. For more information on using wildcards, see Searches.
Field |
Wildcards Accepted |
Description |
Transaction Period |
||
Period
- From |
No |
You may select a range of dates to limit the report to transactions with a payment posted on a date within that range. Select the beginning date of the range. O Select a range of transaction dates or a range of fiscal periods, not both. |
Period
- To |
No |
You may select a range of dates to limit the report to transactions with a payment posted on a date within that range. Select the ending date of the range. O Select a range of transaction dates or a range of fiscal periods, not both. |
Fiscal Period Range |
||
Period
- From |
No |
You may select a range of fiscal months to limit the report to payment transactions that occurred within that range. Select the beginning month/year of the range. O Select a range of transaction dates or a range of fiscal periods, not both. |
Period
- To |
No |
You may select a range of fiscal months to limit the report to payment transactions that occurred within that range. Select the ending month/year of the range. O Select a range of transaction dates or a range of fiscal periods, not both. |
Mask |
||
Transaction Type |
Yes |
You may either select a specific transaction type to limit the report to payment transactions of that type or use the % wildcard to include all transaction types. (This menu originates from program #1586.) |
Exclude |
No |
You may exclude a specific transaction type from the report by selecting the transaction type and then entering a check mark in this box. |
Summary Only |
No |
Enter a check mark in this box to generate a summary version of this report. |
Branch Ranges |
||
Branch |
No |
You may select up to three ranges of branches to limit the report to account branches within the ranges. Select the beginning account branch number of a range. (These menus originate from program #1530.) O If you leave the fields blank, the report includes all account branches in your user profile. O Branch restrictions apply. O This report does not use Installation Branches. |
Branch |
No |
You may select up to three ranges of branches to limit the report to account branches within the ranges. Select the ending account branch number of a range. (These menus originate from program #1530.) O If you leave the fields blank, the report includes all account branches in your user profile. O Branch restrictions apply. O This report does not use Installation Branches. |
Exclude |
No |
You may exclude ranges of account branches from the report by selecting the ranges and then entering a check mark in the corresponding Exclude box. |
Running and Viewing a Report
For information on running and viewing a report, see Common Functions in SBN.
Report Example
The following graphic shows an example of the output of the Payment Transaction Report.
Column Descriptions
The following table describes the columns used in the output of the report.
Column |
Description |
Branch |
Branch ID and name. |
Account |
Account number to which the selected payment was applied. |
Name |
Name of the account holder. |
Inv # |
Invoice number, if payment was posted to an invoice number instead of an account number. |
Check No |
Check number of the payment. |
Amt Paid |
Amount of posted payment. |
Tran Dt |
Date on which payment was posted. |
Type |
Transaction type of the payment. |
Rsn |
Payment reason, if entered with the payment. |
Comment |
Comment on the payment, if entered with the payment. |
Branch Totals |
Displays the following totals for the account branch: l Count of payment transactions for the specified period. l Total amount of payments for the specified period. |
Grand Totals |
Displays the following totals for all account branches: l Count of payment transactions for the specified period. l Total amount of payments for the specified period. |
Button Functions
The following table displays the buttons, describes the shortcut keys, actions, and functionality.
Button |
Name |
Shortcut Key |
Action |
Description |
|
Open fields for recurring/template reports |
alt+f1 |
Open fields for recurring/template reports. |
|
|
Exit without saving |
esc |
Exit without saving changes to selected record. |
|
|
Save Existing Record |
enter |
Save changes to selected record. |
Modifications and Updates to Payment Transaction Report
The following table lists modifications and updates to the Payment Transaction Report document.
Mod Number |
Date |
Description |
n/a |
8/06/14 |
Images updated. |