Expense Payables Report
The Expense Payables Report is comprehensive, showing all open (due) and closed (paid) expense payables. The report includes aging totals for each vendor's open items (using 30-day aging periods).
Note: GlobalWare associates general ledger items for expense payables with the general ledger chart specified in the Accrued Payables field on the System Control screen's System tab (usually chart 2120). For more information, see System Tab.
Running the Report
To run the report:
-
On the A/P submenu, click Expense Payables Report.
The Expense Payables Report dialog box appears.
Field descriptions
The following table describes the fields on the Expense Payables Report dialog box.
Field Description Branch
Branch. The report will include expense payables for this branch only.
To find and select a branch, click the lookup (
) button. The Find Branch screen appears. For details, see Using the Lookup Buttons and Screens.Vendor ID
Vendor account ID. Specify a full account ID to include information for this account ID only.
You can also specify @TAGGED to include information for tagged vendor accounts only.
Leave this field blank to include information for all vendors.
To find and select a vendor account ID, click the lookup (
) button. The Find an Account ID screen appears. For details, see Using the Lookup Buttons and Screens.Status
Expense payables status. The report will include expense payables with this status only. Select one of the following options from the drop-down list:
- All – All expense payables, regardless of status.
- Closed – Closed expense payables only.
- Open – Open expense payables only.
From (for due date)
Beginning date of a range of dates. This date is the accounts payable due date. However, if an expense payable does not have an accounts payable due date, such as when a general ledger check is posted to the accrued payables chart, GlobalWare uses the general ledger post date. Expense payables within the specified range of dates will be included on the report. Use this date in conjunction with the To date to define a range.
To (for due date)
Ending date of a range of dates. Even though defining a range of dates is not required, this date is required. This date is the accounts payable due date. However, if an expense payable does not have an accounts payable due date, such as when a general ledger check is posted to the accrued payables chart, GlobalWare uses the general ledger post date. Expense payables within the specified range of dates will be included on the report. Use this date in conjunction with the From date to define a range.
Subtotal by Branch
Indicates whether to sort and subtotal the report by branch and then vendor account ID (reference 2). Detail is sorted by accounts payable due date, then chart, then control number, and finally sequence number.
Page Break by Branch
Indicates whether to start each branch on a new page. This option is available only if Subtotal by Branch is selected.
Include Offsets
Indicates whether to include the complete journal entry. If not selected, the report will include only the expense payable items (excludes offsets).
If you include offsets, all items in the general ledger control are included, regardless of whether they are actually offsets for the expense payable. For example, if you include provider, customer, and vendor items in one check batch, the provider and customer checks appear on the Expense Payables Report if you include offsets.
-
Complete the fields as appropriate.
Note: The To date for Due Date is required.
- Choose one of the following print options:
To print the report immediately, click PRINT.
The Send to dialog box appears. Select a report destination. For more information, see Printing Overview.
To store the report as part of a batch for printing later, click BATCH.
The Choose a Batch dialog box appears. For more information, see Batch Printing.
Report Example
Expense Payables Report example
