Decimal places for prices
If we wish to buy 200 small steel washers that are priced at £7.64 per 1000, what is the correct way to set-up the inventory item and its purchasing data, bearing in mind that 5 decimal places would be necessary, for the correct price calculation to be performed for the purchase order?
We have tried entering £0.00764 as the price for each washer, but there are insufficient decimal places to make the correct calculation, in terms of rounding for VAT.
Then we have tried creating a UoM called '1000' with a conversion factor of 1000 and entering £7.64 as the price, and by entering an order quantity of 0.2 (200/1000) we get the right price calculation. Unfortunately, after updating the PO order line, the Order Quantity field displays as zero, despite accepting 0.2 at point of entry.
We have already changed Standard Cost Decimal Places to 4, in System Parameters.
How would I go about modifying the code to allow 5 decimal places?
https://www.linkedin.com/in/andrewcouling
|