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.

[KevinD]

@athakur ICS integration isn't my strong suit, but maybe @Andras can help with this question. I'll also send him an email asking him to help. 

[cmuellner]

There is an expense pay extract that clients use to aid in this reconciliation when using expense pay. Here is a link to the documentation for it. This is a separate extract today and not a part of the standard ICS integration, but we are in the process of evaluating adding it into the standard flow and including the trace ID as a part of this. There is a section on the reconciliation process with this extract as well. This may vary with the ICS integration as the reconciliation is focused on SAE but most of the same elements should be available via ICS.  https://help.sap.com/docs/CONCUR_EXPENSE/bb83754b1c5541808d50c09901e11475/188239626f0910148e6996bfb6... 

[athakur]

@cmuellner Thanks for your response, I am curious if this works for you ( to extract Trace ID in SAE file)? We were using SAE file with our old ERP, but moved to ICS integration when we implemented SAP S/4 ERP (as this is a native integration). I recall that Trace number was not an available column in SAE file. And I wonder how it can be included because Trace number is sent by the bank to Concur pay after payments, where as SAE or ICS extract happens as soon as expense is completely approved.

Also, since we enabled Financial integration, we cannot use SAE extract anymore. I believe these two are mutually exclusive in their usage.

[cmuellner]

You are correct this is not available today and even if the field were available, the funding trace value itself doesn't get returned from the payment provider until funding is initiated which is after initial extract. This is more of a future innovation we are looking at. You can reach out to me via email and we can discuss this further as I may have an alternative way to do this with the expense pay extract in the meantime. I am the PM for the Expense Pay Product. 

[Andras]

Hi @athakur , @KevinD .

As this is  ICS-related consulting question, I highly recommend to contact our Platinum Team (SAP Integration With SAP Concur Solutions - Customer Information - AboutPETeam)

Please contact sapconcurintegration@sap.com identifying yourself with the company name in the subject of the email or create a case SAP For Me > Services & Support under component XX-SER-CON-PE.

Thank you!