How do I get the 'Actuals' to appear on the Project, Detailed Financial Cost Plan?

Document ID : KB000027236
Last Modified Date : 30/07/2018
Show Technical Document Details
Question:

I have created a Financial Plan for my project and I do not see any values in the 'Actuals' column. How do I get the 'Actuals' to appear on the Project, Detailed Financial Cost?

 

Answer:

For financial 'actuals' to appear on the detailed financial plan, there must exist transactions Posted To WIP.

Below is a description of the general process steps that you must execute to process your financial transactions. Financial Transactions can come from Timesheets or from the Transaction Entry page or from using XML Open Gateway (XOG) to XOG inbound transactions.

You must check to ensure that the following workflow is established:

  1. Financially enable your Project - Project Plans are tied to the Financials of a project and therefore you must ensure that the project is Financially Enabled; the financial properties must be defined, the project financial status must be set to 'Open'.
  2. Run 'Post Timesheets' Job : this will take timesheet information and create transactions in the financial module, if the transaction has not already been created from the existing timesheet (This will take transactions that are associated with Resources that are Financially enabled)
  3. The 'New' transactions will appear in the Administration, Invalid Transactions page
  4. Run 'Post Transactions to Financials' Job: this will post the timesheet data to financial module.  The records will move into the PPA_TRANSCONTROL tables.
  5. Check the Administration, Invalid Transactions page:
    • If there are any rejected transactions, DO NOT DELETE the transaction
    • Correct the transactions according to the displayed message within the project or in the resource properties
    • Re-run the 'Post Transactions to Financials' job 
  6. Go to Home, 'Post To WIP' and post the transactions manually OR in v14.3+ schedule the 'Post to WIP' job
    1. Search for transactions waiting to be posted :
      • To return results for All waiting transactions, simply press the 'Apply' button.
      • If you want to only post transactions for a particular project you can select the project name in the Search Field and press 'Apply'.
      • If you have financial transactions that are older than the current fiscal period, waiting for posting, be sure to specify a date range in the Filter Section.
    2. Select the items to post
      • Press the 'Post' button to Post the Transactions to WIP resulting from the Search
      • (OR) click 'Recalculate and Post' button if exchange rates have been updated since the time the transaction was created into the financial module.
  7. If you need to make any WIP Adjustments, process them and import the changes back into the project by running the 'Import Financial Actuals' job
  8. Return to your Cost Plan and when the 'Actual Units' and/or 'Actual Cost' fields are configured on the TSV, you will be able to see the actual data now posted into WIP.
  9. If actuals are still missing, check to make sure there are no inactive charge codes associated with the project.
Additional Information:

For more information regarding the detailed financial plans, reference the Financial Management Guide.

Reference TEC466919 : Financial Transactions in Invalid Transaction Log shows a rejected message with the reason "no rate was found for this transaction"
Reference TEC466547 : Financial Transactions in Invalid Transaction Log shows a rejected message with the reason "missing or invalid or inactive charge code"
Reference TEC466549 : Financial Transactions in Invalid Transaction Log shows a rejected message with the reason "Exchange Rate for Home Currency Code not found"
Reference TEC439129 : How to calculate new rates and costs for transactions in financial module waiting for WIP or already Posted in WIP
Reference TEC532981 : Import Financial Actuals job does not process negative transactions fully when there are no matching positive hours for the transaction date and no exception is reported
Reference TEC562321 : Explain WIP Reversal and WIP Transfer actions