Guidance to Configure Data Management to Load Trial Balance Data for FCC

Summary:

Guidance to Configure Data Management to Load Trial Balance Data in FCC

Content (required):

We want to load Trial Balance (TB) Data for data being sourced from a legacy ERP systems that can only extract the data this way. Ideally, we would like to just get Periodic or YTD values but it is not possible. For Trial Balance Data, Balance Sheet data comes as LTD ("Life-To-Date") and P&L as YTD. We thought of selecting the "FCCS_ClosingBalance_Input" Movement member for Balance Sheet accounts and "FCCS_YTD_Input" View member for P&L accounts. But when we tried that, we are not getting accurate results when testing several periods. Is there a