Date Options

The Report Summarization process uses the calendar that is specified in the Reporting Roll Up Calendars group box on the Installation Options - Project Costing page. Additionally, it uses the 01/01/1900 date as a wildcard value. For example, if you use a date option of Accounting Date, the transaction date in the Project Transaction table is irrelevant. Therefore, the system assigns the wildcard value of 01/01/1900 to the field.

This table shows an example of the rules that the Report Summarization process uses to assign accounting and transaction dates. Assume that the accounting date and transaction date are 09/10/2005:

Date Option Reporting Interval Transaction Date in PC_RPO Accounting Date in PC_RPO

Accounting Date

Daily

01/01/1900

09/10/2005

Accounting Date

Monthly

01/01/1900

09/30/2005

Accounting Date

Quarterly

01/01/1900

10/31/2005

Accounting Date

Yearly

01/01/1900

12/31/2005

Transaction Date

Daily

09/10/2005

01/01/1900

Transaction Date

Monthly

09/30/2005

01/01/1900

Transaction Date

Quarterly

10/31/2005

01/01/1900

Transaction Date

Yearly

12/31/2005

01/01/1900

All

Inception

01/01/1900

01/01/1900