PO Unit Price Rounding Issue

Kinetic ERP
, ,
1

Hello,

I am new to our system here and wasn’t involved with our original implementation so still learning some nuances. Currently in Purchase Order Entry we do not have enough decimal spaces to put in full exact dollar amounts in the Unit Price Box on our Purchase Order Entry page. Because of this it prevents us from having accurate to the penny Purchase Orders to send to Suppliers and also for our AP to pay. I have attached an example where we needed the total for the PO to be $2801.92. That meant we needed to be able to enter 0.560384 into the Unit Price field (PODetail.DocScrUnitCost), but we ran out of characters and could not add the 4. So, then my PO could only be for $2801.90 as seen in the example.

image
image1744×800 73.6 KB

I had been seen something about leveraging a unit of measure conversion to be able to take this to the system max decimal places. Has anyone else run into this and could provide a recommendation? Thanks in advance.

2

5 is going to be your max.

And it is one way trip to change.

You can do this at your own risk in currency management.

Suggest you read the documentation on this and test it before applying to your production environment.

image
image860×767 31.9 KB

Max decimals are
General 0-3
Price 0-5
Cost 0-3

3

Change the cost per to /100 or /1000 and change your unit price accordingly.

3 Likes
4

Thanks all, being we were already at a max of 5 decimal places, we were able to adjust the cost per accordingly based on the unit price and we are able to get accurate dollar amounts now, just needed to move the decimal place :slight_smile: thanks!

1 Like