[Koha-bugs] [Bug 23981] New: Inconsistencies with the different prices

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23981

            Bug ID: 23981
           Summary: Inconsistencies with the different prices
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Acquisitions
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: caroline.cyr-la-rose at inlibro.com
        QA Contact: testopia at bugs.koha-community.org

I was investigating bug 18639 and I came across some inconsistencies in the
prices, where they are used, the calculations, etc.

To reproduce :
(Note: my vendor setting is "tax excluded" for both list and invoice price, I
tried with different settings and as far as I can tell, the result is the same)
1- Create a new basket
2- Add an order
3- In the financial details, enter the following informations (I know it
doesn't make sense IRL, but we are entering different prices just to see what
goes where):
   - Vendor price: 10.99
   - Tax rate: 0%
   - Discount: 0%
   - Retail price: 12.99
   - Replacement cost: 15.99
   - Actual cost: 18.99
4- Note that Budgeted cost and Total are based on *vendor* price (10.99)
5- Save your order
6- If you have access to your database, check the info that is entered (if you
don't have access to your database, you can do an SQL report with the following
query

SELECT * from aqorders where basketno = X;

Substitute de X for your basket number

My db shows the following:

listprice: 10.990000
unitprice: 18.990000
rrp: 12.99
replacementprice: 15.990000
rrp_tax_excluded: 12.990000
rrp_tax_included: 12.990000
ecost: 10.99
ecost_tax_excluded: 12.990000
ecost_tax_included: 12.990000

Note that the ecost_tax_excluded and ecost_tax_included are not based on ecost,
but on rrp.
7- Go back to acquisitions home page and click on the amount ordered in your
budget
8- Find your order and note that the estimated cost per unit is the retail
price (12.99), not the vendor price (10.99) and not the budgeted cost as
calculated during the order (10.99).
9- Close the basket
10- Receive the order
11- On the receipt summary page (which lists all the items yet to be received),
the unit cost is the retail price (12.99) and the replacement cost is correct
12- On the item receiving page, the retail price is correct, the replacement
price is correct, the budgeted cost is the retail price not the vendor price
(listprice) nor the budgeted cost calculated during the order (ecost), the
actual price is correct.
13- In the already received page, the prices are correct
14- In the "Spent column" of the budget, the price taken out of the fund is the
actual price, which is correct.

Summary:
- The vendor price/listprice is not used anywhere else than during the first
step of the order
- The budgeted cost (ecost) is based on the retail price, the order form needs
to reflect that

Propositions:
- Unless there is a good reason to keep it (like someone wanting to
discriminate between how much the vendor sells it vs how much another vendor
might sell it), I would remove the vendor price completely and replace it with
the retail price
- Correct the order form to show the real estimated price, based on the retail
price
- Correct the db calculations to make sure the ecost is based on the rrp and
that the tax are calculated on the ecost

I'm sorry if this is all over the place, hopefully by following the steps, you
will see what I mean.

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