By using this website, you agree to our Terms of Use (click here)
From the User Guide, "General Ledger Consolidation Overview" - "During the import, consolidation data is grouped by the financial periods of the reporting unit. Thus, financial periods in the consolidation units and in the parent company should be defined similarly; otherwise, the consolidated data will be incorrect."
Does this mean consolidation is done by period number or calendar month? Suppose we have 2 Tenants with different FY start dates, but we want to consolidate common periods by period number (ie. period 1 from both is consolidated period 1). Will this work out of the box? Or do the calendars need to be identically defined in each Tenant?
Not sure the answer to this question. I tried configuring some Consolidation companies in my Demo environment to test, but ran into this error:
The remote server returned an error: (500) Internal Server Error
Sorry, must be something wrong with my demo environment.
Or perhaps this is the user unfriendly error that appears when consolidation companies calendar's don't align.
That might have been it. I'll try to remember to chime back in here the next time I need to configure consolidations.
Can answer this myself now. Consolidations financial period selection works on Financial Period ID values as defined in the "Parent". So if you select period 2019-01 to Import (which in our case means July 2018) and assume Subsidiary starts April, then it will pull in data from April-2018. This means when you ultimately consolidate, you would be combining data from different calendar periods (July + April).
In our case, we want to align by Calendar periods (July + July) and this isn't possible using out of the box Consolidations.
Thanks for posting the solution Royce, even though it was disappointing.
Online Members
