AP Aging Report window: Report Options tab
Use the fields and options on this tab to define your criteria for this report.
Sort By
Specify if you want to sort the report by vendor number, vendor name, or product type.
The
Sort By drop-down also shows any User-Defined Fields (UDF) you set up in the
AP Module Preferences window. If you select one of the UDFs, new Start and End Range boxes will appear below the existing Start and End Range boxes so you can choose the range of values in the UDF to appear in the report.
Page Break on Vendor Number, Vendor Name, Product Type, or User-Defined Field
Select this check box if you want to begin a new page for each new item you selected in the Sort By box.
Report Type
Use this drop-down list to select the level and amount of detailed information you want to see in the report. You have five options:
• Detailed: this report contains detailed transaction information. It shows the highest level of detail out of the reports.
• Condensed: the condensed report contains aging information by vendor and by transaction, but not to the transaction detail line level.
• Summary: The summary report contains only aging totals by vendor, with no transaction information.
• Single Line: this option contains the same level of detail as the summary option, but the vendor’s information is condensed vertically so it can be reported on one line, potentially saving paper and other resources.
• Detailed with Notes: this option contains the same level of detail as the detailed report, but it also includes any notes you have entered about the vendor.
Vendor Status
From the drop-down, select which vendors you want to include based on their status.
• All Vendors: this option includes every vendor in your company in the list.
• Active Vendors: this option includes only vendors with a status of active in the
AP Vendors window.
• Inactive Vendors: this option includes only vendors with a status of inactive in the AP Vendors window.
• Temporary Vendors: this option includes only vendors with a status of temporary in the AP Vendors window.
Transaction Type
Use the drop-down list to select the type(s) of transactions you want to include in the report.
• All Transactions: this option includes all transactions for the vendor(s) you select for this report.
• Invoice: this option includes only invoices for the vendor(s) you select.
• Credit Adjustment: this option includes only credit adjustments for the vendor(s) you select.
• Payment Correction: this option only includes payment corrections for the vendor(s) you select.
• Payment Correction - Credit Card: this option only includes credit card payment corrections for the vendor(s) you select.
• Payment: this option includes payments for the vendor(s) you select.
• Payment - Credit Card: this option only includes credit card payments for the vendor(s) you select.
• Debit Adjustment: this option includes debit adjustments for the vendor(s) you select.
• Unapplied Debit: this option includes only unapplied debits for the vendor(s) you select.
• Debit Invoice: this option only includes debit invoices for the vendor(s) you select.
Age by Due Date
Select this option to specify if you want the information to appear as if it is aged by the invoice due date. The system will compare the system date to the due date and assign the invoices to aging periods according to the length of time between the system date and the due date. The aging periods are determined by the
AP Code attached to the vendor.
Age by Invoice Date
Select this option to specify if you want the information to appear as if it is aged by the invoice date. The system will compare the system date to the invoice date and assign the invoices to aging periods according to the length of time between the system date and the invoice date. The aging periods are determined by the AP Code attached to the vendor.
Additional Filter
If you defined User-Defined Fields in the
AP Module Preferences window, they will be available here as an additional filter for the report.
Start and End Ranges: Vendor Number, Vendor Name, Product Type, Due Date/Trans Date, Period, Vendor Total Due, Item Amt Remaining, AP Code, and User-Defined Field (if selected as Additional Filter)
Use these ranges to specify the vendors and/or items to include in the report. Leave the defaults of Start and End to include all values for a particular range, or use the Lookup where applicable to enter the starting and/or ending value to include.
Date Range
From the drop-down, select a
predefined period to run the report for.
Exclude Zero Check Box (Vendor Total Due Range)
Select this check box if you want the report to exclude vendors to whom your total amount due is zero. If you select this check box and leave the values of Start and End, then vendors that have either a debit or credit balance will appear, but those that have a zero balance will not. Use the Start and End range to further define the total due range you want to include.
Exclude Zero Check Box (Item Amt Remaining Range)
Select this check box if you want the report to exclude transactions that have an amount remaining of zero. If you select this check box and leave the values of Start and End, then only transactions that still have an amount remaining will appear. Use the Start and End range to further define the Item Amt Remaining range you want to include. For example, if you only want to include transactions on which you owed money, you could quickly type 0 in the Start box, and select the Exclude Zero check box.
Group by AP Code
This option is only available if you have more than one AP Code set up. Select this check box if you want to group your vendors by
AP Code.
Use a custom report
This check box is only available if you
defined a custom report for this window in Controller. Select this check box if you want to run a custom report instead of the default report. The drop-down is enabled after you select the check box and you can choose the custom report you want to run.
Related Topics
Published date: 12/03/2021