Is there any way to delete or reverse balance carryforward data in period 0

[Former Member]

Dear all,

Is there any way we can delete or reverse balance carryforward data in period 0?

We have try to use the delete function in UCWB, but we can't select the period 0 in the selection screen.What's the correct way of deleting the balance carryforward data?

Thx,

Jeff

[dan_sullivan · Accepted solution]

I concur with Eugene and have a few other ways, albeit not a simple.

You can use the delete feature in the BCS workbench (UCWB > Consolidation Functions > Other Functions > Delete > Reported data and Documents) to zero out the data for the final period, and reexecute the tasks for the final period. Then execute all task for the final period to zero records. Then execute balance carry forward. This does make all period 000 records zero, but the records will still exist.

Or, you can use a flexible upload data collection method to cumulative, delete all and execute with no data in the file for the final period. Then execute all task for the final period to zero records. Then execute balance carry forward. This does make all period 000 records zero, but the records will still exist.

[Former Member]

Hi,

Even if you were able to select the priod 000, you'll not be able to delete all data, because they might be in different posting levels.

So, the rudest and the most dangerous, but effective way is a physical selective deletion from the totals cube.

The most safe way is the inversion of documents in the last posting period of the prev year, deletion of the RFD (if needed), making all the necessary changes, rerun of the consolidation tasks and BCF again.