This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Hi all,
We have Recently added the intelligence reporting package and I am unsure if I can create this report myself using the provided standard reports or if this is something that needs to be created. I’m trying to build a report that shows Location and $ Amount at the entry level (when not allocated) and at the allocation level (when a transaction is split across multiple locations).
In Concur, we’re required to select a location at the entry level, but we also allocate expenses to store locations using a custom code.
For example:
I don’t want the $100 to show in my amount column—I want to see five lines of $20 each, so I can reconcile at the store level.
I’ve been able to show these in two separate columns, but I’d like to combine them into one column for easier comparison with our Bank of America statement.
Has anyone done something similar or know how to configure this in a custom report?
Thank you so much
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@KateCurran I don't think you can merge data from two different data items into one column. However, you might be able to "trick" the system by inserting a table into your report and then format the table to hide the table lines so it looks like one column.
Can you provide a screenshot of what you currently see and then a screenshot of what the BoA Statement looks like, please? Having a visual will help as I might need to ask my Reporting contacts the best option.