cancel
Showing results for 
Search instead for 
Did you mean: 
steve_matthews
Occasional Member - Level 1

Accruals Report

Hi there,

I'm trying to reproduce the standard Accruals report in Query Studio to show corporate card transactions not yet submitted/added to a cliam, I only want 'Unassigned' transactions ideally - i.e. only items not yet added to an expsense report. On the standard Accruals report this column seems to be named 'Approval Status' however I cant find any field in Query Studio that relates to Approval Status and has an oprion of Unassigned?

 

Thanks for your help!

 

steve_matthews_0-1656672593269.png

 

2 REPLIES 2
KevinD
Community Manager
Community Manager

@steve_matthews You will want to use Transaction Status as the data item. Filter on this data item to Show Only "UN" which means Unassigned to report. Transaction status can be found in Expense>Expense Reports>Credit Card>Credit Card Transactions.


Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
steve_matthews
Occasional Member - Level 1

Thanks @KevinD Just what I needed! Much appreciated.

Regards

Steve