Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Multi sheet data upload

Hi Guys,
Has anyone encountered the need to load multiple sheets from one Excel workbook in HFM?
I was thinking if there is an approach that allows to do it in one step.
In the scenario we are facing the client wants to upload the trial balance and the disclosures through one workbook with two sheets. This scenario involves Open batch, so we could do it by loading the same workbook twice, each time under a different name that would use a different rule/import format, but i was wondering if there is a more elegant way.
Please share your thoughts on this
Thx
Answers
-
Are you using the Trial Balance Template format? If so you can try changing the named range on the Trial Balance sheet to upsTB1 and then create a second named range on the Disclosures sheet to upsTB2. Classic FDM allows more than one named range - I haven't tested this with FDMEE though.