Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

PM TRX integration - some distributions with MDA some not required to have MDA

(0) ShareShare
ReportReport
Posted on by

I've been able to create a PM trx integration that includes MDA groups/codes. It works fine if all GL account distributions have MDA Group/Code included.

However there are some transactions that include GL distributions to accounts that do not require MDA codes.    

I've tried to set the If Null, Use Blank or Use Default.  The error points to the Group field being required.  It's obviously not verifying this against the account number as I can manually enter the same dual distribution type of entry without getting any error.

Has anyone else come across this before or have ideas of what might work in this situation?

Thank you!

*This post is locked for comments

  • Suggested answer
    sueconrod Profile Picture
    337 on at
    RE: PM TRX integration - some distributions with MDA some not required to have MDA

    I use Smart Connect with Analytical accounting and had the same issue.  I had to put into the Smart Connect Integration an if, then, else statement:  Don't know if that will help you.  

    If _auditnumber ="" then

    return False

    else return true

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans