Comment 0 for bug 1681930

Revision history for this message
Blake GH (bmagic) wrote :

I discovered a value of "int" for "unvoided"
<field reporter:label="Unvoided Billing Amount" name="unvoided" reporter:datatype="int" />

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"

This affects reports