Finance | Project Operations, Human Resources, ...

Fixing Discount amount in an invoice distribution

(0) Share

Report

Posted on by Shagri

I am inputting invoices for a vendor that we receive a discount from. While inputting the invoice I set up the payment terms, but when I look at the distribution it is off by a penny. I need to swap the penny from the discount amount to the pay amount but every time I do so I get the error message "Distributions for this transaction contains errors: The accounts payable distribution does not equal the actual amount. The discount available distribution does not equal the actual amount."

I've tried taking out the payment terms and inputting the discount in the distribution manually but I come up with the same error message.

Now, previously I would input it all manually in the distribution and never got an error message. My coworker fixed the vendor to reflect the payment terms to make it easier and now I cannot fix it manually. How can I fix this so that I can just input the discount manually in the distribution? Or, be able to fix the discount amount and pay amount without receiving an error message? I've tried taking the payment terms out of the vendor's card and inputting the invoice without any payment terms.

Categories:

Microsoft Dynamics GP

All responses (5)

Answers (0)

Suggested answer

Andrea Melroe 3,437 on at

Like (0)

Report

RE: Fixing Discount amount in an invoice distribution

Hi Shargri,

Thanks for the information! Elena is exactly right that the distribution entries default based on the setups and how the amounts are entered in the Payables Transaction Entry window.

With that being said, based on the screenshots you provided, I made some assumptions and I think I know what’s happening here.

Ultimately, what you’re seeing in GP is a valid message. Let me show you what I ‘think’ is happening:

It looks to me as though your payment terms are calculating at 2%.

If you take 466.25 and multiply that by 2%, you’ll get 9.325. This is what GP will do automatically when a payment term of 2% is defaulting into the Payables Transaction Entry window.

Now, GP must round 9.325 to the nearest decimal (to match your currency). GP always rounds up when the decimal is 5 or more.

As such, GP calculates 2% of 266.25 as 9.33.

If you click on the Blue Arrow next to the Payment Terms field, you’ll see this:

So, if you change the distributions so they don’t match what’s in the main window – the errors you are seeing will occur.

There is no way to tell GP to ‘round down’ in some instances.

However, if you open the Payables Payment Terms Entry window (by clicking the blue arrow next to Payment Terms): You can update the ‘Terms Disc. Available to be 9.32 instead of 9.33. If you do this, GP will remove the 2% from the Percent Amount field (which is fine). This will create a scenario where you can update your distributions to match without erring because the distributions now match what you see in the ‘main’ window (as Elena was stating):

I hope this helps!

Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP
Leng Papio 855 on at

Like (0)

Report

RE: Fixing Discount amount in an invoice distribution

Can you show the main entry please?

The distribution entries will default based on the setups and how the amounts are entered in the main window.

Why did you need to move a penny from avail to pay?
Shagri 5 on at

Like (0)

Report

RE: Fixing Discount amount in an invoice distribution

Please see my post below. For some reason I couldn't get the pictures on the reply.
Shagri 5 on at

Like (0)

Report

RE: Fixing Discount amount in an invoice distribution

This is the distribution that I get when I use the payment terms. This is the version that gets accepted without an error.

This is the version that gets an error message. The only difference between the versions is that I moved a penny from the AVAIL to the PAY. I did that because that is the actual amount we paid and I do not want our balance to be off.

This is the error message I am getting
Andrea Melroe 3,437 on at

Like (0)

Report

RE: Fixing Discount amount in an invoice distribution

Hi Shagri,

I’ve not seen that error occur unless it’s a valid error (meaning the distribution really does not match the discount amount). Are you trying to update the distribution to be something ‘other’ than what the discount amount shows on the transaction?

Can you share some screenshots that show the discount amount in the Payables Transaction entry window in comparison to the distribution in the Payables Distribution Entry window?

Can you show the payment terms setup for the payment term coming into play?

If this is a multicurrency transaction, what is the exchange rate being used on the transaction?

Thank You for using Dynamics Communities,

Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP