You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Sum of Order Lines net price after discount differs from total on header

Example

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!