Export line item codes
Description of the enhancement:
To be able to export the line item codes instead of only the line item name.
Description of business use:
I have a financial statement report module where I have accounts as line items. This is because some of the accounts are calculated. We have a need to export this module with account codes for integration with, for example, data warehouse instead of line item names and we cannot find an option to export line item codes.
Let's say I have a measure named "X" that is calculated X+Y/Z. That X has to be a line item to have the calculation. Let's assume that this item X has code 123 that is used in data warehouse. I cannot directly export this measure with code 123 but only with name "X" that is not used in data warehouse (or the name changes once in a while and therefore I have to use the code).
I managed to find one solution for this. I created a module where I have list with same items that are line items in another module. Then I update the export module with the import-function by matching line items with dimension. Then I can use the export function and choose to export codes from the account dimension. This works but is not that elegant way of doing it.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!