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

Problem with aggregation Opening - Closing balance when loading data Using YTD Input

edited Jan 21, 2019 11:54AM in Financial Consolidation and Close 9 comments

Summary

Opening balance 5000 - YTD input jan Blance 5100 gives closing balance 10100...

Content

What piece of the puzzle is wrong?

Dec '17 : closing balance is 5000€ and I loaded this as follows

View: FCCS_YTD_Input
Amount: 5.000€
Movement: FCCS_openingbalanceadjustment

After consolidation rule I have my Opening Balance Jan being 5000€

Load Data Jan '18:

View: FCCS_YTD_Input
Amount: 5.100€
Movement: FCCS_Mvmts_AccountsReceivable

Consolidation Rule : result closing balance is 10.100€ - expectation is 5100€

Load Data Feb '18:

View: FCCS_YTD_Input
Amount: 5.200€
Movement: FCCS_Mvmts_AccountsReceivable

Consolidation Rule : result closing balance is 10.200€ - expectation is 5200€

The periodic view for each month is as follows

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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