Report after Integration through Integration Manager

(0) Share

Report

Posted on by Community Member

We are importing bank transaction through Integration Manager and since Integration Manager doesn't create a report, we don't know the transaction numbers(CMTrxNum) associated with the integrated transactions.

Is there any way to get a report that is similar to what gets created if we were to enter bank transaction manually??

This will be really helpful.

Thank you!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

(Note: Our system is currently set up so that bank transactions get automatically posted)

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Ifandormaybe,

are you using eConnect adopter or Microsoft adopter during integration?

if u are using eConnect adopter then it will displays the status of the integration.

if you are using Microsoft adopter then, after integration

* you can use Smart list report in GP.

* you can found those records under Financial-->Bank Transactions-->(*)

* once you know the Transaction date or Posted date, you can sort the transaction details based on it. or you can use any filter from the integration file .

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

No option available for seeing integrated transaction numbers. It will shows you only the number of document integrated into GP. If you want to see integrated transaction numbers, you can view either smartlist as suggested by Nataraj or Transaction table(CM20200) from SQL with applying filter for your current integrated transaction criteria.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you all for the comments.

I was able to print out the same posting report by entering AUDITTRAIL code in Posting Journal report( Reports - Financial - Bank Posting Journals) . I had to retrieve AUDITTRAIL code from CM20200.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

Is your problem has been resolved?

Was this reply helpful? Yes No
Galina 1,077 on at

Like (0)

Report

As a suggestion, you can use After Document script to record the transaction numbers and associated documents information and compose e-mail message.

Was this reply helpful? Yes No