| mariovaldez.net http://www.mariovaldez.net/webapps/forums/ |
|
| Product Manager saves only two decimals of price http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=14&t=800 |
Page 1 of 1 |
| Author: | Jupaju [ 11 Aug 2007, 10:07 ] |
| Post subject: | Product Manager saves only two decimals of price |
Hi, I live in Finland and we must tell consumers prices always with taxes (22% VAT in this case) and that's why we need to think with the gross prices all the time. In result, when I add products with Product Manager, I only input the price with tax included (gross). The problem is that when I save, Product Manager only saves last two decimals to the DB altough it correctly calculates the price (net) with four decimals on the form. This generates super-annoying rounding errors, f.ex. I enter 10.90 to gross and the program calculates correctly the net of 8.9344 - but - saves 8.93 to the DB so when I open the product again, the gross is 10.8946, which rounds down to 10.89 instead of 10.90 in the shop. This is kind of urgent for me as I chose this program mostly because I can enter the price as I do now (otherwise Easy Populate would have done the trick) and it's a heck of a lot faster to use this great piece of sw than adding 100+ products through web interface. |
|
| Author: | CarlosVega [ 18 Aug 2007, 10:57 ] |
| Post subject: | Hi men |
I don´t speak english good but i tray.... I suppose that the problem this in the code. Already looked for if it´s not configuration? If it´s the code, I don´t believe that something can be done, wait for Mario. Sorry, My translation was bad. |
|
| Author: | mvaldez [ 25 Aug 2007, 07:34 ] |
| Post subject: | Rounding errors... |
Jupaju: > The problem is that when I save, Product Manager only saves last > two decimals to the DB altough it correctly calculates the price (net) > with four decimals on the form. This generates super-annoying > rounding errors... I'll check it out. I thought I had fixed those rounding error long time ago... Regards, Mario A. Valdez-Ramirez. |
|
| Page 1 of 1 | All times are UTC - 7 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|