<div dir="ltr"><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">Hi Eva,</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">It looks like you may be running into a couple of different things.</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">Your first line is for Invoice Items, which are direct charges. So there won't be any copies associated there. You also may have difficulty getting accurate results by including both invoice entries and invoice items in the same report; I haven't built out this particular report before, but whenever I try to combine them in one report I don't get complete results. Since your last line in your email specifies that you're looking for info on received copies, essentially, I would remove that line altogether.</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">You're also probably not getting fund information because funds are attached to the lineitem detail. In what you're working with right now, I don't see it drilling down to line item detail. I would probably start with the Line Item source and branch out from there, since you can reach line item detail information (like fund and copy info), bib info (like title/author), and invoice info from there.</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">With your barcode, you'll want to make sure that when you're in Line Item > Line Item Details that you drill down for Evergreen Copy ID>Barcode and not just Line Item Details > Barcode. The first one will give you the current barcode, the LID>Barcode only gives you the barcode that's stamped into place when the order was activated.</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">I'm happy to expand more (either on list or off), but wanted to leave it there for others' suggestions.</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">Tiffany</div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><span><br><div dir="ltr" style="margin-left:0pt" align="left"><table style="border:none;border-collapse:collapse"><colgroup><col width="89"><col width="414"></colgroup><tbody><tr style="height:123pt"><td style="vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:75px;height:75px"><img src="https://lh6.googleusercontent.com/8c2XlzLbIIC6nDoa4yqQ8MzA0npF4WXpUnhhoK_uTqralZtjqVXRwPgmRep3jGYP6q41Sb0ULXqxX-QppYTC8cQyIfBAdqzLBgqvcQwVczkqqiunlj0KIbvy-R3bp-E0mlhF0A4v" width="75" height="75" style="margin-left:0px;margin-top:0px"></span></span></p></td><td style="vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="color:rgb(30,67,155);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">Tiffany Little, PINES Services Specialist: Acquisitions</font></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"></p><hr><p></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;font-weight:700;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">Georgia Public Library Service | University System of Georgia</font></span></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">2872 Woodcock Blvd, Suite 250 l Atlanta, GA 30341</font></span></p><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9pt;color:rgb(30,67,155);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font face="tahoma, sans-serif">(470) 512-1454 | <a href="mailto:tmccanna@georgialibraries.org" target="_blank">tlittle@georgialibraries.org</a></font></span></p><br><p dir="ltr" style="line-height:1.44;margin-left:9pt;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:36px;height:36px"><img src="https://lh6.googleusercontent.com/ql1so1R8csbb2W7DW5vjWe3mTAcApuM7a5CMXbsYnhmF1bDmG62LM_C1BOOyWdkb2PZGKGlaYRIceHjsSvsWPXNw6HPCKqtFLMKCJiPVU0RXu2dAey13WZ02Q6E6FmzNDJ_d9iBf" width="36" height="36" style="margin-left:0px;margin-top:0px"></span></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh3.googleusercontent.com/2qSr0-AREIyPSTC1gMsjyXLaBT-yQ7kS6iKvd1L9XrCXxhJDWCRo5eXBHCi7f35AZASOOyiH2Si-wtuXNR8YaA2j-17GWBmmo1mpGxXa7m-JwF4AzUD_5tZZE9n1NVilAJcnGtQs" width="35" height="35" style="margin-left:0px;margin-top:0px"></span></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:35px;height:35px"><img src="https://lh6.googleusercontent.com/-jM_GEWd7EZGo5MFiR1koKEkiupb_lmwNEMpNiQE3U6k1C2FkyuiNjtGKlWWGfX8zbZ1135yhOHnJSINmMTXgEQuu2RlHIg5hDKxaJ9cmh3Nr6el_vN4ZHlXcAmoCPPWduwXi26m" width="35" height="35" style="margin-left:0px;margin-top:0px"></span></span></p></td></tr><tr style="height:21pt"><td colspan="2" style="vertical-align:top;padding:5pt 5pt 5pt 5pt;overflow:hidden"><p dir="ltr" style="line-height:1.44;text-align:center;margin-top:0pt;margin-bottom:0pt"><a href="http://georgialibraries.org/" target="_blank"><span style="font-size:8pt;font-family:Verdana;color:rgb(17,85,204);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">Join our email list</span></a><span style="font-size:8pt;font-family:Verdana;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap"> </span><span style="font-size:8pt;font-family:Verdana;color:rgb(67,67,67);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">for stories of Georgia libraries making an impact in our communities.</span></p></td></tr></tbody></table></div></span></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Nov 10, 2020 at 2:07 PM Cerninakova Eva <<a href="mailto:cernin@jabok.cz">cernin@jabok.cz</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br clear="all"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Hi all,</div><div><br>I am solving the following issue: </div><div><br></div><div>I need to list the funds, the invoices that were paid from the individual funds and the attached copies. I have created a report template that (I thought) should address the issue. I have used  following fields  from the "Invoice" source:</div><div><br></div></div></div></div></div></div></div></div><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><div><div><div><div><div><div><div>Invoice -> Invoice Items (inner) -> Fund (inner) - Name</div></div></div></div></div></div></div></div><div><div><div><div><div><div><div><div>Invoice -> Invoice Entries (inner) -> Invoice (inner) - Vendor Invoice ID</div></div></div></div></div></div></div></div><div><div><div><div><div><div><div><div>Invoice -> Invoice Entries (inner) -> Invoice (inner) - Invoice Date</div></div></div></div></div></div></div></div><div><div><div><div><div><div><div><div>Invoice -> Invoice Entries (inner) -> PO Line Item (inner) -> Evergreen Bib ID (inner) -> Simple Record Extracts (inner) - Title Proper (normalized)</div></div></div></div></div></div></div></div><div><div><div><div><div><div><div><div>Invoice -> Invoice Entries (inner) -> PO Line Item (inner) -> Evergreen Bib ID (inner) -> Call Numbers (inner) -> Copies (inner) - Barcode</div></div></div></div></div></div></div></div></blockquote><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><div><div>(I don't need to use any filter as there is only one library in the Evergreen consortium using the Acquisition module)</div></div></div></blockquote><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><div><div><br></div></div></div></blockquote><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><br>However, something must have been wrong because fewer invoices and copies were displayed in the report output than I would have expected. I am also sure that some funds weren't listed in the report output.<br><br>Could  anyone give me a hint how to correctly list funds, invoices and attached received copies with the current barcode?<br><br>Thanks for any idea<br></div><div>Eva</div><div><br></div><div><br></div><div><br></div><div><br></div><div><table style="font-size:small;font-family:Tahoma" cellspacing="0" cellpadding="0"><tbody><tr><td style="vertical-align:middle" width="150"><span style="margin-right:20px;display:block"></span><br><div><div><div><div><br><br></div><img src="https://knihovna.jabok.cz/sites/default/files/obrazky/knihovna_jabok-logo.png" style="margin-right: 0px;" width="169" height="65"><div></div></div></div><div><div> 

</div></div><br></div></td><td style="vertical-align:middle"><h3 color="#000000" style="margin:0px;font-size:16px;color:rgb(0,0,0)"><span>Eva Cerniňáková</span><span></span></h3><p color="#000000" style="margin:0px;color:rgb(0,0,0);font-size:12px;line-height:20px"><span>vedoucí Knihovny Jabok<br></span></p><p color="#000000" style="margin:0px;font-weight:500;color:rgb(0,0,0);font-size:12px;line-height:20px"><span>Jabok - Vyšší odborná škola sociálně pedagogická a teologická</span></p></td><td width="30"><br></td><td color="#fff000" style="width:1px;border-bottom:medium none;border-left:1px solid rgb(255,240,0)" width="1"><br></td><td width="30"><br></td><td style="vertical-align:middle"><table style="font-size:small;font-family:Tahoma" cellspacing="0" cellpadding="0"><tbody><tr style="vertical-align:middle" height="25"><td style="vertical-align:middle" width="30"><table style="font-size:small;font-family:Tahoma" cellspacing="0" cellpadding="0"><tbody><tr><td style="vertical-align:bottom"><span color="#fff000" width="11" style="display:block;background-color:rgb(255,240,0)"></span><br></td></tr></tbody></table></td><td style="padding:0px;color:rgb(0,0,0)"><a href="tel:+420+211+222+413" color="#000000" style="text-decoration:none;color:rgb(0,0,0);font-size:12px" target="_blank"><span>+420 211 222 409</span></a></td></tr><tr style="vertical-align:middle" height="25"><td style="vertical-align:middle" width="30"><table style="font-size:small;font-family:Tahoma" cellspacing="0" cellpadding="0"><tbody><tr><td style="vertical-align:bottom"><span color="#fff000" width="11" style="display:block;background-color:rgb(255,240,0)"></span><br></td></tr></tbody></table></td><td style="padding:0px"><a href="mailto:propagace@jabok.cz" color="#000000" style="color:rgb(0,0,0);font-size:12px" target="_blank">cernin@jabok.cz</a></td></tr><tr style="vertical-align:middle" height="25"><td style="vertical-align:middle" width="30"><table style="font-size:small;font-family:Tahoma" cellspacing="0" cellpadding="0"><tbody><tr><td style="vertical-align:bottom"><span color="#fff000" width="11" style="display:block;background-color:rgb(255,240,0)"></span><br></td></tr></tbody></table></td><td style="padding:0px"><a href="https://www.jabok.cz" color="#000000" style="color:rgb(0,0,0);font-size:12px" target="_blank">knihovna.jabok.cz</a></td></tr><tr style="vertical-align:middle" height="25"><td style="vertical-align:middle" width="30"><table style="font-size:small;font-family:Tahoma" cellspacing="0" cellpadding="0"><tbody><tr><td style="vertical-align:bottom"><span color="#fff000" width="11" style="display:block;background-color:rgb(255,240,0)"></span><br></td></tr></tbody></table></td><td style="padding:0px"><span color="#000000" style="font-size:12px;color:rgb(0,0,0)"><span>Salmovská 8, Praha 2, 120 00</span></span></td></tr></tbody></table></td></tr></tbody></table><table style="font-size:small;font-family:Tahoma;width:100%" cellspacing="0" cellpadding="0"><tbody><tr><td height="30"><br></td></tr><tr><td color="#fff000" style="width:100%;border-bottom:1px solid rgb(255,240,0);border-left:medium none;display:block" height="1"><br></td></tr><tr align="right"><td height="30"><a href="https://www.instagram.com/vosjabok/?hl=cs" color="#383838" style="display:inline-block;padding:0px;background-color:rgb(56,56,56)" target="_blank"><img src="https://cdn2.hubspot.net/hubfs/53/tools/email-signature-generator/icons/facebook-icon-2x.png" alt="facebook" color="#383838" style="background-color: rgb(56, 56, 56); max-width: 135px; display: block;" height="24"></a>   <a href="https://www.facebook.com/vosjabok/" color="#383838" style="display:inline-block;padding:0px;background-color:rgb(56,56,56)" target="_blank"><img src="https://cdn2.hubspot.net/hubfs/53/tools/email-signature-generator/icons/instagram-icon-2x.png" alt="instagram" color="#383838" style="background-color: rgb(56, 56, 56); max-width: 135px; display: block;" height="24"></a></td></tr></tbody></table><div><div><font size="4"><a href="https://knihovna.jabok.cz/cs/sluzby-knihovny-behem-uzavreni-kvuli-opatrenim-proti-sireni-covid-19" target="_blank">Knihovna Jabok je nyní uzavřena, ale přesto funguje!</a></font><br></div><div><br><br><br><br></div></div></div></div></div></div></div></div></div></div></div>
_______________________________________________<br>
Evergreen-general mailing list<br>
<a href="mailto:Evergreen-general@list.evergreen-ils.org" target="_blank">Evergreen-general@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general</a><br>
</blockquote></div>