How to remove investment actual costs

Document ID : KB000012425
Last Modified Date : 14/02/2018
Show Technical Document Details

How can financial transactions be prevented from entering the PPM financial module?
How can the PPM financial module be deactivated?


Depending on the which transactions exist on the investment, actual cost cannot be removed.

Step 1: Review existing transactions

a. Are there timesheet transactions on this investment?

If so, then the timesheet actual units and costs will have the field "Actuals Thru Date" populated, which means it is not possible to remove the actuals via the Delete Investment job.

If there are timesheet transactions, the following message will appear when trying to mark the investment for deletion:
Error:PRJ-07532: One or more of the projects selected cannot be deleted because there are submitted time sheets that contain entries for the selected project.


b. Are there manual transactions on this investment?

If so, then manual transaction entries can be removed via the Purge Financial Tables job, which will remove the records from the PPA_WIP table.

Step 2: Prevent future transactions

Here is how to prevent financial transactions from being created.

Go to Portfolio Management > Projects > Financial > general set financial status = Hold or Closed Click Save.

-Open. All transactions entered against the project can be fully processed to PPA_WIP.

-Hold. New transactions cannot accumulate on the project temporarily.
The Post Transactions to Financial job will not pick these up.

-Closed. New transactions cannot accumulate. It is no longer open for financial processing.

b. Inactivate the folllowing jobs via Administration > Jobs
-Post Transactions to Financials job
-Post to WIP job

Checkmark the jobs and click the Deactivate button.