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
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.
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.
The Trade Discount does equal the subtotal, which is equal the to the extended price of the 1 item.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (