This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
I am trying to add Unassigned Credit Card Transactions on an expense report that I am populating in Query studio. I can not find this in the studio. I am able to pull all other expenses submitted and non submitted but unable to add “available expenses” / “unassigned expenses” on employees profile on the same report.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@shaney88 because you have expenses sitting on a report these are considered assigned transactions. These will not allow unassigned transactions to appear on your query. You would need to build a Union so your report can include both unassigned and assigned transactions.
Query Studio does not have the capability of creating a report with a Union, you would need access to Report (formerly called Report Studio). Does your company have the Business Intelligence option?
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Hi Kevin, no we would only have a basic reporting platform. What would be best to pull ALL expenses that include submitted and expenses that are still remaining on an employees profile?
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
@shaney88 I should clarify my last response a bit. If you have the data item Report Name, then unassigned transactions will not display because there wouldn't yet be a relationship between the unassigned transactions and a report. If you are looking to see just company card transactions, you can go into the Credit Card folder in the data warehouse and add the items shown in my screenshot. As you can see, there are both Unassigned and Assigned Transactions. This will at least tell you who they belong to and if it is on a report or not.