We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to reload data that has been exported in Data Management

Received Response
11
Views
1
Comments
edited Jun 7, 2021 11:40AM in Financial Consolidation and Close 1 comment

Content

Basically, I need to change the sign of data on some accounts that need to be changed from Expense to Revenue.

I have exported the relevant data from FCCS to a flat file via Data Management in the following format:

Entity,Account,BusinessArea,Intercompany,Movement,Product,View,Year,Period,Data Source,Amount
 

My problem is now how to reload this data in Data Management.

The issue is that Both Year, Period and Data Source is included in the data file and needs to be mapped.

In the existing FCCS Target Application there is no UDx defined for the Year, Period and the Data Source is defined in Application Options and is set to FCCS_Managed Data hence those 3 dimensions do not show up in Dimensions in Data Load Mapping.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!