Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.  Period balances are updated according to the system date, not the Period Rollover Date.


Example

  • system date =
  • Period Roll Over Date =
  • roll over process will only age out transactions with an Allocation date of 31 October or earlierperiod balances are updated based on system date not Period Roll Over date

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

...

View file
nameDebtorPeriodRolloverAdditionalIndexes.sql
height250

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

Filter by label (Content by label)
showLabelsfalse
max5
spacesJ7UG
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("allocation","allocations","period_roll-over","aging","period_rollover","debtors") and type = "page" and space = "J7UG"
labelsperiod_roll-over period_rollover debtors aging allocation allocations

...