I am using tax included in sales price and if I use the product button I get the correct item listed as follows
P R O B L E M SO L V E D! (but only for calculation INCLUSIVE of VAT)
explanation see 3rd message below
1 x item XY Sales Price before tax 27.78 plus 8 % tax (2.22) equals 30.--
When I use the barcode scanner, the same item gives the following – wrong – prices:
1 x item XY Sales Price before tax 25.72 plus 8 % (2.06) tax equals 27.78
Obviously when using the barcode scanner the system first wrongly deducts the tax (27.78 – 2.06 = 25.72 and then adds the tax off the wrong base 25.72 to arrive at the wrong price of 27.78.)
Did anybody notice this problem and is there a solution to it?
Unicenta 3.90, Barcode Scanner Honeywell 1400 g, MYSQL, German localization
PS It looks to me like this is a bug, so I have now also made a bug report.
Last edit: werner 2015-01-03
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Adding a screen shot showing the problem:
Same product using
Line 1: Product button gives correct sales price of CHF 30.--
Line 2: Barcode scanner give wrong price of CHf 27.78 instead of CHF 30.-- = CHF 2.22 off
PS I have now tested v 3.70 and it is the last working version of Unicenta for Barcode scanners. 3.80, 3.81 and 3.90 are not usable as the sales prices calculations using a scanner produce entirely false figures.
@ Chris J - another thanks to you, you are a life saver
Just made another step on my learning curve: My remarks above are partly wrong. I just noticed Chris J's remark re the +/- sign left to the barcode symbol and retested:
quote "tax inclusief of tax exclusief
the 2nd button is for barcode (PLU) tap a barcode (PLU) and press this button.
chris J."unquote
Using the barcode scanner gave me a "wrong" sales price, at least so I thought. Now I realized that the sign MUST be on "+" to ensure that entering a product via product button gives the same (inclusive VAT) sales price as via barcode scanner. If it is on "-", the barcode scanner reads prices WITHOUT VAT, i.e. obviously the negative or positive sign is saved for scanner inputs.
Problem solved for: V 3.80, 3.81 and 3.90 DO work with barcode scanner, at least for getting the correct sales price. It is however only usable for prices inlusive VAT and I believe this method will likely lead to another problem later on if one is really required to be able to read prices without VAT because Unicenta creates an artificial sales price without VAT which is a figure which does not make sense at all.
In my examples in my first post:
Sales price invlusive VAT 30.-- - 8 % VAT = 27.78 Sales price without VAT. This is the only correct version.
Using the scanner with "-" = Without VAT gives the correct sales prices 27.78 but at the same time creates a new funny calculation as follows which does not make sense but likely will lead to faulty statistics:
Sales price inclusive VAT 25.72 (+ then adds an incorrect 8 % tax calculated off the wrong base of 25.72 in the above example to arrive at the correct NET of VAT sales price of 27.78. Correct would be 27.78 net /net.
I think anbody using "Without VAT" should be aware of this.
I did notice however, that at least with version 3.70 this function does not exist, i.e. scanner inputs with both "+" and "-" give the same price.
Last edit: werner 2015-01-03
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well, I went back and tested it again V.3.90 and am now getting totally confused but am not even entirely sure if the result is really different this time or whether I just did not notice last time as it kind of would not make sense:
Product button: gives me the correct end value CHF 30.-- VAT included
Scanner "-" which my interpretation was "do not charge VAT": gives me the same value of CHF 30.-- VAT included (but testing before gave me 27.78 (which would be correct end price without VAT
Scanner "+" which my interpretation was "DO charge VAT": now gives me end value of CHF 27.78 without VAT but before I got CHF 30 with VAT
it does not matter if I change the slider to different VAT rates, I always get the same figure, only "-/+" make the change. So it must take the calculation from Stock input. The slider appears only to be working for entering unlisted products using the "free" form, which is ok.
Basically I can live with this because I always use inclusive of VAT, it just makes me a bit nervous that scanner input can so easily be changed/manipulated and - particularly if using a touchscreen can so easily be changed accidentally (from - to +) without even noticing and then charge the the wrong price. (We need to sell some item using the "free input" form, without using the barcode scanner which increases the risk to accidentally change "-" to "+".) So one has always to be on alert to this and I still am of the opinion that this should be rectified in the program, the more because Unicenta still always calculates an entirely misleading artificial and faulty "price without VAT of 25.72 in my example" if without VAT is used. Correct price with and without VAT should be 27.78 if "do not add VAT" is used.
Nevertheless: a big thank you to you, because you put me on the right path with your highlighting the +/- function which enables me to use V.3.80 or 3.90
Last edit: werner 2015-01-05
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am using tax included in sales price and if I use the product button I get the correct item listed as follows
P R O B L E M SO L V E D! (but only for calculation INCLUSIVE of VAT)
explanation see 3rd message below
1 x item XY Sales Price before tax 27.78 plus 8 % tax (2.22) equals 30.--
When I use the barcode scanner, the same item gives the following – wrong – prices:
1 x item XY Sales Price before tax 25.72 plus 8 % (2.06) tax equals 27.78
Obviously when using the barcode scanner the system first wrongly deducts the tax (27.78 – 2.06 = 25.72 and then adds the tax off the wrong base 25.72 to arrive at the wrong price of 27.78.)
Did anybody notice this problem and is there a solution to it?
Unicenta 3.90, Barcode Scanner Honeywell 1400 g, MYSQL, German localization
PS It looks to me like this is a bug, so I have now also made a bug report.
Last edit: werner 2015-01-03
Adding a screen shot showing the problem:
Same product using
Line 1: Product button gives correct sales price of CHF 30.--
Line 2: Barcode scanner give wrong price of CHf 27.78 instead of CHF 30.-- = CHF 2.22 off
PS I have now tested v 3.70 and it is the last working version of Unicenta for Barcode scanners. 3.80, 3.81 and 3.90 are not usable as the sales prices calculations using a scanner produce entirely false figures.
Last edit: werner 2015-01-02
@ Chris J - another thanks to you, you are a life saver
Just made another step on my learning curve: My remarks above are partly wrong. I just noticed Chris J's remark re the +/- sign left to the barcode symbol and retested:
quote "tax inclusief of tax exclusief
the 2nd button is for barcode (PLU) tap a barcode (PLU) and press this button.
chris J."unquote
Using the barcode scanner gave me a "wrong" sales price, at least so I thought. Now I realized that the sign MUST be on "+" to ensure that entering a product via product button gives the same (inclusive VAT) sales price as via barcode scanner. If it is on "-", the barcode scanner reads prices WITHOUT VAT, i.e. obviously the negative or positive sign is saved for scanner inputs.
Problem solved for: V 3.80, 3.81 and 3.90 DO work with barcode scanner, at least for getting the correct sales price. It is however only usable for prices inlusive VAT and I believe this method will likely lead to another problem later on if one is really required to be able to read prices without VAT because Unicenta creates an artificial sales price without VAT which is a figure which does not make sense at all.
In my examples in my first post:
Sales price invlusive VAT 30.-- - 8 % VAT = 27.78 Sales price without VAT. This is the only correct version.
Using the scanner with "-" = Without VAT gives the correct sales prices 27.78 but at the same time creates a new funny calculation as follows which does not make sense but likely will lead to faulty statistics:
Sales price inclusive VAT 25.72 (+ then adds an incorrect 8 % tax calculated off the wrong base of 25.72 in the above example to arrive at the correct NET of VAT sales price of 27.78. Correct would be 27.78 net /net.
I think anbody using "Without VAT" should be aware of this.
I did notice however, that at least with version 3.70 this function does not exist, i.e. scanner inputs with both "+" and "-" give the same price.
Last edit: werner 2015-01-03
unicenta used to calculate the tax probably this value. see picture
Chris J.
Well, I went back and tested it again V.3.90 and am now getting totally confused but am not even entirely sure if the result is really different this time or whether I just did not notice last time as it kind of would not make sense:
Product button: gives me the correct end value CHF 30.-- VAT included
Scanner "-" which my interpretation was "do not charge VAT": gives me the same value of CHF 30.-- VAT included (but testing before gave me 27.78 (which would be correct end price without VAT
Scanner "+" which my interpretation was "DO charge VAT": now gives me end value of CHF 27.78 without VAT but before I got CHF 30 with VAT
it does not matter if I change the slider to different VAT rates, I always get the same figure, only "-/+" make the change. So it must take the calculation from Stock input. The slider appears only to be working for entering unlisted products using the "free" form, which is ok.
Basically I can live with this because I always use inclusive of VAT, it just makes me a bit nervous that scanner input can so easily be changed/manipulated and - particularly if using a touchscreen can so easily be changed accidentally (from - to +) without even noticing and then charge the the wrong price. (We need to sell some item using the "free input" form, without using the barcode scanner which increases the risk to accidentally change "-" to "+".) So one has always to be on alert to this and I still am of the opinion that this should be rectified in the program, the more because Unicenta still always calculates an entirely misleading artificial and faulty "price without VAT of 25.72 in my example" if without VAT is used. Correct price with and without VAT should be 27.78 if "do not add VAT" is used.
Nevertheless: a big thank you to you, because you put me on the right path with your highlighting the +/- function which enables me to use V.3.80 or 3.90
Last edit: werner 2015-01-05
Hi i'm using universa 3.9 and by using the barcode y get a different price value.
I made some tesis and i found the error is present if i use the ean-13 code, in the other hand if i use a shorter code then the error is not present.
I attach an image