This chapter contains this topic:
The Summarize Transactions program (P09811) has one, two-character processing option to define the periods to retain when summarizing F0911 records. When you submit the Dream Writer, the system uses the fourteen Net Posting fields from the Account Balances file (F0902), to determine which periods to retain in detail.
Note:
The system uses 14 periods, even if periods 12 thru 14 have the same ending date.How you determine the value to place in the processing option is based on your date pattern.
To Determine the Processing Option for a Calendar Year Date Pattern
Use the sum of the periods for each full year (14) not to include in the summation plus the periods in the partial year.
For example:
Assume it is 2017. Company 100 is on a calendar year date pattern and the current period listed in the Company Constants (F0010) is February 2017. You need to summarize all F0911 records prior to 2015.
Fiscal Date Pattern Code - R
Fiscal Year Beginning - Date & Century. - 01/01/17 21
Date Pattern Type.
| Period | Date & Century |
|---|---|
| 01 | 01/31/17 21 |
| 02 | 02/28/17 21 |
| 03 | 03/31/17 21 |
| 04 | 04/30/17 21 |
| 05 | 05/31/17 21 |
| 06 | 06/30/17 21 |
| 07 | 07/31/17 21 |
| 08 | 08/31/17 21 |
| 09 | 09/30/17 21 |
| 10 | 10/31/17 21 |
| 11 | 11/30/17 21 |
| 12 | 12/31/17 21 |
| 13 | 12/31/17 21 |
| 14 | 12/31/17 21 |
Populate processing option 1 with '30'; the sum of the 14 periods for each remaining full year (2015 and 2016), plus the two periods from 2017. (14+14+2 = 30)
To Determine the Processing Option for a Fiscal Year Date Pattern
Use the sum of the periods for each full year (14) not to include in the summation plus the periods in the partial year.
For example:
Company 500 is on a fiscal year date pattern and the current period listed in the Company Constants (F0010) is March 2017. You need to summarize all F0911 records prior to 2014.
Fiscal Date Pattern Code - F
Fiscal Year Beginning - Date & Century - 07/01/16 21
Date Pattern Type.
| Period | Date & Century |
|---|---|
| 01 | 07/31/16 21 |
| 02 | 08/31/16 21 |
| 03 | 09/30/16 21 |
| 04 | 10/31/16 21 |
| 05 | 11/30/16 21 |
| 06 | 12/31/16 21 |
| 07 | 01/31/17 21 |
| 08 | 02/28/17 21 |
| 09 | 03/31/17 21 |
| 10 | 04/30/17 21 |
| 11 | 05/31/17 21 |
| 12 | 06/30/17 21 |
| 13 | 06/30/17 21 |
| 14 | 06/30/17 21 |
Populate processing option 1 with '37'; the sum of the 14 periods for each remaining full year (2014 and 2015), plus the nine periods from 2016. (14+14+9 = 37)