Transaction Review (Financial Plans in New UX) portlet: cost fields do not show decimals and calculations look incorrect
search cancel

Transaction Review (Financial Plans in New UX) portlet: cost fields do not show decimals and calculations look incorrect

book

Article ID: 205285

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Data shown on the Transaction review portlet on the New UX Financial Plans module seems incorrect if rate matrix data used for calculations has got decimals

STEPS TO REPRODUCE:
1. Admin > Finance > Manage Matrix > Create a Rate Matrix with a single catch all row and a rate of 63.34 
2. Create a project and financially enable it
   Add a financial department and location, set the financial status to open and add a charge code
   Add the above matrix to the project
3. Add a team member to the project
4. Create a task and assign the resource to the task
5. Home > Reports and Jobs > Jobs
6. Run Rate Matrix Extraction job with options 2, 3, 4 and 5
7. Create a few transactions
   See attached sample file to XOG the transactions (transactions_write.xml)
8. Once XOGed in, check Invalid Transactions were you will see the XOGed in transactions with status New
9. Home > Reports and Jobs > Jobs
10. Run the Post Transactions to Financial job
    You will notice the Invalid Transactions are now gone
11. Run the Post to WIP job
12. Transactions are now processed and present on PPA_WIP tables
13. On the Classic UI > Home > Financial Management > Posted Transaction Review filter by the project of testing.
    Transaction quantity, cost values ... show decimals and calculations are correct


14. Move to the Modern UX
15. Create a project Blueprint and ensure the Financial Plans module is present
16. Get the project we are using for testing and associate it to the new Blueprint
17. Go to the Financial Plans module
18. Create a Cost Plan 
19. Go to the Planned To Actuals View
20. Under Settings set the Decimal Display to 0.00


21. Note the Actual figure is hyperlinked. Click on it and the Transaction Review Portlet opens


22. Look at the portlet data

Expected Results: Units, Unit Cost and Actual Cost figures show decimals. 
Actual Results: Cost figures are shown as integers. The calculations take the decimals into account and are correct, but at first look the figures do not seem proper looking at the figures displayed in the portlet.

Cause

This is caused by DE59095

Resolution

This is fixed as from 15.9.2

Additional Information

Additional information:
In 15.9.1 > Go to the Financials Module > Actual Transactions Portlet ( Prior to 15.9.1 this portlet does not exist)
View Options > Add 2 decimals to Money and Number fields
Transaction quantity, cost values ... show decimals and calculations are correct