Actuals not pulling through

NB

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

VIGNESH.M

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

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

NB

Hi David, 

 

Please see below.

 

Mapping module

 

P&L module: Target

 

Actuals upload - Source

 

Thanks in advance for your help.

Naveed

NB

Thank you, Vignesh.

 

That solved it.

 

DavidSmith

@NB 

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

David

NB

True, I have deleted select out.

Thanks
N