Receivable Statement (Report)

The Receivable Statement report is a listing of unpaid bills selected and organized by Project or Client. A Receivable Statement report is generated as follows:

Client: when the Receivable Statement field is selected for a client (Client - Bill Routings).
Project: when the Receivable Statement field is selected for a client (Client - Bill Routings) and when the Receivable Statement field is selected for a project (Project - Bill Terms).

The report includes a list of bills with outstanding balances, the potential financial charges, the total amount due, and an aging analysis of the outstanding invoice amounts. Additional remittance information can also be included on the report; For more information, see Bill Remit Routing. - Sample Report.

General

This General area provides options to configure the report.

Field		Description
	Comment	Enter any comments about the report instance. Comments will display on the report console and the banner page of the report.

Restrictions

The report includes the following default restrictions:

Field		Description
	To Posting Period	Enter or select a posting period. This is the last date in the date range to include open items. This field defaults to the current posting period.
	Statement Format	Select if the report should be organizable by Project or Client. By default, Client is selected.
	Statement Date	Enter or select the statement date to use on the report. The statement date is also used as reference aging date on the report. This defaults to the current date.
	Aging Categories	There are four aging categories period (1, 2, 3, 4) for this report. Adjust the length of the aging category spread, as needed. These fields default to 30, 60, 90, and 120.
	Date Format	Select the date format to use on the report. By default, None is selected and the report uses the Bill Term Client Bill Routing Date Format.
	Include Banner	Select to generate the banner page on the report. By default, this field is set to generate the banner page.
	Include Image	Select to include an image that identifies the report as Receivable Statement by Project. The image will print in the upper right corner of the Statement report.
	Include Currency Code	Select to include currency code information on the report.
	Include Client Terms	Select to include client terms information on the report.
	Include Retainage	Select to include retainage information on the report. When selected, the related account must have the Retainage flag selected or the retainage amount will display on the report; for more information, see Account.
	Include Remit Logo	Select to include the Bill Remit Routing Logo on report. The logo will print in the upper left corner of the Statement report.
	Include Remittance	Select to include the Bill Remit Routing Image on report. The image will print at the bottom of the last cover page of the Statement report. If no image is available, the remittance address is presented.
	Bill Client	Enter or select one or more bill clients.

The report includes the following optional restrictions:

Note:The project company and organization are based on the Owning Organization for the project.

Account
Bill Client Parent
Bill Client Type
Bill Cycle
Bill Remit Routing
Bill Term
Bill Term Client
Bill Term Contract
Biller
Invoice Date

Project
Project Business Unit
Project Client
Project Client Parent
Project Company
Project Organization
Project Service Line
Project Status
Project Work Type

Sorts

The report includes the following sorts:

Note:The project company and organization are based on the Owning Organization for the project..

Bill Cycle Code
Bill Cycle Name
Bill Term Contract Name
Bill Term Contract Code
Biller Code

Biller Name
Project Company Code
Project Company Name
Project Organization Code
Project Organization Name