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

Cognus Query Studio - How to exclude submitted credit card claims?



May I ask if I can exclude the submitted credit card claims when I'm generating the report? 


I think I can only use items under "credit card" function, otherwise "unassigned to report" item would disappear (For example, if I use payment status under other function, the Unassigned to report item would disappear). 





Kind Regards


Yuxuan Jiang

Community Manager
Community Manager

@vincentjiang I think one thing you could consider is using the Approval Status as one of your data items. Then what you could do is filter the report to Show Only Unsubmitted claims.. That way you would only being seeing credit card claims that are not yet submitted. Give that a try and see if it gives you what you need.

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.
Occasional Member - Level 1

Hi Kevin,


Thanks for your reply.


The solution can't work because the unassigned amount would be excluded after approval status is used. And unassigned amount  also include unsubmitted  claims. 


Kind Regards


Vincent Jiang