Accruals Report

steve_matthews · ‎Jul 1, 2022

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!

KevinD · ‎Jul 1, 2022

@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
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 · ‎Jul 4, 2022

Thanks @KevinD Just what I needed! Much appreciated.

Regards

Steve