Not Saving Item Price at 3 Decimal Places

[emre]

@philbkk

Depending on the numbers, the item price can end up being calculated to something like 3.3333333

I don’t recommend such pricing. When you force ticket to calculate as $9.9999 and appear as $10 you’ll tender 0.0001 more and that will lead to differences on taxes and long range reports. While setting up prices try to set up tender-able prices.

PS: [quote=“philbkk, post:4, topic:7706”]
(it ends up being STORED as 3.3300 when the Database decimals to set to 4).
[/quote]

That will work fine when SambaPOS is restarted. Database access objects needs to reload to work with updated decimal places.

@QMcKay

Maybe someone could explain the difference between the following settings, and how they inter-operate. How they are stored, rounded, calculated, and displayed could be confusing.

Some of them explained here.

SambaPOS Rounding Features

Hello. In this tutorial I’ll show you some rounding features of SambaPOS. I’ll demonstrate different rounding methods here so you can choose that fits fine to your business needs. ##Method 1: Automatic Rounding to Nearest Value Automatic rounding to nearest value means it can both increase or decrease ticket amount. So we’ll need two account transactions and ticket calculations here. By default SambaPOS has Discount and Rounding accounts. We’ll create two additional account transactions to dif…

Specifically…

Program Settings > Currency Decimals

Implemented to make SambaPOS currency decimal places to work fine for countries that have 3 decimal places like Bahrain. Database Decimal Places updates database currency fields to store that much decimals. Visible Decimal Places rounds values for screen.

Payment Screen Settings > Auto Rounding

Rounds order prices that appears on the left side of payment screen. These prices reflects discounts, tips, etc and that leads to non-tenderable prices like 3.24. By using that setting it is possible to round prices to 5, 25 or 50 cents.

Payment Screen Settings > Auto Decimals

[New 4.1.37] Auto Decimals on Payment Screen

After 4.1.37 release you’ll be able to use Auto Decimals feature on Payment Screen. [image] When enabled you can type decimal values without need of using decimal separator button. For example we assume payment amount is 18.95 and we’ll tender 18.50 [image] Typing 185 does no change but when you type one more digit 0 it will change Tendered value 1850 to 18.50 [image] That correction depends on Payment Due value. Here are some example fixes. Payment Due Tendered Value …

Maintenance > Change Decimal Places

Implemented to update decimal places as a maintenance to ensure database fields updated correctly. Might needed to fix possible decimal place issues.

Foreign Currency > Rounding

Rounds calculated amount in that foreign currency while Calculating amount with Exchange Rate.

Calculation Type > Rounding

Rounds the amount of the calculation to a tender-able price. For example $13.11 discount can be rounded to $13.10 if the smallest currency in that country is 10 cents.

@QMcKay

Do OS Regional/Locale settings have any affect as well?

Regional settings also affects how values appears on screen but it does not change how values are stored in database.