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 |