Report on all available expenses

[Steady88]

Hi

I produce reports on what expense receipts we have and have not received or submitted. My company has around 100 credit cards that are used monthly. I can see there is a report for unsubmitted expenses, but I believe this only includes expenses that have been added to an expense folder, by the employees. Is it possible to get a report of any 'available expenses', which are not in any folders?

[KevinD]

@Steady88 in Cognos, you can go to this location in the data warehouse: Expense Reports > Credit Card > Credit Card Transactions. Add the data item Transaction Status. Filter this data item to Show Only AS and UN. This would be assigned and Unassigned. However, AS could include card transactions that are submitted, but not yet approved, so you would need to add more details to the report to make sure it only shows amounts that are not yet approved.