Skip to content


Manual distribution lines for multicurrency payables transactions

Henry asked 8 years ago
Hi, I am currently facing an problem in integrating a multicurrency payables transaction where I manually set the distribution using smartconnect. After integrating, the document originating amount matched but the functional amount does not matched due to rounding difference which does not allow me to post the transaction. I found that GP didn’t auto create the “ROUND” distribution type for the rounding difference to balance the functional amount. Is there a way where smartconnect is able to auto create the “ROUND” distribution type?
Best Answer
Lorren answered 8 years ago

To default that distribution, you have a couple of options.
  1. Use this KB article as an example to include the distribution as part of your data source.
  2. Create a Post-Document task, either script or sql, that creates the additional distribution directly into the GP tables.  If you do this, I would recommend calling the existing eConnect procedure taPMDistributionInsert.
  3. Go back to letting the distributions default from Dynamics.
Henry replied 8 years ago

Hi Lorren,

Thanks you for your reply.

I tried using econnect procedure taPMDistributionInsert in smartconnect to insert the distribution to balance the functional amount after running the initial integration.

However when I check back the transaction in GP, the error still prompts telling me the distribution is not balance and there is still error.

Eventhough the distributions amount for both functional and originating are matched.

Is there any steps that I might have miss?

If you would like to submit an answer or comment, please sign in to the eOne portal.