How to delete Store Period Performance?

Rifky,
Once the Store Period performance is run and Financial dates are already used you cannot delete defined financial period. The only way to delete these records is using the external API like SDK or ODBC.
There are Five tables associated with these records.
-> FINDATE table – where define financial date is recorded.
-> TASKFIN table – where all store Performance period for task is recorded
-> TRSRCFIN table – where all resource assignment performance period is recorded
If summarized function is run it all record the summary on the 2 tables
-> TASKSUMFIN – where summary store Performance period is recorded
-> TRSRCSUMFN – where summary resource assignment performance period is recorded.

You need to delete all records recorded on TASKFIN and TRSCFIN tables before you can delete all date define on FINDATE tables. If summarize is run then the other two table also need to clean the records.

Just confused why you need to delete the defined financial period and re-create a new one? If those period define is not used it won’t affect your project. It will show only those financial period used.

Rodel,

The reason is because the current financial period in P6 is by Monthly, whereas I want to change it into Weekly. So far, I never run Store Period Performance after updating the progress. Maybe that’s the reason why the distribution of the Actual Labor Units from the previous month is changed when I Update the Progress (Front Line the data date). Can you help me on this also?

When I want to create the new Batch period in weekly basis, another dialog box pops up saying : “The financial period timescale overlaps with an existing financial period. The financial period was not added.”

Actually, I just want to freeze the Previous Actual Labor Units when I front line the data date into the following week.

Rgds,

Rifky

Rifky,
Try to delete define financial period one by one. For sure some of them are still not used. For those past period and cannot be deleted then run a batch in between those define and should not pass over to already define. If you don’t run Store Period Performance all actual distribution will be change and prorate according to actual duration until it finished. That’s the use of Store Period performance to record or preserve actual labour per financial period define.