bug in Acquisition module, regarding VAT management ?
Hello We think we have found a bug in Acquisition module, regarding VAT management, but we want to be sure. Let's take a book whose *recommended retail price excluding tax *is 39 euros. On the vendor's website, I import the record for this book in iso2709 In the record (UNIMARC), the price is in 010$d after the ISBN. So, I found : $d39.00 EUR I stage this record in Koha with Stage Marc Records Tools. In Acquisition module, I create a vendor with: - List item price includes tax: Yes - Invoice item price includes tax: Yes - Discount: 9.0000 % - Tax rate: 5.5% I create a new basket for this vendor. I fill this basket with my stage record. I think I should have for the command line in this basket : - RRP tax included : 39 euros - Ecost tax included : 39 euros - 3,51 euros = 35,49 euros - RRP tax excluded : 39*100/105.5 = 36,96 euros - Ecost tax excluded : 35,49*100/105.5 = 33,63 euros *BUT instead I see the following values : * - RRP tax included : 42.86 euros - Ecost tax included : 39 euros - RRP tax excluded : 40,63 - Ecost tax excluded : 36,97 So, Koha considered the "39 euros" value in my record as a Ecost price. I dont think it is normal, as as chose "List item price includes tax: Yes" in vendor record. Do you agree with me? -- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby@univ-rennes2.fr
Hello As nobody anwered I suppose it is a bug. I will create a bug in Bugzilla. M. Saby Mathieu Saby a écrit :
Hello We think we have found a bug in Acquisition module, regarding VAT management, but we want to be sure.
Let's take a book whose *recommended retail price excluding tax *is 39 euros. On the vendor's website, I import the record for this book in iso2709 In the record (UNIMARC), the price is in 010$d after the ISBN. So, I found : $d39.00 EUR I stage this record in Koha with Stage Marc Records Tools.
In Acquisition module, I create a vendor with: - List item price includes tax: Yes - Invoice item price includes tax: Yes - Discount: 9.0000 % - Tax rate: 5.5%
I create a new basket for this vendor. I fill this basket with my stage record.
I think I should have for the command line in this basket : - RRP tax included : 39 euros - Ecost tax included : 39 euros - 3,51 euros = 35,49 euros - RRP tax excluded : 39*100/105.5 = 36,96 euros - Ecost tax excluded : 35,49*100/105.5 = 33,63 euros
*BUT instead I see the following values : * - RRP tax included : 42.86 euros - Ecost tax included : 39 euros - RRP tax excluded : 40,63 - Ecost tax excluded : 36,97
So, Koha considered the "39 euros" value in my record as a Ecost price. I dont think it is normal, as as chose "List item price includes tax: Yes" in vendor record. Do you agree with me?
-- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby@univ-rennes2.fr
------------------------------------------------------------------------
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby@univ-rennes2.fr
Hi Mathieu, from your description it looks like a bug to me too. I think what we need is documentation how each price element should be calculated for each vendor setting. I often wonder – is it really a bug or is it miscalculation on my part? Thank you for taking the time to document this! Katrin From: koha-devel-bounces@lists.koha-community.org [mailto:koha-devel-bounces@lists.koha-community.org] On Behalf Of Mathieu Saby Sent: Thursday, December 13, 2012 12:16 PM To: Koha Devel; koha@lists.katipo.co.nz Subject: Re: [Koha-devel] bug in Acquisition module, regarding VAT management ? Hello As nobody anwered I suppose it is a bug. I will create a bug in Bugzilla. M. Saby Mathieu Saby a écrit : Hello We think we have found a bug in Acquisition module, regarding VAT management, but we want to be sure. Let's take a book whose recommended retail price excluding tax is 39 euros. On the vendor's website, I import the record for this book in iso2709 In the record (UNIMARC), the price is in 010$d after the ISBN. So, I found : $d39.00 EUR I stage this record in Koha with Stage Marc Records Tools. In Acquisition module, I create a vendor with: - List item price includes tax: Yes - Invoice item price includes tax: Yes - Discount: 9.0000 % - Tax rate: 5.5% I create a new basket for this vendor. I fill this basket with my stage record. I think I should have for the command line in this basket : - RRP tax included : 39 euros - Ecost tax included : 39 euros - 3,51 euros = 35,49 euros - RRP tax excluded : 39*100/105.5 = 36,96 euros - Ecost tax excluded : 35,49*100/105.5 = 33,63 euros BUT instead I see the following values : - RRP tax included : 42.86 euros - Ecost tax included : 39 euros - RRP tax excluded : 40,63 - Ecost tax excluded : 36,97 So, Koha considered the "39 euros" value in my record as a Ecost price. I dont think it is normal, as as chose "List item price includes tax: Yes" in vendor record. Do you agree with me? -- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby@univ-rennes2.fr ________________________________ _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ -- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby@univ-rennes2.fr
Hi Here is my bug : http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9280 I don't know exactly what is the meaning of "list item price" in vendor records, but I am not fluent in english... Fischer, Katrin a écrit :
Hi Mathieu,
from your description it looks like a bug to me too. I think what we need is documentation how each price element should be calculated for each vendor setting.
Good idea!
I often wonder – is it really a bug or is it miscalculation on my part?
Thank you for taking the time to document this!
Katrin
Mathieu
*From:* koha-devel-bounces@lists.koha-community.org [mailto:koha-devel-bounces@lists.koha-community.org] *On Behalf Of *Mathieu Saby *Sent:* Thursday, December 13, 2012 12:16 PM *To:* Koha Devel; koha@lists.katipo.co.nz *Subject:* Re: [Koha-devel] bug in Acquisition module, regarding VAT management ?
Hello As nobody anwered I suppose it is a bug. I will create a bug in Bugzilla.
M. Saby
Mathieu Saby a écrit :
Hello We think we have found a bug in Acquisition module, regarding VAT management, but we want to be sure.
Let's take a book whose *recommended retail price excluding tax *is 39 euros. On the vendor's website, I import the record for this book in iso2709 In the record (UNIMARC), the price is in 010$d after the ISBN. So, I found : $d39.00 EUR I stage this record in Koha with Stage Marc Records Tools.
In Acquisition module, I create a vendor with: - List item price includes tax: Yes - Invoice item price includes tax: Yes - Discount: 9.0000 % - Tax rate: 5.5%
I create a new basket for this vendor. I fill this basket with my stage record.
I think I should have for the command line in this basket : - RRP tax included : 39 euros - Ecost tax included : 39 euros - 3,51 euros = 35,49 euros - RRP tax excluded : 39*100/105.5 = 36,96 euros - Ecost tax excluded : 35,49*100/105.5 = 33,63 euros
*BUT instead I see the following values : * - RRP tax included : 42.86 euros - Ecost tax included : 39 euros - RRP tax excluded : 40,63 - Ecost tax excluded : 36,97
So, Koha considered the "39 euros" value in my record as a Ecost price. I dont think it is normal, as as chose "List item price includes tax: Yes" in vendor record. Do you agree with me?
-- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby@univ-rennes2.fr <mailto:mathieu.saby@univ-rennes2.fr>
------------------------------------------------------------------------
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org <mailto:Koha-devel@lists.koha-community.org> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby@univ-rennes2.fr <mailto:mathieu.saby@univ-rennes2.fr>
-- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby@univ-rennes2.fr
At 02:14 PM 12/13/2012 +0100, Mathieu Saby wrote:
Hi Here is my bug : http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9280
I don't know exactly what is the meaning of "list item price" in vendor records, but I am not fluent in english...
Mathieu - assuming it is "retail price" (which we certainly do in this context), then it's 'prix de vente au détail' or 'prix de vente public.' Bonnes fêtes de fin d'année a+ Paul
participants (3)
-
Fischer, Katrin -
Mathieu Saby -
Paul