Hi All,
I am trying to pull actual values into P&L module using a mapping module. However the values are not transferring across.
Details:
I have created a line item sub-set from P&L module, which is dimension-ed by time and versions.
P&L module
Mapping module
I have also built a mapping module to map the GL code ( List) to the P&L using list formatted line items without time or versions as dimensions. The mapping module is dimension-ed by GL Accounts & code.
Actual version is displaying editable cells and values are not pulling through. Switch over is enable for March 19.
Thanks in advance for your help
Naveed
Solved! Go to Solution.
Hi
Can you post a screenshot and dimension details of the source, mapping module and target modules
This will help us identify the issue and solution
Thanks
David
Hi David,
Please see below.
Mapping module
P&L module: Target
Actuals upload - Source
Thanks in advance for your help.
Naveed
Hi @nb ,
Can you check the formula scope column in the blueprint view for the line item in target module, Formula scope should be ALL VERSIONS.
~Vignesh M
Thank you, Vignesh.
That solved it.
One other point, you also shouldn't need the SELECT statement - The top level for Stations will automatically pull in the totals
David