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
Partner
dazzle
Partner

4Posts

1Kudos

0Solutions

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