Transactions: posting / correcting / adjusting
search cancel

Transactions: posting / correcting / adjusting

book

Article ID: 213314

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

This article provides the sequence of actions for posting, correcting, and adjusting transactions based on the type of transaction.

Environment

Component: Clarity Financials

Release: All Supported Releases

Resolution

Note: The full Rate Matrix Extraction job will need to run and complete before any of the posting jobs are ran.

Timesheet Transactions

Posting

  1. Post Timesheets
  2. Post Transactions to Financials 
  3. Post to WIP 

The job can be run from either

  • Home > Reports and Jobs > Available or
  • Home > Financial Management

Correcting/Adjusting the transaction

To adjust a timesheet transaction:

  1. Perform a timesheet adjustment. (The timesheet needs to be changed in order for the Post Timesheets job to process the adjustment.
  2. Run the following jobs:
    1. Post Timesheets
    2. Post Transactions to Financials
    3. Post to WIP

Important: Do not perform the adjustment until it is identified that there is a mismatch between the below as the mismatch needs to be corrected the first.:

  • PRASSIGNMENT.actcost_sum
  • PPA_WIP_VALUES.AMOUNT

Take caution because if the assignment actual cost is already not matching WIP, this method will not fix the amount, but will just adjust it based on what changed in WIP.

For example:

If the assignment cost = $100 and WIP cost = $150 for same transaction (PRASSIGNMENT.actcost_sum = 100 vs. PPA_WIP_VALUES.AMOUNT = 150). If you WIP adjust the transaction for +$25, the actual cost is now $175.

Notes:

  • Adjusted transactions will appear in the Home > Financial Management > Approve WIP Adjustments page.
    By opening the transactions, the proposed changes can be viewed. We do not recommend timesheet transactions to be WIP adjusted or transferred. The suggested method to make changes to timesheets is to click the adjust button on the timesheet and let it go through the normal timesheet posting jobs
    as there can be a mismatch in WIP.
  • If there are no changes in timesheet hours, WIP adjustments with the 'Calculate New Rates' option can be performed. If there are changes in hours, do NOT perform a WIP adjustment on timesheet transactions.
  • To adjust timesheets in closed time periods.
    1.Open closed time periods.
    2.Navigate to the timesheet for the resource/time period.
    3.Adjust the timesheets.
    4.Submit and approve the timesheets.
    5.Run the Post Timesheets job.
  • To repost costs only on timesheets, use flag PRRMEXPORTED in table prtimeentry, then run Post Timesheets job

Manual Transactions

Posting

  1. Post to WIP
  2. Import Financial Actuals

Correcting/Adjusting the transaction

To adjust a manual transaction:

  1. In Clarity, go to Home > Financial Management > Create WIP Adjustment
    • Set 'Quantity' to be the desired number of hours (never a negative quantity)
    • Set 'Cost' to be the desired actual cost rate (never a negative rate)
    • Checkmark 'Calculate New Rates'
  2. Approve the adjustment via Home > Financial Management > Approve WIP Adjustment

Transaction Reversal

To reverse a transaction:

  1. Go to Administrations - Create WIP Adjustment
  2. Filter for the posted WIP transaction by specifying a date range in the From Date and To Date fields.
  3. Transactions that match the criteria appear.
  4. Select each transaction that you want to reverse, and click Reverse The transaction is ready for WIP approval.
  5. Go to Approve WIP Adjustment, select the transactions and click Approve
  6. Run Import Financial Actuals job

XOG Transactions

Posting

  1. Post Transactions to Financials
  2. Post to WIP
  3. Import Financial Actuals

Correcting/Adjusting the transaction

To adjust a XOG transaction:

  1. Home > Financial Management > Create WIP Adjustment
  2. Home > Financial Management > Approve WIP Adjustment
  3. 3. Import Financial Actuals job