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
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)
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
