[Koha-bugs] [Bug 13001] Refactor VAT and price calculation - parcel page

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13001

--- Comment #5 from Paola Rossi <paola.rossi at cineca.it> ---
(In reply to Jonathan Druart from comment #4)
> Created attachment 33677 [details] [review]
> Bug 13001: The total for received order should be based on the unitprice
> 
> For already received orders, the total should be calculated with the
> unitprice, not the estimated cost.

On master 3.17.00.057 HEAD "DBRev 3.17.00.057 (Koha 3.18 beta)",
relating to datas in file:
<http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=31895>
I changed the actual value to 70.00 on receiving (steps [9:12]). 
I hope it can help (and no errors).
---------------------------------------------------------------------


"-->" means "has been changed to"

qty      => quantity
rrp_et   => recommended retail price excluding tax
rrp_it   => recommended retail price including tax
discount => discount (%)
ecost_et => ecost excluding tax
ecost_it => ecost including tax
gstrate  => gst rate
gstvalue => gst value

I - Configuration 1 (0 0)
  List item price does not include tax
  Invoice item price does not include tax

9) On the receiving page (orderreceive.pl)
qty = 2
rrp = 82
ecost = 73.80
actual cost = 73.80 --> 70.00

10) On the parcel page (parcel.pl)
Est cost = 73.80
--> Actual cost 70.00
--> TOTAL 140.00
--> (Tax exc.) Subtotal Fund 147.60
--> (Tax exc.) Subtotal Est cost 140.00
total_et = 147.60 --> 140.00
gst = 7.38 --> 7
total_it = 154.98 --> 147.00

11) On the Acquisition home page (acqui-home.pl)
ordered = 5
spent = 147.6 --> 140.00

12) On the basket page (basket.pl
rrp_et = 82
ecost_et = 73.80
rrp_it = 86.10
ecost_it = 77.49
qty = 2
total_et = 147.60
total_it = 154.98
gstrate = 0.05
gstvalue = 7.38

II - Configuration 2 (1 1)
  List item price includes tax
  Invoice item price includes tax

9) On the receiving page (orderreceive.pl)
qty = 2
rrp = 82
ecost = 73.80
actual cost = 73.80 --> 70.00

10) On the parcel page (parcel.pl)
Est cost = 73.80
--> Actual cost 70.00
--> TOTAL 140.00
--> (Tax exc.) Subtotal Fund 147.60
--> (Tax exc.) Subtotal Est cost 140.00
total_et = 140.57 --> 133.33
gst = 7.03 --> 6.67
total_it = 147.60 --> 140.00


11) On the Acquisition home page (acqui-home.pl)
ordered = 5
spent = 147.6 --> 140.00

12) On the basket page (basket.pl
rrp_et = 78.10
ecost_et = 70.29
rrp_it = 82
ecost_it = 73.80
qty = 2
total_et = 140.58
total_it = 147.60
gstrate = 0.05
gstvalue = 7.02



III - Configuration 3 (1 0)
  List item price includes tax
  Invoice item price does not include tax

9) On the receiving page (orderreceive.pl)
qty = 2
rrp = 78.10
ecost = 70.29
actual cost = 70.29  --> 70.00

10) On the parcel page (parcel.pl)
Est cost = 70.29
--> Actual cost 70.00
--> TOTAL 140.00
--> (Tax exc.) Subtotal Fund 140.58
--> (Tax exc.) Subtotal Est cost 140.00
total_et = 140.58 --> 140.00
gst = 7.03 --> 7
total_it = 147.61 --> 147.00

11) On the Acquisition home page (acqui-home.pl)
ordered = 5
spent = 147.61 --> 147.00

12) On the basket page (basket.pl
rrp_et = 78.10
ecost_et = 70.29
rrp_it = 82.01 (yes 82.01...)
ecost_it = 73.80
qty = 2
total_et = 140.58
total_it = 147.60
gstrate = 0.05
gstvalue = 7.02

IV - Configuration 4 (0 1)
  List item price does not include tax
  Invoice item price includes tax

9) On the receiving page (orderreceive.pl)
qty = 2
rrp = 86.10
ecost = 77.49
actual cost = 77.49 --> 70.00

10) On the parcel page (parcel.pl)
Est cost = 77.49
--> Actual cost 70.00
--> TOTAL 140.00
--> (Tax exc.) Subtotal Fund 140.58 --> 154.98
--> (Tax exc.) Subtotal Est cost --> 140.00
total_et = 147.60 --> 133.33
gst = 7.38 --> 6.67
total_it = 154.98 --> 140.00

11) On the Acquisition home page (acqui-home.pl)
ordered = 5
spent = 147.6 --> 133.33

12) On the basket page (basket.pl
rrp_et = 82
ecost_et = 73.80
rrp_it = 86.10
ecost_it = 77.49
qty = 2
total_et = 147.60
total_it = 154.98
gstrate = 0.05
gstvalue = 7.38

-------------------------------------------------------------------

-- 
You are receiving this mail because:
You are watching all bug changes.