Hi Experts,
We have the following situation:
We need to load a single source record into an End Balance custom 2 member as well as a two a rollforward movement custom 2 member (Additions, for example), of the SAME Account.
In our GL we have separate accounts for additions, depreciations, disposals, etc. In HFM, we use Custom members for these.
I've tried multi-dimentions mappoing to map to a specifc custom 2 member based on the account. It works fine, but when I add another condition using the same source account and map to the end balance member, it only ends up populating one of the custom 2 members (whichever was processed last during the import).
What would be the best way to load a single source record to 2 custom members (same account)?
I wanted to use Logic Accounts since I know that would work, but our finance team won't accept this approach.
Is it even possible to load the same record to 2 different HFM members? Even if we loaded the same file a second time in another location, I think it would still replace what was loaded the first time, instead of loading again to a different custom member in the same account. Even if we loaded to HFM on "merge"?
Any ideas at all would be appreciated.
Thanks,
Mark Smith