[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Caroline Cyr La Rose changed: What|Removed |Added CC||philippe.blo...@inlibro.com -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Thibaud Guillot changed: What|Removed |Added CC||thibaud.guil...@biblibre.co ||m --- Comment #7 from Thibaud Guillot --- Hello You may wish to consult bug 35114, which I've opened. It's about price differences and miscalculations on baskets;) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 --- Comment #6 from Katrin Fischer --- (In reply to Mark Hofstetter from comment #5) > hi, > > I am not sure if our customer/we have the same problem but it seems to be > related - I just tested it with 23.06.00.079, just to clarify things for me > if I am looking the right place(s): > > IMHO the price should be deducted from fund WITHOUT the tax (but it is with > the the tax) I believe with tax is standard as most libraries have to pay it and you need the funds to reflect that. But there is CalculateFundValuesIncludingTax in 23.11 to change it. > 0) create a vendor > List prices: Include tax > Invoice prices: Don't include tax > > 1) placing an order: > cgi-bin/koha/acqui/neworderempty.pl?booksellerid=3=4 > > > Vendor price: 10 (tax inclusive) > Tax rate: 10% > Discount: 13% > Retail price: 10.00 (adjusted for USD, tax inclusive) > Replacement cost: 10.00 > Budgeted cost: 8.70 (tax inclusive) > Total: 8.70 (budgeted cost * quantity) > Actual cost: 0.00 > > ==> 10 * 0.87 > > 2) cgi-bin/koha/acqui/basket.pl?basketno=4 > RRP => 9.09 (10 / 1.1) Price - Tax ie > Budgeted cost tax ex => 7.91 ( 9.09 * 0.87 (13% Discount)) > total ex tax => 7.91 > GST => 0.79 (7,91 * 0.1 (10% Tax)) > > 3) Close Basket => Yes > > 4) > cgi-bin/koha/acqui/booksellers.pl?booksellerid=3 > Click receive Shipment > > fill in: > Vendor invoice: 123345 (some random number) > add no shippment costs > > 5) mark create book and click "Receive selected(1)" > > 6) mark item as received > Actual cost: 7.91 (tax exclusive) > > > 7) > Total tax exc.7.91 > Total (GST 10%) 0.79 > Total tax inc.8.70 > > there should be no tax because the vendor is tax excluded The vendor is not tax excluded, the setting means: the price is entered with or without tax. If you set a tax, it will still be calculated. You would need to set the tax percentage to 0 if you don't want tax. > > 8) > Secondary fundSecondary fund 1,000.000.000.008.70 > 8.70991.30 991.30 > > the full amount is deducted even if you are tax exempt There is no setting for tax exempt. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Mark Hofstetter changed: What|Removed |Added CC||k...@trust-box.at --- Comment #5 from Mark Hofstetter --- hi, I am not sure if our customer/we have the same problem but it seems to be related - I just tested it with 23.06.00.079, just to clarify things for me if I am looking the right place(s): IMHO the price should be deducted from fund WITHOUT the tax (but it is with the the tax) 0) create a vendor List prices: Include tax Invoice prices: Don't include tax 1) placing an order: cgi-bin/koha/acqui/neworderempty.pl?booksellerid=3=4 Vendor price: 10 (tax inclusive) Tax rate: 10% Discount: 13% Retail price: 10.00 (adjusted for USD, tax inclusive) Replacement cost: 10.00 Budgeted cost: 8.70 (tax inclusive) Total: 8.70 (budgeted cost * quantity) Actual cost: 0.00 ==> 10 * 0.87 2) cgi-bin/koha/acqui/basket.pl?basketno=4 RRP => 9.09 (10 / 1.1) Price - Tax ie Budgeted cost tax ex => 7.91 ( 9.09 * 0.87 (13% Discount)) total ex tax => 7.91 GST => 0.79 (7,91 * 0.1 (10% Tax)) 3) Close Basket => Yes 4) cgi-bin/koha/acqui/booksellers.pl?booksellerid=3 Click receive Shipment fill in: Vendor invoice: 123345 (some random number) add no shippment costs 5) mark create book and click "Receive selected(1)" 6) mark item as received Actual cost: 7.91 (tax exclusive) 7) Total tax exc. 7.91 Total (GST 10%) 0.79 Total tax inc. 8.70 there should be no tax because the vendor is tax excluded 8) Secondary fund Secondary fund 1,000.000.000.008.708.70 991.30 991.30 the full amount is deducted even if you are tax exempt -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Thibaud Guillot changed: What|Removed |Added See Also||https://bugs.koha-community ||.org/bugzilla3/show_bug.cgi ||?id=35114 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 --- Comment #4 from Caroline Cyr La Rose --- I made a table with the various terms used where : https://snipboard.io/wLaNtq.jpg -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 --- Comment #3 from Caroline Cyr La Rose --- I tested this again and it's still valid. The most annoying part is the ecost_tax_* is based on rrp rather than ecost. This means that the "budgeted cost" changes in various pages. Just from observations in the interface (i.e. without looking in the code), this is what is used where: When placing a new order (empty) (neworderempty.pl) - Vendor price = listprice (10.99) - Actual cost = uniprice (18.99) - Retail price = rrp (12.99) - Replacement cost = replacementprice (15.99) - Budgeted cost = ecost (10.99) ** When viewing the basket (basket.pl) - Actual cost tax exc. = unit_price_tax_excluded (18.99) - Replacement price = replacementprice (15.99) - RRP tax exc. = rrp_tax_excluded (12.99) - Budgeted cost tax exc. = ecost_tax_excluded (12.99) ** - Budgeted cost tax inc. = ecost_tax_included (12.99) ** When viewing ordered funds (ordered.pl) - Estimated cost per unit = rrp (12.99) ** When receiving the order (parcel.pl) - Unit cost = listprice (10.99) - Replacement price = replacementprice (15.99) - Order cost = ecost (10.99) ** When receiving the order (orderreceive.pl) - Actual cost = uniprice (18.99) - Retail price = rrp (12.99) - Replacement price = replacementprice (15.99) - Budgeted cost = ecost_tex_excluded (12.99) ** When viewing the invoice (invoice.pl) - Actual cost tax exc. = unitprice_tax_excluded (18.99) - Replacement price = replacementprice (15.99) When viewing spent funds (spent.pl) - Unit price = unitprice (18.99) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Caroline Cyr La Rose changed: What|Removed |Added See Also||https://bugs.koha-community ||.org/bugzilla3/show_bug.cgi ||?id=5062 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Séverine Queune changed: What|Removed |Added CC||severine.que...@bulac.fr -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Marjorie Barry-Vila changed: What|Removed |Added CC||marjorie.barry-vila@collect ||o.ca -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Martin Renvoize changed: What|Removed |Added Severity|enhancement |normal -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 --- Comment #2 from Caroline Cyr La Rose --- Created attachment 95118 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=95118=edit Screenshot showing the price fields Sorry again, just a minor thing. I noticed there is not prefilled "0.00" in the retail price field as there is with other price fields. See attached screenshot -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 --- Comment #1 from Caroline Cyr La Rose --- Another thing I noticed, when importing files into a basket, the fields are simply labeled "Price" and "Replacement price". Price is copied into every db field that is not replacementprice (rrp, ecost, listprice, unitprice, etc), so there is no risk of confusion here. However, we might want to relabel it Retail price? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Caroline Cyr La Rose changed: What|Removed |Added CC||caroline.cyr-la-rose@inlibr ||o.com -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 23981] Inconsistencies with the different prices
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981 Caroline Cyr La Rose changed: What|Removed |Added CC||katrin.fisc...@bsz-bw.de, ||martin.renvoize@ptfs-europe ||.com, ||n...@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/