This is part two of a blog on utilizing the BPC Restore Journal and Export Journal Data Manager Packages. In the first installment we covered how to setup BPC to use the packages and a few of the reasons why a business team might utilize mass journal updates. In the second installment, we will walk through a working example of how a team might use the packages to seed budget journals from actuals. See part 1 for a refresher on how to setup BPC for importing and exporting journals.
So let’s take a look at how the BPC Import and Export Data Manager Packages can help seed the budget using actual’s journals.
All steps were performed on SAP BPC 10 NW on HANA using EPM Client SP 15 for Excel.
Seeding Budget Journals
In this scenario, the business has a need to pre-populate (seed) next year’s budget using last year’s actuals. While this is a common process, what’s not as common is the need to capture detailed journal entries. In many instances journals, are summarized and entered as a single entry for planning purposes. But in some situations, especially consolidated financial budgets, it may be necessary to include all journal entries. If you’re not familiar with BPC Journals, it’s recommended that the following steps be done in a test environment.Read More