Share
ReportI’m trying to determine if either out-of-the-box GP or Advanced Allocation (or another tool) could help with some calculations that are currently being done during Management Reporter report execution or after the fact in Excel spreadsheets.
I’ve tried to describe one user case/scenario that I’m contemplating.
Application version: GP2015 R2
Desired functionality (background)
We want to be able to calculate (in GP) a value based on the sum of a group of natural accounts divided by the sum of a second set of natural accounts and have the result posted to a unit account for subsequent reporting and export to other systems.
Today some of this is calculated in Management Reporter as reports are run and some is done after the reports are downloaded into Excel.
In neither the numerator nor the denominator are the sets of account values consecutive. In both there are more than one range of natural accounts.
For certain Entity codes there are nuances (exceptions) to the standard formula –additional accounts to include in either the numerator and/or the denominator.
We would like to be able to calculate the result on both a current period and YTD basis – I’m seeing this as two discrete unit accounts
In certain other cases the summarization would need to span more than one entity for both the numerator and the denominator, and store the result somewhere; perhaps an alternative unit account in those cases?
In the grand total all entities, spanning multiple databases would need to be included in both the numerator as well as the denominator.
Questions
Can delivered GP Variable allocations or some other process native to GP perform the above?
I’m presuming that 2 separate allocation rules – one current period and a second on a YTD basis could address accumulating the numerator and denominator totals. Would this be possible given that the underlying accounts for both would be the same – one on a current period posted amounts and the other on a YTD summarization?
How could we calculate and store results that could span multiple entity codes? (these multiple entity scenarios would all be within a given database - except for a grand total calculation that would need to span multiple databases.
Same questions but would the answers differ if we used Advanced Allocations from Admiral or some other tool?
*This post is locked for comments
All responses (
Answers (
