LP1174498: Add a Payments by Billing Type Reporting View
authorblake <blake@mobiusconsortium.org>
Tue, 31 Aug 2021 14:30:06 +0000 (09:30 -0500)
committerJason Boyer <JBoyer@equinoxOLI.org>
Mon, 13 Sep 2021 20:35:28 +0000 (16:35 -0400)
commit8a7ba94e8a8967cac5bbd50d5ad992d48d554c4e
treeb557ab4eff41e11d4a9c2027eb4aa5c8bd6f75a3
parent6534d34e01808787f9fe6f53ecfdcf9fa788176d
LP1174498: Add a Payments by Billing Type Reporting View

Fixed a bug where over payments cause duplicate rows.
In other words: negative balanced bills would bug this
logic.

Also fixed the release note syntax.

Signed-off-by: blake <blake@mobiusconsortium.org>
Signed-off-by: Jason Boyer <JBoyer@equinoxOLI.org>
Open-ILS/src/sql/Pg/080.schema.money.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.money.materialized_payment_by_billing_type.sql
docs/RELEASE_NOTES_NEXT/Reports/payments_by_billing_type.adoc