How do I get the 'Actuals' to appear in WIP or on the Project, Detailed Financial Cost Plan?
search cancel

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

book

Article ID: 27236

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

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?

 

Environment

Any Clarity release

Resolution

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. Make sure the resources are Financially Enabled and Financially Active
  3. 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)
  4. The 'New' transactions will appear in the Administration, Invalid Transactions page
  5. Run 'Post Transactions to Financials' Job: this will post the timesheet data to financial module.  The records will move into the PPA_TRANSCONTROL tables.
  6. 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 
  7. 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.
  8. 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
  9. 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.
  10. If actuals are still missing, check to make sure there are no inactive charge codes associated with the project.

If the timesheet entries did not go into Invalid Transactions at all make sure both the project and the resources are financially enabled.

You can check to see if the record got exported into invalid transactions by checking the table/attribute prtimeentry.prrmexported

You will have to join this table back to the timesheet and assignments to verify the exact task/assignment.

Additional Information

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

Reference TEC466919 /article 26080: Financial Transactions in Invalid Transaction Log shows a rejected message with the reason "no rate was found for this transaction"
Reference TEC466547 /article 26269: Financial Transactions in Invalid Transaction Log shows a rejected message with the reason "missing or invalid or inactive charge code"
Reference TEC439129 /article 27029 : How to calculate new rates and costs for transactions in financial module waiting for WIP or already Posted in WIP
Reference TEC532981 /article 22819 : 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

Powered by Wolken Software