Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Integration Manager negative distribution message

(0) ShareShare
ReportReport
Posted on by

I am trying to integrate Payables transactions from a database and receive the following message when running the integration. None of the amounts are negative and I've specified a document type of Invoice. Has anyone come across this before, any suggestions?

"You cannot distribute to a transaction with a negative amount on account."

*This post is locked for comments

  • Richard Ottley Profile Picture
    140 on at
    RE: Integration Manager negative distribution message

    [quote user="Donald Thib"]

    I am trying to integrate Payables transactions from a database and receive the following message when running the integration. None of the amounts are negative and I've specified a document type of Invoice. Has anyone come across this before, any suggestions?

    "You cannot distribute to a transaction with a negative amount on account."

    [/quote]

    Did you figure out what the issue was? I've been trying to integrate my Payables without success.

  • Community Member Profile Picture
    on at
    RE: Integration Manager negative distribution message

    That was very helpful, Thanks!

  • Verified answer
    L Vail Profile Picture
    65,271 on at
    RE: Integration Manager negative distribution message

    Hi,

    I would turn on the view so that you can watch the macro run. The Integration Manager standard adapter creates a macro to execute the integration. By default, the GP windows are hidden so that you cannot see what's going on. You can turn the hide off so that you can better troubleshoot the problem. You will be able to see the values the program is trying to enter on the transaction entry screen. To turn on the display you need to adjust the settings in Integration Manager's .ini file. The file is located in the folder where Integration Manager is installed. The name of the file is Microsoft.Dynamics.GP.IntegrationManager.ini.

    Change the following switches to the values below:

    ShowDynamics=True

    DoUIRedraw=True

    The file, when opened, will look like the image below:

    IM-.ini-file.png

    This will give you a fighting chance of figuring out why the integration is failing.

    Kind regards,

    Leslie

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans