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.
This is caused by DE59095
This is fixed as from 15.9.2
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