Hello,
We are running into an issue with our Sales Order Net Amounts being off by .01. We are currently utilizing Trade Agreement Journals for Line Discounts to offer standard extended prices to our customers, but it appears that when a customer orders more than 1 of an item, the system takes the Unit Price * Qty then Subtracts the Discount amount. We need to take the Unit Price - Discount Amount THEN * qty.
Example:
Unit Price: 23.99
Line Discount: 17%
If a customer orders qty 5, the price in the net amount is 99.56, and the customer is expecting it to be 99.55. Because they receive 17% off these items, their extended price for this item is 23.99 - 4.08 (17%) = 19.91, so *5 is 99.55
The system is taking the base price of 23.99, multiplying it by the qty, 5, then calculating and subtracting the discount which equals to 99.56 in the Net Amount of the Sales Order
Any help would be very appreciated.
Thanks,
Kailey