Trace number - Monitor batch funding

[athakur]

Hello,

Is it possible to extract "Trace number" field from Monitor batches -> View Funding page on a Cognos report excel report?

Thanks

Ashish

[KevinD]

@athakur I don't think it is, but a fast way to know for sure is to start a new report in Cognos and use the search field above the data warehouse items and type in Trace. If the data item exists, your results will display. 

[athakur]

Thanks @KevinD 

[athakur]

@KevinD - Reason I asked for this field, we are looking to improve reconciliation between Concur Global pay payments received via electronic bank statement and expense financial posting in our SAP ERP system. For bank statement and Concur global pay payments- trace number is the only available link. And since we cannot extract Trace number in Financial posting or Cognos report, the whole process becomes very tedious. 

[athakur]

@KevinD Is there any recommendation on how to improve reconciliation of Concur expense financial posting when using ICS integration with Bank statement? We are using Global pay for Concur payments, Worldline is setup for direct debit at our Bank, after payment our Bank sends electronic statement to SAP S4 system with trace number, but there is no automated way to link the Trace number from bank statement to Concur expense posting via ICS.

This in turn becomes a manual activity for our Finance team as an open reconciliation item.