HELP! I am trying to add a few fields to an existing report in Intelligence to review paid expenses but can not find what I am looking for. I want to add GL, Cost Center and the Group the employee belongs to on the expense side. I have added all the fields Custom 1 -40 to the report and none of them have the information I am looking for. I added the Cost Center Name field thinking jackpot I got this one but nothing in that field either.
Are you familiar with the Configuration Report? If so, this is your best option for finding the data items you are looking for, especially the Cost Center field, since it is a custom field. The Configuration Report is found under Admin>Expense Admin. Now, the report looks a little daunting, but not if you know where to look. There are several links at the top of the Config Report page. The links you probably want to use are the Employee Forms and the Expense Forms. Clicking a link takes you to that part of the report. You will see several columns on this report. You should have a column labled Field Label (the generic name) and Field Name (your customized name for the field). Go down the list of items on the left side of the report until you see one that says Cost Center. Go across the report until you see something like Org Unit -1 or Org Unit - 2, etc. This will tell you the field that was used and what to look for in the data warehouse. The cost center field you mentioned didn't yield any data because it probably wasn't mapped using the Concept Mapping option in Expense Admin.
Also, keep in mind that GL codes will not appear in a report until the expenses on have been approved by the processor.
I hope this helps.