Report to Display Location & Amount at Entry & Allocation Level in One Column

[KateCurran]

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:

• Entry shows Location 121 for $100
• Allocations show $20 each to 5 different locations

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

[KevinD]

@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.