[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,
Burlington, WA 98233
360-755-0760
burlingtonwa.gov
millis...@burlingtonwa.gov

Re: [OPEN-ILS-GENERAL] Announcement: new core committer named - Kathy Lussier

2015-11-10 Thread Mary Llewellyn 
Congratulations, Kathy!

Mary


On Mon, Nov 9, 2015 at 1:33 PM, Galen Charlton  wrote:

> Hi,
>
> By consensus of the incumbent members, Kathy Lussier of MassLNC was
> invited to join the core committer team, and has accepted that
> invitation. Congratulations!
>
> An announcement on the Evergreen blog can be found here:
>
>
> https://evergreen-ils.org/welcome-evergreens-newest-core-committer-kathy-lussier/
>
> Regards,
>
> Galen
> --
> Galen Charlton
> Infrastructure and Added Services Manager
> Equinox Software, Inc. / The Open Source Experts
> email:  g...@esilibrary.com
> direct: +1 770-709-5581
> cell:   +1 404-984-4366
> skype:  gmcharlt
> web:http://www.esilibrary.com/
> Supporting Koha and Evergreen: http://koha-community.org &
> http://evergreen-ils.org
>



-- 
Mary Llewellyn
Database Manager
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
mllew...@biblio.org

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

2015-11-10 Thread Chris Sharp 
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" 
> To: "Evergreen Discussion Group (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
> 
> 

-- 
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/

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

2015-11-10 Thread Millissa Macomber 
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" 
> To: "Evergreen Discussion Group (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
> 
> 

--
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/

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

2015-11-10 Thread Chris Sharp 
Millissa, 

No, that's not the right field for what I was suggesting. Assuming you're using 
"Invoice" as the reporting source, the path to the field I'm talking about 
would be Invoice -> Invoice Entries -> ID. More explicitly, click the small 
arrow beside "Invoice" so it expands the sources linked to it, then click on 
the text "Invoice Entries", then select "ID" from the list in the "Field Name" 
(middle) pane. 

Screenshot shows what I'm looking at. 

Let me know if that's not clear. 

Thanks, 

Chris 

- Original Message -

> From: "Millissa Macomber" 
> To: "Evergreen Discussion Group" 
> Sent: Tuesday, November 10, 2015 1:22:47 PM
> Subject: Re: [OPEN-ILS-GENERAL] Invoiced Charges report

> I added ID from the Non-bibliographic Invoice Item menu. Is that the one you
> were suggesting? My report still doesn't show multiple items for the same
> price.

> SELECT * FROM (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",
> "b8d47ebddd4bb58f2f5a8c7291f5374f"."id" AS "ID"
> FROM acq.invoice_item AS "b8d47ebddd4bb58f2f5a8c7291f5374f"
> 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.invoice_item_type AS "9f392d4af0e2769a043f7a6e1d696443" ON
> ("b8d47ebddd4bb58f2f5a8c7291f5374f"."inv_item_type" =
> "9f392d4af0e2769a043f7a6e1d696443"."code")
> 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") = $_21677$2015$_21677$)
> GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9
> 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,
> "b8d47ebddd4bb58f2f5a8c7291f5374f"."id" ASC
> ) limited_to_1048575_hits LIMIT 1048575

> 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 10:03 AM
> To: Evergreen Discussion Group
> Subject: Re: [OPEN-ILS-GENERAL] Invoiced Charges report

> Millissa,

> Perfect. One suggestion that might work would to be to display (i.e., add to
> Displayed Fields) the Invoice Entry ID, so you can see each one. Could you
> try that and see if it works?

> Thanks,

> Chris

> - Original Message -
> > From: "Millissa Macomber" 
> > To: "Evergreen Discussion Group"
> > 
> > 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:
> > 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" =
> >

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

2015-11-10 Thread Chris Sharp 
Millissa,

Perfect.  One suggestion that might work would to be to display (i.e., add to 
Displayed Fields) the Invoice Entry ID, so you can see each one.  Could you try 
that and see if it works?

Thanks,

Chris

- Original Message -
> From: "Millissa Macomber" 
> To: "Evergreen Discussion Group" 
> 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:
> 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"
>   FROMacq.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" 
> > To: "Evergreen Discussion Group
> > (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
> > 
> > 
> 
> --
> 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/
> 

-- 
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/

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

2015-11-10 Thread Millissa Macomber 
I added ID from the Non-bibliographic Invoice Item menu. Is that the one you 
were suggesting? My report still doesn't show multiple items for the same 
price. 

SELECT * FROM (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",
"b8d47ebddd4bb58f2f5a8c7291f5374f"."id" AS "ID"
  FROM  acq.invoice_item AS "b8d47ebddd4bb58f2f5a8c7291f5374f"
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.invoice_item_type AS "9f392d4af0e2769a043f7a6e1d696443" 
ON ("b8d47ebddd4bb58f2f5a8c7291f5374f"."inv_item_type" = 
"9f392d4af0e2769a043f7a6e1d696443"."code")
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") = 
$_21677$2015$_21677$)
  GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9
  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, 
"b8d47ebddd4bb58f2f5a8c7291f5374f"."id" ASC
) limited_to_1048575_hits LIMIT 1048575

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 10:03 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Invoiced Charges report

Millissa,

Perfect.  One suggestion that might work would to be to display (i.e., add to 
Displayed Fields) the Invoice Entry ID, so you can see each one.  Could you try 
that and see if it works?

Thanks,

Chris

- Original Message -
> From: "Millissa Macomber" 
> To: "Evergreen Discussion Group" 
> 
> 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:
> 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"
>   FROMacq.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" =
>

[OPEN-ILS-GENERAL] Evergreen Test Writing Day 2

2015-11-10 Thread liam . whalen 
I am scheduling the next Evergreen Test Writing Day for Friday,  
November 20th from 1:00 PM to 3:00 PM EST, 10:00 PM to 12:00 PM PST.


I will create some launchpad tickets for tests to write.  There are  
some remaining from the previous Test Writing Day, so I will add to  
those.  Feel free to add your own.  Please tag items for this event  
with the test-writing-day-1 tag. Alternatively, there is a tag  
needstest that exists.  Feel free to use that, and I will add the  
test-writing-day-1 tag to it before the 20th.


Liam

[OPEN-ILS-GENERAL] Test Writing Day Moved

2015-11-10 Thread liam . whalen 
As I sent the email scheduling the test writing day, I had another  
participant in the poll.  The day that now works for all poll  
participants is Tuesday, November 17th from 1:00 PM to 3:00 PM EST  
(10:00 AM to 12:00 PM PST).  So, I am moving test writing day to the  
17th.


Liam

Re: [OPEN-ILS-GENERAL] November Bug Squashing Day

2015-11-10 Thread Kathy Lussier 

Hi all,

The date of the next community Bug Squashing Day will be Tuesday, 
December 15.


If you need a Sandbox to test a bug fix on that day, please fill out the 
Sandbox Request form by the end of the day Thursday, December 10. The 
request form is available at http://goo.gl/forms/fVVhWtAiW6.


More information about bug squashing day is available at 
http://wiki.evergreen-ils.org/doku.php?id=dev:bug_squashing.


Thanks all!
Kathy



On 10/26/2015 01:20 PM, Kathy Lussier wrote:

Hi all,

Test! Code! Wrangle! It's time for another Bug Squashing Day!

Unfortunately, I missed scheduling our quarterly Bug Squashing Day in 
August, but that just means we have lots of new patches added to LP 
that need testing and many new bugs submitted that need confirmation 
and fixes.


We're targeting the week of November 16 for our next Bug Squashing Day.

For those who have never participated in Bug Squashing Day, it's a 
great way for the entire community to help reduce the number of bugs 
in Evergreen. Once again, MassLNC and MOBIUS will be loading patches 
on Sandboxes so that others can test patches with the goal of getting 
those fixes tested and merged into Evergreen as soon as we can.


More details are available at 
http://wiki.evergreen-ils.org/doku.php?id=dev:bug_squashing.


If you're interested, please fill out the Doodle poll at 
http://doodle.com/poll/342rw66h3ka52epi to let us know which date 
works best for you.


Kathy



--
Kathy Lussier
Project Coordinator
Massachusetts Library Network Cooperative
(508) 343-0128
kluss...@masslnc.org
Twitter: http://www.twitter.com/kmlussier

Re: [OPEN-ILS-GENERAL] Announcement: new core committer named - Kathy Lussier

2015-11-10 Thread Martha Driscoll 
Congratulations to Kathy and to the Evergreen community for electing 
Kathy as a core committer.


The MassLNC networks have been very fortunate to have Kathy coordinate 
our various Evergreen projects from writing software specifications, 
reaching out to funding partners, coordinating proposals to developers, 
coordinating meetings and conferences, and testing new code.  All this 
and she bakes us cookies too!


Kathy's hard work will continue to improve an already great open source 
community.


Martha Driscoll
Systems Manager
North of Boston Library Exchange
Danvers, Massachusetts
www.noblenet.org

On 11/9/2015 1:33 PM, Galen Charlton wrote:

Hi,

By consensus of the incumbent members, Kathy Lussier of MassLNC was
invited to join the core committer team, and has accepted that
invitation. Congratulations!

An announcement on the Evergreen blog can be found here:

https://evergreen-ils.org/welcome-evergreens-newest-core-committer-kathy-lussier/

Regards,

Galen



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Re: [OPEN-ILS-GENERAL] Announcement: new core committer named - Kathy Lussier

2015-11-10 Thread Grace Dunbar 
Congratulations, Kathy!

On Mon, Nov 9, 2015 at 3:12 PM, Blake Henderson 
wrote:

> Congratulations Kathy!
>
> -Blake-
> Conducting Magic
> MOBIUS573-234-4513877-312-3517
>
> On 11/9/2015 1:18 PM, Tim Spindler wrote:
>
> Congratulations Kathy!
>
> On Mon, Nov 9, 2015 at 2:16 PM, Ruth Frasur <
> direc...@hagerstownlibrary.org> wrote:
>
>> Congratulations, Kathy!
>>
>> On Mon, Nov 9, 2015 at 1:39 PM, McCanna, Terran <
>> tmcca...@georgialibraries.org> wrote:
>>
>>> Congratulations, Kathy!
>>>
>>>
>>> Terran McCanna
>>> PINES Program Manager
>>> Georgia Public Library Service
>>> 1800 Century Place, Suite 150
>>> Atlanta, GA 30345
>>> 404-235-7138
>>> tmcca...@georgialibraries.org
>>> - Original Message -
>>> From: "Galen Charlton" < g...@esilibrary.com>
>>> To: "Evergreen Development Discussion List" <
>>> open-ils-...@list.georgialibraries.org>
>>> Cc: "Evergreen Discussion Group" <
>>> 
>>> open-ils-general@list.georgialibraries.org>
>>> Sent: Monday, November 9, 2015 1:33:25 PM
>>> Subject: [OPEN-ILS-GENERAL] Announcement: new core committer named -
>>> Kathy  Lussier
>>>
>>> Hi,
>>>
>>> By consensus of the incumbent members, Kathy Lussier of MassLNC was
>>> invited to join the core committer team, and has accepted that
>>> invitation. Congratulations!
>>>
>>> An announcement on the Evergreen blog can be found here:
>>>
>>>
>>> https://evergreen-ils.org/welcome-evergreens-newest-core-committer-kathy-lussier/
>>>
>>> Regards,
>>>
>>> Galen
>>> --
>>> Galen Charlton
>>> Infrastructure and Added Services Manager
>>> Equinox Software, Inc. / The Open Source Experts
>>> email:  g...@esilibrary.com
>>> direct: +1 770-709-5581 <%2B1%20770-709-5581>
>>> cell:   +1 404-984-4366 <%2B1%20404-984-4366>
>>> skype:  gmcharlt
>>> web:http://www.esilibrary.com/
>>> Supporting Koha and Evergreen: 
>>> http://koha-community.org &
>>> http://evergreen-ils.org
>>>
>>
>>
>>
>> --
>> Ruth Frasur
>> Director of the Historic(ally Awesome) Hagerstown - Jefferson Township
>> Library
>> 10 W. College Street in Hagerstown, Indiana (47346)
>> p (765) 489-5632 <%28765%29%20489-5632>; f (765) 489-5808
>> <%28765%29%20489-5808>
>>
>> Our Kickin' Website   Our Rockin'
>> Facebook Page   and Stuff I've Read
>> 
>>
>
>
>
> --
> Tim Spindler
> tjspind...@gmail.com
>
> *P**   Go Green - **Save a tree! Please don't print this e-mail unless
> it's really necessary.*
>
>
>
>
>


-- 
Grace Dunbar, Vice President
Equinox Software, Inc.  -  The Open Source Experts
gdun...@esilibrary.com
1-877-OPEN-ILSwww.esilibrary.com

Re: [OPEN-ILS-GENERAL] Announcement: new core committer named - Kathy Lussier

2015-11-10 Thread Amy Terlaga 
Go, Kathy, go!  You deserve it!

Amy

On Mon, Nov 9, 2015 at 1:33 PM, Galen Charlton  wrote:

> Hi,
>
> By consensus of the incumbent members, Kathy Lussier of MassLNC was
> invited to join the core committer team, and has accepted that
> invitation. Congratulations!
>
> An announcement on the Evergreen blog can be found here:
>
>
> https://evergreen-ils.org/welcome-evergreens-newest-core-committer-kathy-lussier/
>
> Regards,
>
> Galen
> --
> Galen Charlton
> Infrastructure and Added Services Manager
> Equinox Software, Inc. / The Open Source Experts
> email:  g...@esilibrary.com
> direct: +1 770-709-5581
> cell:   +1 404-984-4366
> skype:  gmcharlt
> web:http://www.esilibrary.com/
> Supporting Koha and Evergreen: http://koha-community.org &
> http://evergreen-ils.org
>



-- 
+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
Amy Terlaga
Director of User Services
Bibliomation, Inc.
24 Wooster Avenue
Waterbury, CT  06708
(203)577-4070 x101
terl...@biblio.org