Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Distribution Amount Keep Adding Up in Payables Transactions Entry

(1) ShareShare
ReportReport
Posted on by

Hi,

I have a scenario in which Payables Transaction Entry Distribution Amount will add up each time the Distributions window is opened. For example, if the Debit / Credit line is $60 by default, if I click on the Distribution button 5 times, the amount will become $300.

This behavior is observed in Dynamics GP 2010SP1, 2010SP3, 2013R2, and 2015R2. We're very curious to find out how and why would system behave in this way, as in whether it's designed to work this way, or there're fixes required for the algorithm.

Below are the detailed steps to replicate the issue.

1. Setup Tax Details

  a. Create Tax Detail ID 'TX-IS', Type 'Purchases', Based on 'Percent of Sale/Purchase', Percentage '6%'

  b. Create Tax Detail ID 'DS-IS', Type 'Purchases', Based on 'Percent of Sale/Purchase', Percentage '-6%'

      (Reverse Charge Taxes has to be enabled in Company Options)

2. Setup Tax Schedules

  a. Create Tax Schedule ID 'TX-IS', insert both 'TX-IS' and 'DS-IS' Tax Details.

3. Enter Payables Transactions Entry

  a. Document Type : Invoice

  b. Tax Schedule ID : TX-IS

  c. Expand to Payables Tax Schedule Entry : set all to TX-IS

  d. Purchases Amount : 0

  e. Expand to Payables Tax Entry, enter $1000 Gross amount for both TX-IS and DS-IS line.

  f. System will calculate tax amount of $60 and -$60 respectively.

  g. Click OK to close the Payables Tax Entry window.

  h. Click the Distribution Button

  i. System will default 2 'TAXES' Distribution lines, with Debit $60 and Credit $60.

  j. Click OK to close the Distribution window.

  k. Click the Distribution Button again, and system will calculate the 2 'TAXES' Distribution Lines to Debit $120 and Credit $120.

  l. Repeat Step h to j, and the distribution amount will keep adding up on each repeat.

*This post is locked for comments

  • RE: Distribution Amount Keep Adding Up in Payables Transactions Entry

    Hello Justin,

    Thank you for testing it out on your side, at least I know the details to recreate the scenario is sufficient : )

    Anyway back to the issue, although I do agree that the 3 workarounds could resolve the issue, I will still need to stick to this entry regardless, simply because of the reasons below, opposing the workarounds.

    1. The Purchases amount is captured in other entries, deeming this entry to only capture the Tax portion.

    2. Local Tax requirements deem this entry, which the taxes cancels out, necessary.

    3. Clicking the Default button will fix the issue for once. However if I "reopen" the Distribution window after that, the same issue will recur.

    Well of course my main purpose of posting this finding here is to understand why and how system will calculate the tax in such a way, so I could further explain to the problem owner.

    However if a fix for this can possibly make it to the Product Suggestion, I would certainly be grateful for you to create one on my behalf. Let me know if you need any details, i'll furnish you as much as I can.

    Thank you again Justin.

  • Suggested answer
    RE: Distribution Amount Keep Adding Up in Payables Transactions Entry

    Hello Ivan,

    I was able to recreate your issue myself on GP 2015 R2. During my testing I found a few different workarounds.

    Specifically, the following resolved the issue:

    1. Entering the Purchasing Amount on the main window (Payables Transaction Entry) and letting the taxes calculate from there.

    2. Using any taxes that do not cancel out

    3. Clicking the default button after entering the Distribution window.

    It appears like the issue occurs due to the way distributions are calculated. Simply put, if the AP account appears anywhere in the distribution list, the distributions calculate correctly.

    This appears to be a "perfect storm" situation, and I would like to know what leads to this situation occurring in the real world so I can detail the issue correctly.

    At this time, this issue is undocumented, but with all the easy workarounds, I believe a product suggestion would be the best route to getting development involved. I would be happy to create one on your behalf, but I would like to be able to give a real world example.

    Please let me know if you have any additional questions on this.

    Justin Sutton

    ------------------------------------------------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------------------------------------------------

    **This posting is provided 'AS IS' with no warranties and confers no rights.**

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans