Financial Consolidation - Import YTD values and EPM identify automatically the movements in Schedule

Hello,

I would like to know if there is any way to import a Trial balance, with YTD data, and EPM can automatically identify the differences/movements between the YTD values ??and the opennig balance values. And so the sum of the elements of dim Schedule Detail Movements and opennig balance is equal to the YTD value in local currency.

With the assumption that I will import the values ??via Integration table and by the AE ConsolidationLoadDataFromIntegration script.

Or do I have to create a process that calculates the differences between the Openning balance values ??and the ytd value to be loaded?

Regards

Rui

PLM for Process - EMEA User Group -SinfoOne_INFOR_v5_Irca Business Case.zip

Find more posts tagged with

Infor EPM Discussions

Comments

filip-kosnac

Hi Rui,

with Release 2024.04, you can activate option in BM in core, which activates busines logic which does exactly that. It populates movement as difference of YTD account value minus opening balance. Note- you still need to create opening balance by carry forward schedule.

The only thing I am not sure of, is if some validation on load from integration table would error out the import in case you provide only YTD balance without any Detail for schedule accounts, as in earlier releases, there was a validation that schedule account must be provided with detail/movement type information in the standard integration table.

rdias

Thanks Filip, this option works to identify the movement as difference of YTD account value minus opening balance. But after we need account by account (manually) insert the values in schedules details that we allocate.

In my tests a only can use this option if import all data without schedule details.

filip-kosnac

no, you do not have to enter the movements, you have the option to do so.

Use case could look like this:

- in monthly close (YearEnd, QuarterEnd) process where the schedules are required, you can setup validation/check, that the "dummy" movement goes to zero by users to properly enter or import the required data, for all schedule accounts.

- in all other monthly close processes, where schedule is not used/ignored, you leave the calculated dummy movement as it is, there is not a mandatory requirement to manually enter the movements.

In both cases, you end up with data being in alignment with chart of account configuration - movement schedule account has YTD Ending balance matching the YTD imported account. It ensures data consistency between balance and detail cube.

the business logic does exactly what you asked for

[quote userid="67298" url="~/infor-epm-user-group/f/infor-epm-discussions/35429/financial-consolidation---import-ytd-values-and-epm-identify-automatically-the-movements-in-schedule-details"]Or do I have to create a process that calculates the differences between the Openning balance values ??and the ytd value to be loaded?

You do not need to calculated in prior import, as it is provided in EPM.

But there are no means how the system should know, that of say 100 ytd movement, 80 would "increase" movement, and 20 would be some "other" movement. As long as this is not being provided from source (ERP/Improtfile), then this stays a manual job.

Copyright © 2025 Infor. All rights reserved.