Sum of Order Lines net price after discount differs from total on header
Invoice Line# Description Unit Price Extended Price
55 BUXUS MIC GREEN BEAUTY 10.8500 108.50
56 Discount Applied from Discount Rule -1.6275 -16.28
60 Rounding Rule Adjustment Applied from Discount Rounding Rule -0.0025 -0.03
TOTAL 9.22 92.19
In the Sales Order Amount for that line is 92.20 and in the Invoice header it is 92.19 and 1 cent lost due to round off issues
We require 5 decimal precision on USD currency in other areas of the business but have configured a rounding rule to convert sales orders to two decimals so that customers understand the extended pricing.
What options are available to achieve complete agreement between a sum of the line extended pricing and the value on the header? We currently face challenges related to B2B data interchange trying to validate the two methods of summing to get the total as a check for the invoice.