How does Sage 500 ERP calculate the trade discount and sales tax amounts? I keep getting the warning " Calculated Trade Discount Amt not the same as value passed in." after running the stored procedure, "spsoAPISalesOrdIns", and it keeps defaulting the value to 0. Any help on this would be appreciated.
Also, which stored procedures calculate these values?
I am not exactly sure what the spsoAPISalesOrdIns does. However, I received the same error message when I was importing Sales Orders. I had that message when the sum of the line items (details) discount did not match with the Sales Order (header) discount I imported.
I am calculating the trade discount correctly and am having no issues with discounts. But the message still appears when trying to calculate the sales tax