<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)">
<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:11.0pt;
font-family:"Calibri","sans-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-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
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">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"><o:p> </o:p></p>
<p class="MsoNormal">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 VOU.GL.NO.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">DOWNLOAD VOUCHERS BREAK.ON JJC.VOU.GL.NO.1.FUND @ID JJC.VOU.GL.NO.1 FMT "16L##-#####-######" SORT.NAME ITEM.DESC NUM.VALUES 2 MV.ORIENTATION VERTICAL VOU.TOTAL.AMT GL.NO 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"><o:p> </o:p></p>
<p class="MsoNormal">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 (GL.NO) and GL Amts (GL.EXTENDED) per line item. GL.NO 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"><o:p> </o:p></p>
<p class="MsoNormal">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;margin-left:-1.15pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="116" style="width:87.3pt;border:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:black">VOUCHER AMT</span></b><b><span style="color:black"><o:p></o:p></span></b></p>
</td>
<td width="144" style="width:108.3pt;border:solid black 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:black">GL NUMBERS--------</span></b><b><span style="color:black"><o:p></o:p></span></b></p>
</td>
<td width="77" style="width:58.05pt;border:solid black 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:black">GL AMTS</span></b><b><span style="color:black"><o:p></o:p></span></b></p>
</td>
</tr>
<tr style="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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">3996.52</span><span style="color:black"><o:p></o:p></span></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;height:15.0pt">
<p class="MsoNormal"><span style="color:black">12-30210-652111</span><span style="color:black"><o:p></o:p></span></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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">6.75</span><span style="color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr style="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;height:15.0pt">
<p class="MsoNormal"><span style="color:black">12-30210-652111</span><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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">49.00</span><span style="color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr style="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;height:15.0pt">
<p class="MsoNormal"><span style="color:black">12-30210-652111</span><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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">225.47</span><span style="color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr style="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;height:15.0pt">
<p class="MsoNormal"><span style="color:black">12-30210-652111</span><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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">15.30</span><span style="color:black"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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;margin-left:-1.15pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="116" style="width:87.3pt;border:solid black 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:black">VOUCHER AMT</span></b><b><span style="color:black"><o:p></o:p></span></b></p>
</td>
<td width="144" style="width:108.3pt;border:solid black 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:black">GL NUMBERS--------</span></b><b><span style="color:black"><o:p></o:p></span></b></p>
</td>
<td width="77" style="width:58.05pt;border:solid black 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="color:black">GL AMTS</span></b><b><span style="color:black"><o:p></o:p></span></b></p>
</td>
</tr>
<tr style="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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">3996.52</span><span style="color:black"><o:p></o:p></span></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;height:15.0pt">
<p class="MsoNormal"><span style="color:black">12-30210-652111</span><span style="color:black"><o:p></o:p></span></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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">6.75</span><span style="color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr style="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;height:15.0pt">
<p class="MsoNormal"><span style="color:black">12-30210-652111</span><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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">49.00</span><span style="color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr style="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;height:15.0pt">
<p class="MsoNormal"><span style="color:black">12-30210-652111</span><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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">225.47</span><span style="color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr style="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;height:15.0pt">
<p class="MsoNormal">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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">3700.00</span><span style="color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr style="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;height:15.0pt">
<p class="MsoNormal"><span style="color:black">12-30210-652111</span><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;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black">15.30</span><span style="color:black"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">When I LIST the fields that are in the DOWNLOAD, all the data in GL.NO 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"><o:p> </o:p></p>
<p class="MsoNormal">Thank you,<o:p></o:p></p>
<p class="MsoNormal">Terri<o:p></o:p></p>
</div>
</body>
</html>