I’m unhappy

Decimals and Rounded values

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
5 people have
this problem
+1
Reply
  • 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.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited

  • 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 :(
    • Siobhan (Official Rep) May 30, 2012 16:18
      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,
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited