fm_IDL reporter::xact_billing_totals incorrect column type
Bug #1681930 reported by
Blake GH
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned | ||
3.1 |
Fix Released
|
Medium
|
Unassigned | ||
3.2 |
Fix Released
|
Medium
|
Unassigned | ||
3.3 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
I discovered a value of "int" for "unvoided"
<field reporter:
The view puts the total unvoided sum of money* into that column:
sum(
CASE
WHEN b.voided THEN 0::numeric
ELSE b.amount
END) AS unvoided,
The datatype should be "money"
The same bug exists in reporter:
This affects reports
description: | updated |
tags: | added: billing bitesize reports |
Changed in evergreen: | |
milestone: | none → 3.3-rc |
Changed in evergreen: | |
milestone: | 3.3-rc → 3.3.1 |
Changed in evergreen: | |
milestone: | 3.3.1 → 3.3.2 |
Changed in evergreen: | |
importance: | Undecided → Medium |
Changed in evergreen: | |
milestone: | 3.3.2 → 3.3.3 |
Changed in evergreen: | |
milestone: | 3.3.3 → 3.4-beta1 |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
While looking into this, I found that xact_paid_total also had the incorrect type of int for unvoided amount, and corrected it as well.
working branch can be found here: https:/ /git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ gsams/LP1681930 _xact_billing_ totals_ incorrect_ column_ type