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