Precision required in ItemBill insert

Partner dazzle
2 Posts
Partner

Precision required in ItemBill insert

I have an Item Bill that I am trying to insert nad I am getting the error "Lines[0]" "the line total is unbalanced".

 

I understand what that means, however,

 

lines[0].Total = 314.7

lines[0].BillQuantity = 9

lines[0].UnitPrice = 34.97

 

Now 9 x 34.97 = 314.73 != 314.7

 

so I have calculated a discount percentage as follows:

 

lines[0].DiscountPercent = 100 * (lines[0].Total / (lines[0].BillQuantity * line[0].UnitPrice) - 1)

 

which, in this case, gives -0.0095319797922028405299780800

 

Working this back through:

 

lines[0].BillQuantity*lines[0].UnitPrice*(1+lines[0].DiscountPercent/100) = 314.69999999999999999999999999

 

Now 314.7 != 314.69999999999999999999999999 but it can't get any closer!

 

The rounding errors are baked into .net. How do I overcome this?

 

 

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post