subject:"Re\: \[OPEN\-ILS\-GENERAL\] Invoiced Charges report"

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

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

> - Or

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" <millis...@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:
> 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" <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/
> 

-- 
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" <millis...@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:
> 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",
>   "8e36cdcabf31499a99b230a9

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

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

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

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

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

5 matches

Site Navigation

Mail list logo

Footer information