User Import Sub-Ledger Balances at Group Detail Level
Summary:
How to allow users to import their sub-ledger balances at the group detail level
Content (please ensure you mask any confidential information):
We are looking for a solution that would allow reconciliation preparers to import their sub-ledger balances at the group detail level. Currently they are only able to manually key in a total balance on the face of the reconciliation. We have tried utilizing the pre-mapped balances feature but it appears to also not allow balances to be loaded at the sub-segment level.
It seems the only way to accomplish this is via Data Exchange, but I really am not too keen on opening up this module to the user base. I also wouldn't want to task an administrator in collecting flat files from the accounting teams to execute these data loads manually either. Has anyone else come across this issue and solved for it?