Problem with aggregation Opening - Closing balance when loading data Using YTD Input
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
0