Skip to end of metadata
Go to start of metadata

Problem

Executing a Period Roll Over used to age out all completely allocated transactions regardless of the Period Rollover Date entered.

Solution

SQL skills required

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 before the date entered will be aged out. 


Example

  • system date =
  • Period Roll Over Date =
  • roll over process will only age out transactions with an Allocation date of 31 October or earlier

Download and apply the attached script to the database - 7.00.175 and 7.02.01 databases

usp_JIWA_Debtor_PeriodRollover.sqlDEV-7608_usp_JIWA_Creditor_Recalc_Balances.sql

In addition, if this solution causes rollover to become noticeably slower, the following script will speed up the process.

DebtorPeriodRolloverAdditionalIndexes.sql

Note: Period numbers on the Transaction tab in debtor maintenance are dynamic and always reflect the login date not the Period Rollover Date.

DEV-8551 - Getting issue details... STATUS

DEV-7884 - Getting issue details... STATUS