Precision required in ItemBill insert

This thread is now archived and closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please post a new topic.
Partner dazzle
4 Posts

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
Get the conversation started and make a new post Start a Post