Actuals not pulling through

[naveed.bakshi]

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

[DavidSmith]

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

[naveed.bakshi]

Hi David, 

Please see below.

Mapping module

P&L module: Target

Actuals upload - Source

Thanks in advance for your help.

Naveed

[VIGNESH.M · Accepted solution]

Hi @naveed.bakshi ,

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

[naveed.bakshi]

Thank you, Vignesh.

That solved it.

[DavidSmith]

@naveed.bakshi 

One other point, you also shouldn't need the SELECT statement - The top level for Stations will automatically pull in the totals

David

[naveed.bakshi]

True, I have deleted select out.

Thanks
N