[Koha-bugs] [Bug 10461] New: tax not taken in to account in the acq budget summaries

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

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

            Bug ID: 10461
           Summary: tax not taken in to account in the acq budget
                    summaries
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: 3.10
          Hardware: All
               URL: acqui-home.pl
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Acquisitions
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: nengard at gmail.com

On acqui-home.pl the budget summary is not taking in to account tax rate at
all. The code looks something like this:


SELECT SUM( COALESCE(unitprice, ecost) * quantity ) AS sum FROM aqorders
WHERE budget_id = ? AND
quantityreceived > 0 AND
datecancellationprinted IS NULL

Plus

SELECT SUM(shipmentcost) AS sum
FROM aqinvoices
WHERE shipmentcost_budgetid = ?
AND closedate IS NOT NULL


Tax rate should be included in this to give an accurate count of what has been
spent/ordered.

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