[OPEN-ILS-GENERAL] Invoiced Charges report

2015-11-10 Thread Millissa Macomber
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,

Re: [OPEN-ILS-GENERAL] Invoiced Charges report

2015-11-10 Thread Chris Sharp
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: Tue

Re: [OPEN-ILS-GENERAL] Invoiced Charges report

2015-11-10 Thread Millissa Macomber
31499a99b230a96563bc2e"."recv_date") = '2015') GROUP BY 1, 2, 3, 4, 5, 6, 7, 8 ORDER BY "c7fd72fce171e6125c167f1a9cd0ff3d"."code" ASC, "b8d47ebddd4bb58f2f5a8c7291f5374f"."cost_billed" ASC, "8c5e0de219718b602282155b40ed28ba"."cod

Re: [OPEN-ILS-GENERAL] Invoiced Charges report

2015-11-10 Thread Chris Sharp
ginal Message - > From: "Millissa Macomber" <millis...@burlingtonwa.gov> > To: "Evergreen Discussion Group" <open-ils-general@list.georgialibraries.org> > Sent: Tuesday, November 10, 2015 1:22:47 PM > Subject: Re: [OPEN-ILS-GENERAL] Invoiced Charges report > I

Re: [OPEN-ILS-GENERAL] Invoiced Charges report

2015-11-10 Thread Chris Sharp
burlingtonwa.gov> > To: "Evergreen Discussion Group" <open-ils-general@list.georgialibraries.org> > Sent: Tuesday, November 10, 2015 12:49:54 PM > Subject: Re: [OPEN-ILS-GENERAL] Invoiced Charges report > > Chris, > > Hope this is what you were looking for:

Re: [OPEN-ILS-GENERAL] Invoiced Charges report

2015-11-10 Thread Millissa Macomber
OUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9 ORDER BY "c7fd72fce171e6125c167f1a9cd0ff3d"."code" ASC, "b8d47ebddd4bb58f2f5a8c7291f5374f"."cost_billed" ASC, "8c5e0de219718b602282155b40ed28ba"."code" ASC, "9f392d4af0e2769a043f7a6e1d696443".&qu