Reporting of Expense Account Codes

[Orin5252]

I am trying to run a report of all of the Active Expense types and their G/L codes assigned to in the system.  The system in the export only gives some of the expense types and not all and there does not seem to be any reason as to which ones are are exported.  Does anyone know how to get this information out of the system? 

[KevinD]

@Orin5252 Cognos reporting can show you what you are looking for. 

Do you have any experience using Cognos? 

[Orin5252]

Hi Kevin,

No idea of how to use Cognos.

[PoojaKumatkar]

Hi @Orin5252 ,

You can try creating custom report as shown below:

Role required - Cognos Professional Author

1. Reporting >> Intelligence

2. Click on Content folder (left side below 4 lines - 2nd icon)

3. Click on New+ (Top right corner blue button)  >> Select Report option >> Click on Create button (top right corner)

4. Click on "Select a source+" button (left side blue button) >> Select "Concur Data Warehouse" option from the list >> click Open

5. From the middle window select a widget type as "List" >> Click Ok (on pop-up window) 

6. From left side under Concur Data Warehouse drop down >> Open Configuration folder >> Account Codes >> Expense Account Codes >> now select required columns (or select one by one), drag and drop into list (right side screen) as shown below in 1st screenshot.

7. Click on Ledger Code header field >> click on filter icon >> Click on Create Custom Filter >> in search box enter "Ledger code" as per given in accounting structure and enter to search, now select ledger code from filtered option so that it will get added into right side column as shown below in 2nd screenshot.

Note - to check ledger code in system (go to concur admin >> accounting administration >> accounting structure tab >> under ledger code see what ledger code is given and add the same code in filter)

8. Now save the report using save option 

9. Run the report using excel or excel data option from the drop down list.

10. Done

Note - regarding blank account codes, you can go to accounting administration >> under account codes tab >> select/click on respective ledger and check does those expense types have any account code assigned or not. If there is no account code assigned, then it will show blank in report. 

If this answers your query, then please mark solution as accepted.

[KevinD]

@Orin5252 well, you are in luck. We offer free webinars on how to use Cognos. It's a great class for beginners to learn how it works. Here is a link: https://www.concurtraining.com/cnqr/cognos-11-registration. When you go to this link, scroll to the bottom of the page to see the upcoming webinars. You can register for the one that fits your schedule.