Decimal Places In Currency Stored In Db

I was trying to find out why the price of an item that I have in my software which is fed to CS-Cart via API - changes when it's written into the store database as I am using GAAP standards - DECIMAL(13,4) which should be the way cs-cart stores it.



However, CS-Cart does not use GAAP standards to store currency. I was blown away.


  1. http://www.noelherri…cimal-for-money


  2. http://pixeljets.com…mals-not-floats



    This is standard. Good enough does not count when you are talking about money, it's fine when you are a scientist crunching big star data from the hubble, but not so much for currency.



    Now please let me know, because I may have missed it, is the latest version setup correctly or is it wrong as well similar to my version of 4.0.3 because personally this looks like it's going to be a lot of work to correct.

I suggest you to post this issue to CS-Cart bug tracker.

[quote name='eComLabs' timestamp='1421056197' post='202309']

I suggest you to post this issue to CS-Cart bug tracker.

[/quote]



Thanks, will take your advice.