What am I missing on getting this to work?  Thanks

Not that it would matter, because as far as I could tell that function is never called.

I changed the dec+2 to dec+4 in the ui_input.inc file, and changed the database x_prices table "price" column to DECIMAL(6,4). The database shows the 4dp but the values are still rounded to 2dp.

Please let me know where I'm going wrong.

//JAM  Allow entered unit prices to be fractional
function unit_amount_cells($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
{
    if (!isset($dec))
          $dec = user_price_dec()+2;

    amount_cells_ex($label, $name, 15, 15, $init, $params, $post_label, $dec+2);
}

Either 2 or 4 more decimal places are used when evaluating the unit amount.

If you extend the number of decimal places in the db table fields for unit price, the you can do all computations on unit_price with such more decimal places.

@joe: Is this issue addressed in FA 2.4?

It's odd that we can purchase items with prices to several decimal places but can sell only to two decimals.  I have items that are bought and sold in large volumes for fractions of pennies.

@joe: can @redoctober83's suggestion be taken into revising the formulae used in FA? Multiply rate with quantity first and then round off...

Bump.  Is this possible?  If it is, I would be so very very happy   Thanks.

Instead, it should take the total number of units, multiply it by the unit price out to however many decimmals that price is and then round the total price to 2 decimals.  Is ther a way to do that?

Thanks

We are new to FA (but find it an all round great product) and our old system worked in this way. This way you always have posted invoices on the system that match your suppliers.

Would be grateful if you could consider this for a future update.

Steve

DECIMAL_PLACES_INTERNAL (accounting use) and DECIMAL_PLACES_EXTERNAL (seen by customers)

The problem is that at some point you need to actually round from 3 places to 2 places so that when you deal with
the ledger you never have partial pennies, invoices and payments need to be exact.

These 3 decimal place costed items, do you often sell 1 or 2?

sounds like money... are you dealing with 1/8ths?

tom

Unfortunately that is not an option. What if I created a seperate  price_decimal_format function and used that for unit price??

Mike

/Joe

Some of our items are purchased at a unit price that contains 3 decimal places. Changing decimal places of prices/amounts in display setup changes all values throughout the system, and doesn't look good when most of your numbers only need to be 2 places.

Is it possible to have 3 decimal places on the unit price line and then 2 for all the totals or something along these lines??

Thanks,
Mike