Looked into this (as much as I am able), and there is a lot going on after loading to YTD_Input, not just frequency calculations, so I think we are stuck with it.
Not an answer, but maybe helpful:
This meant for example that I needed to find a way to load zero for YTD in order to get any reversals in the periods. The solution was to set NZP expression on the amount column. I am now working with the challenge to get NULL amounts converted to zeros for the same purpose, but DM (in the cloud) doesn't like them it appears (since scripting is out). Someone in the FCCS team has said they will follow up with the FDMEE team, so I will post the solution when I get it.
I don't know FDMEE so well, but what I am craving is a way to manipulate each raw row, without having it necessarily filtered beforehand. Then, with "data mappings" on the amount column, I could configure much more.
I think loading zeros is not optimal but I'm experiencing the same issue. We'll continue testing as well and post the results.
I am feedback from the development team that it is not possible to load NULL data values. You can map the master data, but not the data. The workaround solution was to replace ",," with ",0," and ",[CRLF]" with ",0[CRLF]". I used Notepad++ with extended search mode and searched ",\t\n" to be replaced by ",0\t\n" for the latter.
Loading zeros to member combinations that have not had data, is indeed very undesirable, but if it data is to be reversed out, it is a very desirable number to load when loading on YTD basis. I have seen periodic based reversals not capture all decimals (for other odd reasons) leading to residuals showing up in undesirable places.
So, an update, we fixed this by manually adding a "value" column in the extract and specifying whether the value is Periodic or YTD
Also after loading this YTD data did you notice any issues with normal conversion or out of the box consolidation ??
Regarding journals do you face this challenge as well ?? Or are those loaded as periodic values ??
Hi, in adding a "value" column in the extract what do you mean by the extract ???
Have you tried loading YTD data to the Closing Balance Input member ??