[OPEN-ILS-GENERAL] Finding Non-paid but "Received" lineitems

[Daniel Wells]

P.S. "0 Invoiced" is using the same logic as your original query, i.e. +1
if lineitem has a fund_debit WHERE NOT encumbrance.

On Wed, May 17, 2017 at 12:10 PM, Daniel Wells <dbwells at gmail.com> wrote:

> Nothing more than a hunch, but I am guessing encumbered->0, paid->0 might
> factor into that item getting stuck with an encumbered fund debit.
>
> Dan
>
> On Wed, May 17, 2017 at 11:17 AM, Blake Henderson <
> blake at mobiusconsortium.org> wrote:
>
>>
>> All,
>>
>> I am working through a problem. We are trying to generate a list of
>> purchase orders / lineitems that have been received but not invoiced. We do
>> this by running a report with a filter of Encumbrance = 'true'
>>
>> We noticed that some of the things coming up are things that have been
>> invoiced. How is it possible for something to have an invoice and not be
>> paid? Even when the invoice is closed? See below
>>
>>
>> A lineitem here "Governing Global Health" is shown to not be "Paid"
>>
>>
>>
>>
>> But when you look at the associated invoice:
>>
>>
>>
>> It says 0 invoiced in the subtitle, however, it shows it in the right
>> column as having an invoice.
>>
>> What scenario makes this happen?
>>
>> --
>> -Blake-
>> Conducting Magic
>> MOBIUS
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170517/cc5e4691/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: omnnikocdbhfpfho.png
Type: image/png
Size: 243922 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170517/cc5e4691/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ajpddnagajcpfnfp.png
Type: image/png
Size: 69626 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170517/cc5e4691/attachment-0003.png>