How to delete Store Period Performance?
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Friend,
Can anyone explain me how to use SDK for deleting financial periods and after that recreate new batch.
Thanks alot
Stal
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 dont run Store Period Performance all actual distribution will be change and prorate according to actual duration until it finished. Thats the use of Store Period performance to record or preserve actual labour per financial period define.
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,
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.