Chris, Hope this is what you were looking for: SELECT "c7fd72fce171e6125c167f1a9cd0ff3d"."code" AS "Fund", "b8d47ebddd4bb58f2f5a8c7291f5374f"."cost_billed" AS "Cost Billed", "8c5e0de219718b602282155b40ed28ba"."code" AS "Vendor", "9f392d4af0e2769a043f7a6e1d696443"."name" AS "Type of charge", "2963bfebaa7ff587c42366b28fe762a3"."inv_ident" AS "Invoice number", "b8d47ebddd4bb58f2f5a8c7291f5374f"."title" AS "Additional information", "8e36cdcabf31499a99b230a96563bc2e"."recv_date" AS "Invoice Date", "136fa3f31fa570c5fbdd81dc2a07ec0d"."amount_paid" AS "Amount Paid" FROM acq.invoice_item AS "b8d47ebddd4bb58f2f5a8c7291f5374f" INNER JOIN acq.invoice_item_type AS "9f392d4af0e2769a043f7a6e1d696443" ON ("b8d47ebddd4bb58f2f5a8c7291f5374f"."inv_item_type" = "9f392d4af0e2769a043f7a6e1d696443"."code") LEFT OUTER JOIN acq.invoice AS "2963bfebaa7ff587c42366b28fe762a3" ON ("b8d47ebddd4bb58f2f5a8c7291f5374f"."invoice" = "2963bfebaa7ff587c42366b28fe762a3"."id") LEFT OUTER JOIN acq.invoice_entry AS "136fa3f31fa570c5fbdd81dc2a07ec0d" ON ("2963bfebaa7ff587c42366b28fe762a3"."id" = "136fa3f31fa570c5fbdd81dc2a07ec0d"."invoice") LEFT OUTER JOIN acq.invoice AS "8e36cdcabf31499a99b230a96563bc2e" ON ("136fa3f31fa570c5fbdd81dc2a07ec0d"."invoice" = "8e36cdcabf31499a99b230a96563bc2e"."id") INNER JOIN acq.provider AS "8c5e0de219718b602282155b40ed28ba" ON ("2963bfebaa7ff587c42366b28fe762a3"."provider" = "8c5e0de219718b602282155b40ed28ba"."id") INNER JOIN acq.fund AS "c7fd72fce171e6125c167f1a9cd0ff3d" ON ("b8d47ebddd4bb58f2f5a8c7291f5374f"."fund" = "c7fd72fce171e6125c167f1a9cd0ff3d"."id") WHERE ((EXTRACT(YEAR FROM "8e36cdcabf31499a99b230a96563bc2e"."recv_date")) IS NULL OR EXTRACT(YEAR FROM "8e36cdcabf31499a99b230a96563bc2e"."recv_date") = '2015') GROUP BY 1, 2, 3, 4, 5, 6, 7, 8 ORDER BY "c7fd72fce171e6125c167f1a9cd0ff3d"."code" ASC, "b8d47ebddd4bb58f2f5a8c7291f5374f"."cost_billed" ASC, "8c5e0de219718b602282155b40ed28ba"."code" ASC, "9f392d4af0e2769a043f7a6e1d696443"."name" ASC, "2963bfebaa7ff587c42366b28fe762a3"."inv_ident" ASC, "b8d47ebddd4bb58f2f5a8c7291f5374f"."title" ASC, "8e36cdcabf31499a99b230a96563bc2e"."recv_date" ASC, "136fa3f31fa570c5fbdd81dc2a07ec0d"."amount_paid" ASC
Back to output index Millissa -----Original Message----- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Chris Sharp Sent: Tuesday, November 10, 2015 8:29 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Invoiced Charges report Millissa, If you're able to, could you please share the "Generated SQL" section from the "Debugging Info" page from your reports output? That would allow others to see what you're doing and how it might be improved. Be sure to remove any private information from the text before sending. Chris ----- Original Message ----- > From: "Millissa Macomber" <millis...@burlingtonwa.gov> > To: "Evergreen Discussion Group (open-ils-general@list.georgialibraries.org)" > <open-ils-general@list.georgialibraries.org> > Sent: Tuesday, November 10, 2015 11:25:06 AM > Subject: [OPEN-ILS-GENERAL] Invoiced Charges report > > I have created a report that shows all of my invoiced charges but it > is hiding multiple charges for the same amount. (Instead of getting > three lines for $14.71 I only see one) Any thoughts? > > Millissa Macomber > Technical Services Coordinator > Burlington Public Library > 820 E. Washington Ave, > Burlington, WA 98233 > 360-755-0760 > burlingtonwa.gov > millis...@burlingtonwa.gov<mailto:millis...@burlingtonwa.gov> > > -- Chris Sharp PINES System Administrator Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 csh...@georgialibraries.org http://pines.georgialibraries.org/