Debtor Listing Report
Debtor Listing Report
Debtor Listing Report
Module: Accounting
Overview
Use the Debtor Listing Report to list debts by billing account.
To access this report, select Debtor Listing Report (report #1182) from the main menu of SBN.
The Debtor Listing Report
This window contains two panes: use the upper pane to define the contents of the report; use the lower pane to define the job output - how, when, and where you want the report printed.
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 upper pane of this report.
Field |
Description |
Include Details |
Enter a check mark in this box to include invoice details in the report. |
Minimum Account Balance |
You may type a minimum account balance to limit the report to invoices with a balance that is equal to or greater than the minimum. |
For Period |
|
Date
- From |
You may select a range of dates to limit the report to invoices with a transaction date within the range. Select the beginning date of the range. |
Date
- To |
You may select a range of dates to limit the report to invoices with a transaction date within the range. Select the ending date of the range. |
Invoice Detail Period |
|
Date
- From |
You must select a range of due dates to limit the report to invoices with a due date within the range. Select the beginning due date of the range. |
Date
- To |
You must select a range of due dates to limit the report to invoices with a due date within the range. Select the ending due date of the range. |
Branch Range |
|
Branch |
You may select up to three ranges of branches to limit the report to branches within the ranges. Select the beginning branch number of the range. (These menus originate from program #1530.) O If option rptprof is on, SBN limits report results to those within the user’s branch profile. |
Branch |
You may select up to three ranges of branches to limit the report to branches within the ranges. Select the ending branch number of the range. (These menus originate from program #1530.) |
Exclude |
You may exclude ranges of branches from the report by selecting the ranges of branches and then entering check marks in these fields. |
Sort By |
You must select a grouping parameter for the report: l Branch l Dealer l None |
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 Debtor Listing Report.
Column Descriptions
The following table describes the columns used in the output of the report.
Column |
Description |
Account |
Account number to which the invoice applies. |
Name |
Account name. |
Invoice |
Displays invoice number and total due l Debt before/on the following due date l Debt on/after the following due date |
Due Date |
Date on which payment for the invoice is due. |
Amount |
Amount of invoice. |
Balance |
Balance due on invoice. |
Invoices Count |
Number of invoices for the selected account. |
Branch Totals |
|
Before Period |
The total due before the following due date, for the branch. |
In Period |
The total due during the selected billing period, for the branch. |
After Period |
The total due after the selected billing period, for the branch. |
Grand Totals |
|
Before Period |
The total due before the following due date, for all branches. |
In Period |
The total due during the selected billing period, for all branches. |
After Period |
The total due after the selected billing period, for all branches. |
Modifications and Updates to Debtor Listing Report
The following table lists modifications and updates to the Debtor Listing Report document.
Mod Number |
Date |
Description |
n/a |
8/04/14 |
Images updated. |