Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Report after Integration through Integration Manager

Posted on by Microsoft Employee

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

  • Galina Profile Picture
    Galina 1,075 on at
    RE: Report after Integration through Integration Manager

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

  • soma Profile Picture
    soma 24,406 on at
    RE: Report after Integration through Integration Manager

    Is your problem has been resolved?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report after Integration through Integration Manager

    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.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Report after Integration through Integration Manager

    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!!!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report after Integration through Integration Manager

    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 .

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report after Integration through Integration Manager

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans