Decimals and Rounded values

  • Problem
  • Updated 3 years ago
  • In Progress
Hi guys,

I am implementing the multi currency function and I have met some problems with decimals and rounding on P/Os.

When changing the system to our “home currency” the P/O start to give some rounded values regarding the sub total for the individual order line. Also the sub total for the complete order as well as the VAT (if any) and Total have rounded values.

The math simply don’t add up when 2 pcs á 15.30 = 31 (I also manage to get 2 pcs á 15.30 = 31.00 when trying different setting for different vendors).

What I need is multi decimals (5 decimals) for the unit price, always 2 decimals (31.00 not 31) for sub totals, VAT and Total and no rounded values, please.

We are not only buying in our home currency, so the currency converter will be of great help for us. I have not checked, but I guess the recent problems also go for S/Os (we are mainly exporting in foreign currency).

We run the system in multi user mode on Windows server 2003. Most users are using Windows XP (32 bit) and there are some Vista PCs as well.

I hope you can guide me how to set up the system so I can get back on track again.

If you need more information, please let me know.

Best regards,

Goran
Photo of gurrab

gurrab

  • 28 Posts
  • 0 Reply Likes
  • unhappy

Posted 5 years ago

  • 6
Photo of Siobhan

Siobhan, Official Rep

  • 5342 Posts
  • 190 Reply Likes
Hi Goran,

Thanks for getting in touch and I'm very sorry to hear that you're having trouble with the conversions. Could you possibly confirm your main currency and the other currencies that you're working in? It might also be helpful if you feel comfortable providing your database so that we can have a look at the conversion behaviour.

If you could please make a backup and zip it into a compressed folder then send it to support@inflowinventory.com. If it's too large to e-mail please try using a service such as SendSpace.com or YouSendIt.com. Should you have any further questions or concerns please let us know.
Photo of Robert Voigt

Robert Voigt

  • 9 Posts
  • 0 Reply Likes
I sometimes have this problem when working with my SRD currency. In my sales order or quote i get to many numbers after the decimal.
Eg: must be SRD12.50 and i get SRD 12.5045

So please check and fix :(
Photo of Siobhan

Siobhan, Official Rep

  • 5342 Posts
  • 190 Reply Likes
Hi Robert,

Sorry for the delay in responding I think your request got lost in the shuffle over the weekend. Some parts of the system allow for a certain number of decimals as a rule, other allow them based on your region and language settings. Can you please have a look at those settings (START > Control Panel > Region and Language) and change the No. of digits after decimal to 2 then save and restart inFlow. Have a look at the system now and let us know if that makes any change to the way that your calculations appear.

Thank you in advance!

Cheers,