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
As a suggestion, you can use After Document script to record the transaction numbers and associated documents information and compose e-mail message.
Is your problem has been resolved?
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.
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!!!
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 .
(Note: Our system is currently set up so that bank transactions get automatically posted)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,232 Super User 2024 Season 2
Martin Dráb 230,064 Most Valuable Professional
nmaenpaa 101,156