Is there a best practice way to remap line items between modules?
What I mean by this is taking a set of line items from a module and remapping them to another set of line items in a module, as per the screenshot below?
My use case for this would be to summarise P&L lines or to reclassify line P&L lines into a different format.
For my first attempt at this - I did the following.
Created my source P&L and target P&L, creating a line item subset for each module.
Create a line item mapping module with the following attributes:
Dimensioned by the source line item subset.
One line item called 'Target Line Item' formatted as the target line item subset.
(This is shown in the earlier screenshot)
Another line item to COLLECT() the values of the source module. This line item is dimensioned in the same way as the source P&L.
In the target P&L module, reference the COLLECT() line item in the mapping module, SUM'ing on the 'Target Line Item' line item in the mapping module.
To me this approach is OK - but not perfect. The most significant disadvantage is the fact that I effectively have to build the source P&L module twice - using up valuable model space. Once for the original source P&L module, and once again in the COLLECT() line item in the mapping module. This is because the COLLECT() line item is dimensioned in the exact same way as the as the source module. Unfortunately, I cannot remove the dimensionality from the COLLECT() line item as it is required to pull through my organisation list, LOB list, time, and version detail to my target P&L module.
What I like about this approach is the flexibility, line items can be remapped from a quick pick list, on the fly. It is also easy to ensure that all the line items from the source P&L module are being mapped somewhere (it is for this reason that I don't want to simply link the two modules via referencing the line items themselves. It is very easy to lose track of which line items in the source module have been referenced and which ones have not).
Any other ideas or thoughts on this would be fantastic - open to any suggestions.
Hi David, By two lists - do you mean setting up one line item per P&L module and using a list as a proxy set of line items? If so, did consider that, but unfortunately my organisation does not consistently sum their accounts. Thanks, Nic