Dayalan Punniyamoorthy Blog

Wednesday, May 25, 2022

Fix - Capital data was not getting pushed into Financials!

We ran into an issue that the Capital data was not getting pushed to the Financials using the system-generated Data Map "Financial Statement Integration".  As this was working before but was not working since we added new accounts to the "Map Capital Account to FS"

There is no problem with data push and the members selected in the data map are set up correctly.

While running the Data Map it does give a warning stating as below,

[Data row: 4]

Skipping Smartlist(NumericToSmartList2Transformer (OCX_FinstatementAccounts)), Missing Label not defined.

One or more rows or columns was not converted due to missing members in the reporting application


Ran the "Synchronize" multiple times in the Data Map, but it was not helping and the data was not getting pushed to the Financials module.



The catch is Synchronizing from the Data map alone will not help. The Synchronization needs to be done under "Map Capital Account to FS" too.

As the Accounts were added newly under Property, Plant and Equipment Gross & Accumulated Depreciation. 


Accounts under Depreciation were added before. 

Steps to synchronize account mapping

1# Run the Synchronize rule for both Tangible and Intangible forms 

You won't get any options under Actions. 


Right Click on the form, and you will get the option to Synchronize. 

       
Run the Synchorinozation for Scenario, Version & Entity.



2# Run "
Synchronize" for the Data Map "Financial Statement Integration"


3# Push the data using the Data Map 
"Financial Statement Integration"

Run the Aggregation for the respective scenario you need to review the data in the Financial module. 


Hope this helps!!




No comments:

Post a Comment