<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">That was it! You’re awesome!!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Thank you so much!!!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D">Terri Dean<br>
Systems Analyst<br>
Joliet Junior College<br>
1215 Houbolt Rd<br>
Joliet IL 60431-8938<br>
(815) 280-2835<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> download-list-bounces@cedarville.edu [mailto:download-list-bounces@cedarville.edu]
<b>On Behalf Of </b>Rotman, David<br>
<b>Sent:</b> Wednesday, July 03, 2013 12:53 PM<br>
<b>To:</b> Cedarville DOWNLOAD Users<br>
<b>Subject:</b> [Download-List] **spam suspect** Re: **spam suspect** RE: Missing multi-values despite NUM.VALUES ALL<br>
<b>Importance:</b> Low<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">I haven't traced through all of our i-descriptors, but I'm wondering if you will also need NUM.SUBVALUES ALL. (If you are TRANSlating a multivalued field to fetch a multivalued field, the results will often have subvalues.)<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal">David Rotman, Ph.D.<br>
Associate Vice President for Technology<br>
Chief Information Officer<br>
Cedarville University<br>
251 N. Main Street<br>
Cedarville, OH 45314<br>
<a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a><br>
voice 937-766-7905<br>
fax 937-766-8819<o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="border:solid windowtext 1.0pt;padding:0in"><img border="0" width="100" height="100" id="_x0000_i1025" src="cid:~WRD000.jpg" alt="Image removed by sender."></span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Jul 3, 2013 at 11:48 AM, Dean, Terri <<a href="mailto:tdean@jjc.edu" target="_blank">tdean@jjc.edu</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D">Can someone please assist me with this? Thank you. - Terri</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:download-list-bounces@cedarville.edu" target="_blank">download-list-bounces@cedarville.edu</a> [mailto:<a href="mailto:download-list-bounces@cedarville.edu" target="_blank">download-list-bounces@cedarville.edu</a>]
<b>On Behalf Of </b>Dean, Terri<br>
<b>Sent:</b> Wednesday, June 12, 2013 3:44 PM<br>
<b>To:</b> '<a href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a>'<br>
<b>Subject:</b> [Download-List] Missing multi-values despite NUM.VALUES ALL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Thank you for developing DOWNLOAD. I am having difficulties with a DOWNLOAD statement and was hoping you could assist. Have you ever had an issue where it didn’t display all the
multi-value information even though NUM.VALUES ALL was used?<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Here’s a copy of the DOWNLOAD statement. JJC.VOU.GL.NO.1.FUND is the first 2 characters of the GL number. JJC.VOU.GL.NO.1 is the first GL number in
<a href="http://VOU.GL.NO" target="_blank">VOU.GL.NO</a>.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">DOWNLOAD VOUCHERS BREAK.ON JJC.VOU.GL.NO.1.FUND @ID JJC.VOU.GL.NO.1 FMT "16L##-#####-######"
<a href="http://SORT.NAME" target="_blank">SORT.NAME</a> ITEM.DESC NUM.VALUES 2 MV.ORIENTATION VERTICAL VOU.TOTAL.AMT
<a href="http://GL.NO" target="_blank">GL.NO</a> FMT "16L##-#####-######" NUM.VALUES ALL MV.ORIENTATION VERTICAL GL.EXTENDED NUM.VALUES ALL MV.ORIENTATION VERTICAL FOOTING.ON JJC.VOU.GL.NO.1.FUND LITERAL "***FUND TOTAL***" TOTAL VOU.TOTAL.AMT FOOTING.ON FINAL
LITERAL "***GRAND TOTAL" TOTAL VOU.TOTAL.AMT HEADING LITERAL "FUND" LITERAL "VOUCHER" LITERAL "GL NUMBER----------" LITERAL "VENDOR NAME" LITERAL "DESCRIPTION" LITERAL "VOUCHER AMT" LITERAL "GL NUMBERS--------" LITERAL "GL AMTS" HTML.TOP '<H2><CENTER> JOLIET
JUNIOR COLLEGE </CENTER></H2> <H3><CENTER> BUILD LIST - BILLS TO BE APPROVED </CENTER></H3> <H4><CENTER> DATE DUE <<Voucher Due Date for Large Bills>>' FILE OUTGOINGCF LARGE.BUILD.LIST.xls FORMAT HTML OVERWRITING
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">The problem is that the data in the Voucher Amt column (field VOU.TOTAL.AMT) is not always the total of the GL AMTS column (GL.EXTENDED), but it should be. In Voucher Inquiry (VOUI)
a line item can be split between multiple accounts (detail to Voucher Item Inquiry-VIIN). The download is only picking up the first GL Number (<a href="http://GL.NO" target="_blank">GL.NO</a>) and GL Amts (GL.EXTENDED) per line item.
<a href="http://GL.NO" target="_blank">GL.NO</a> and GL.EXTENDED are both computed columns and multi-valued. Since NUM.VALUES ALL is used with these fields, it should be printing all the information.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Here’s an example of what is printing (I’ve only included the columns that I’m having problems with). If you add up the GL AMTS, it is $296.52 and should be matching the $3,996.52
in VOUCHER AMT. It’s missing $3,700 with account 01-29109-544018. This is actually part of the 3<sup>rd</sup> line item which totals $3,925.47.<o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="338" style="width:253.65pt;border-collapse:collapse">
<tbody>
<tr style="min-height:15.0pt">
<td width="116" style="width:87.3pt;border:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>VOUCHER AMT</b><o:p></o:p></p>
</td>
<td width="144" style="width:108.3pt;border:solid black 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>GL NUMBERS--------</b><o:p></o:p></p>
</td>
<td width="77" style="width:58.05pt;border:solid black 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>GL AMTS</b><o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt">
<td width="116" rowspan="4" valign="bottom" style="width:87.3pt;border:solid black 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
3996.52<o:p></o:p></p>
</td>
<td width="144" valign="bottom" style="width:108.3pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">12-30210-652111<o:p></o:p></p>
</td>
<td width="77" valign="bottom" style="width:58.05pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
6.75<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt">
<td width="144" valign="top" style="width:108.3pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">12-30210-652111<o:p></o:p></p>
</td>
<td width="77" valign="bottom" style="width:58.05pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
49.00<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt">
<td width="144" valign="top" style="width:108.3pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">12-30210-652111<o:p></o:p></p>
</td>
<td width="77" valign="bottom" style="width:58.05pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
225.47<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt">
<td width="144" valign="top" style="width:108.3pt;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">12-30210-652111<o:p></o:p></p>
</td>
<td width="77" valign="bottom" style="width:58.05pt;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
15.30<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">This is what should be printing.<o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="338" style="width:253.65pt;border-collapse:collapse">
<tbody>
<tr style="min-height:15.0pt">
<td width="116" style="width:87.3pt;border:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>VOUCHER AMT</b><o:p></o:p></p>
</td>
<td width="144" style="width:108.3pt;border:solid black 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>GL NUMBERS--------</b><o:p></o:p></p>
</td>
<td width="77" style="width:58.05pt;border:solid black 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="center" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:center">
<b>GL AMTS</b><o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt">
<td width="116" rowspan="5" valign="bottom" style="width:87.3pt;border:solid black 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
3996.52<o:p></o:p></p>
</td>
<td width="144" valign="bottom" style="width:108.3pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">12-30210-652111<o:p></o:p></p>
</td>
<td width="77" valign="bottom" style="width:58.05pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
6.75<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt">
<td width="144" valign="top" style="width:108.3pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">12-30210-652111<o:p></o:p></p>
</td>
<td width="77" valign="bottom" style="width:58.05pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
49.00<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt">
<td width="144" valign="top" style="width:108.3pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">12-30210-652111<o:p></o:p></p>
</td>
<td width="77" valign="bottom" style="width:58.05pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
225.47<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt">
<td width="144" valign="top" style="width:108.3pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">12-30210-655129<o:p></o:p></p>
</td>
<td width="77" valign="bottom" style="width:58.05pt;border:none;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
3700.00<o:p></o:p></p>
</td>
</tr>
<tr style="min-height:15.0pt">
<td width="144" valign="top" style="width:108.3pt;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">12-30210-652111<o:p></o:p></p>
</td>
<td width="77" valign="bottom" style="width:58.05pt;border-top:none;border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;min-height:15.0pt">
<p class="MsoNormal" align="right" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;text-align:right">
15.30<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">When I LIST the fields that are in the DOWNLOAD, all the data in
<a href="http://GL.NO" target="_blank">GL.NO</a> and GL.EXTENDED display. This is why I believe that the problem is with the DOWNLOAD. Any assistance that you can provide would be greatly appreciated.<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Thank you,<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Terri<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
download-list mailing list<br>
<a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a><br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>