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) / Trade Discount Amount ...
Microsoft Dynamics GP (Archived)

Trade Discount Amount error using eConnect

(0) ShareShare
ReportReport
Posted on by Christel.Lewis 90

I'm trying to update a SOP record using eConnect.  The record has a trade discount equal to the subtotal and has 1 item.  When I decrease the quantity on the item and try to save the record,  I get the following error:

Error Number = 8161  Stored Procedure taSopHdrRecalc  Error Description = Trade Discount Amount can not exceed Subtotal

Any ideas??

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    This is a standard GP error message. You can't discount more that the invoice subtotal - otherwise you end up with a minus figure. The subtotal is calculated from the extended price values of each line...so when you reduce the line, the subtotal reduces to an amount below the recorded Trade Discount amount (or at least it tries).

    Try editing the Trade Discount amount to be the same as the new sub total, and resending the document.

    Ian.

  • Christel.Lewis Profile Picture
    Christel.Lewis 90 on at

    The Trade Discount does equal the subtotal, which is equal the to the extended price of the 1 item.  

  • Community Member Profile Picture
    Community Member on at

    Understood - but if you decrease the quantity of the item, then the extended price also changes, so then the  subtotal will also change....but the Trade Discount won't.

    So if you started with the Trade Discount being the same as the Subtotal....then the Trade Discount would be more that the New Subtotal...which isn't allowed.

    Hope this explains.

    Ian.

  • Christel.Lewis Profile Picture
    Christel.Lewis 90 on at

    Sorry, what I should have said is when I update the document, the extended price, the subtotal, the trade discount are all equal. When I first bring up the document they are all equal at $21.00.  Then I update the quantity and change it from 50 to 40 so the extended price is $16.80 along with the subtotal and discount. This example has us discounting the document at 100%. When I try to save the document, I get the error.  I hope this clears up the confusion of how I am getting the error.

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