Subledger Report
Contents
Overview of FW53
The Subledger report provides detail for GL, A/P Vouchers, Misc. Receipts and Connect-FR transactions. The report allows you to customize the columns and data that appear, and can include information such as the GL account, description, transaction date, amount, debit or credit amount, reference, memo, payee ID and/or name, and other data. To run the report:
- From the DDI Connect main menu, double-click FundWriter
- Double-click FundWriter Reports
- Double-click 53 Subledger Report. The parameters screen will launch:
There are three tabs on the parameters screen, each with options for customizing the report.
Criteria Tab
The following fields are available on the Criteria tab:
| Field | Description |
|---|---|
| Date range/thru | Enter the date range that you wish to report against. You can type the dates in mm/dd/yyyy format or click the calendar icons to select the dates |
| Subledger sources | Select the sources that you wish to include on the report |
| Exclude transactions with no payee | If selected, transactions without a payee will be excluded from the report |
| Exclude transactions with no subledger information | If you wish to exclude transactions with no subledger information, select this box |
| Vendor ID (vouchers) | If you wish to run the report for only a particular vendor ID, you can do so here. Type the vendor ID or click the list icon to select from a list of vendors in the system. Leave this field blank to report against all vendor IDs |
| Constituent PIN (misc receipts) | If you wish to run the report for only a particular constituent PIN, you can do so here. Type the PIN or click the list icon to select from a list of FW constituents in the system. Leave this field blank to report against all FW Constituent PINs |
| Payee name (any source) | If you wish to run the report for only a particular payee name, you can do so here by typing the Payee name. Leave this field blank to report against all payees |
| Reference | If you wish to run the report for only a particular reference, you can do so here by typing the reference text. Leave this field blank to report against all references |
| Memo | If you wish to include only those transactions with a specific memo, you can do so here by typing part of the memo. For example, if you type ABC, transaction memos containing the text "ABC" anywhere in the memo will be included. If you type ABC+DEF, transaction memos containing the text ABC and the text DEF will be included. And, if you type ABC,DEF in the field, transaction memos containing the text ABC and/or the text DEF will be included. Leave the field blank to report on all transaction memos |
| Report layout | At this time, custom is the only selection for Report layout |
| Double space report | If you want to double-space the report output, select this box. Leave it unselected to leave the default single space layout |
Click the G/L Segments tab.
G/L Segments Tab
If your organization has multiple entities, you can click the Entity button to select the entity that you wish to report against.
If you wish to run the report for specific segments, you can do so here. Enter the segment information that you wish to report on. Leave all fields blank to run for all. If you wish to run for a specific GL account, click the GL account button to search for the account. Click Clear to remove your selections and return all segment fields to blank state
Click the Custom Format tab.
Custom Format Tab
The following fields are available on this screen:
| Field | Description |
|---|---|
| Available Columns | The Available Columns lists all of the fields available to you for the report output. To select a field for your report, you can either double-click it to move it to the Selected Columns area, or click once and then click the --> arrow |
| Selected Columns | The Selected Columns lists all fields you have selected. To remove a field from the Selected Columns area, double click it or click once to highlight and then click the <-- arrow |
| Move Up | To move a field up in the column order, click once to highlight and then click the Move Up button until it is placed where you wish it to be |
| Move Down | To move a field down in the column order, click once to highlight and then click the Move Down button until it is placed where you wish it to be |
| Report title | If you would like, you can enter a custom report title here |
| Group by | Click the drop down arrow to select how you would like your report to be grouped |
| Sort by | Click the drop down arrow to select the primary sort order. Selecting a sort will enable a secondary sort field, which you can use if desired. If you select a secondary sort, a third sort order will enable. Each sort level will also allow you to subtotal by that level, if desired |
| Summary report - no transaction details | If selected, the system will generate a summary version of the report, without the transaction details |
Print Options
After clicking the Print Options button you will see the following options. Choose the desired options and click OK to return to the report parameters screen.
| Option | Description |
|---|---|
| Printer | Click the drop down arrow to select from a list of available printers. DDI Connect uses your default printer unless told otherwise |
| Format | Click the drop down arrow to select from a list of available formats. Select paper size, number of columns, and number of rows for printing. Each report has built-in format defaults. Select “Use Defaults” to use the built-in report defaults. The number of rows and columns controls the print size and amount of information per page |
| Memo | If you wish, you can add a memo to the output of the report. NOTE: It is recommended that Word documents be saved with the .docx extension |
| View Report | This option generates a pdf file that is displayed on the screen when the report is generated |
| Archive Report | If this option is selected, the system will archive the report in the DDI Connect report archives. For information on working with archived reports, please reference this page: Archived Report Viewer |
| Print Report | If selected, the system will generate the report output to your default printer. NOTE: You will also receive a pdf version of the report, displayed on your screen |
| Print via PDF | Prints directly to your printer. |
| This option allows you to send a .pdf attachment of the report to the indicated users' email addresses. When OK is clicked, a dialog box will open requesting a recipient | |
| Duplex/Top | Prints the report on both sides of the paper in landscape style. The printer must be capable of printing on both sides or an error will occur |
| Duplex/Side | Prints the report on both sides of the paper in portrait style. The printer must be capable of printing on both sides or an error will occur |
| Green bar | Adds shaded, horizontal bars to the report, making it easier to read across columns |
| No dialog | Selecting this option means that no ‘Report Completed’ dialog will display after the report has been generated |
| Extra copies | If you want extra copies of the report generated, type the number in this field |
Click Start. The system will generate the report based on the parameters you selected, and display the results. Click below to view a sample of this report.
