web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager ne...
Microsoft Dynamics GP (Archived)

Integration Manager negative distribution message

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    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

  • Community Member Profile Picture
    Community Member on at

    That was very helpful, Thanks!

  • Richard Ottley Profile Picture
    Richard Ottley 140 on at

    [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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans