...
Executing a Period Roll Over aged used to age out all completely allocated transactions regardless of the Period Rollover Date entered.
Solution
| Warning | ||
|---|---|---|
| ||
A working knowledge of SQL Management Studio is required to complete this task |
The attached SQL script changes the Period Roll Over process so that only transactions with an Allocation Date on or before the date entered will be aged out. Period balances are updated according to the system date, not the Period Rollover Date.
...
- system date =
- Period Roll Over Date = 31 Oct
- roll over process will only age out transactions with an Allocation date of 31 October or earlier
- period balances are updated based on system date not Period Roll Over date
...