Accruals Report

[steve_matthews]

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]

@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.

[steve_matthews]

Thanks @KevinD Just what I needed! Much appreciated.

Regards

Steve