KateCurran
Occasional Member - Level 1

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

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

0 REPLIES 0