/
Cost Center Purge/Balance Forward RR210

Cost Center Purge/Balance Forward RR210

Search the IFS Excalibur Wiki
 

This program allows you to purge data from the COST_CENTER_DETAIL and COST_CENTER_ACTIVITY files. You can select the fiscal date and activity date to purge through. In the COST_CENTER_DETAIL file, the system accumulates a balance forward total for each individual volume and dollar amount (budgets as well as actuals) for all dates prior to the fiscal date input. The system then deletes the individual figures and replaces them with the fiscal date input and the balance forward totals accumulated. An identical procedure takes place in the COST_CENTER_ACTIVITY file using the activity date input. In this way, the files are kept to a manageable size by rolling old data forward. Individual reports print for each file showing the purged data and the items data was not purged from.

We strongly suggest that you only purge through the end of the year prior to the previous fiscal year so that one year of historical data is available for reporting purposes.











Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.