Unable to manipulate the rate (not enough decimal places) on item lines to achieve the correct summary total for a sales order with multiple items.
It is not typical but in our business, the total price of a sales order is based on a customized collection of items and a price is set for the bundle of items.
We then create lines for each of the items with a set quantity and a set term (i.e. one time billing, bill annually for 5 years, etc.) and do the math to work backwards to what the rate should be.
We have some custom fields (columns) but the basic calculation still applies (term*rate*quantity = amount).
Because the term and quantity are fixed, sometimes we have to manipulate the decimal places on the rate so that our overall total comes out to what we need it to be.
In most cases, we are able to achieve the correct total but sometimes not and we end up creating custom invoices.
Is there a better way to do this? Any insights would be appreciated?