[Download-List] **spam suspect** Re: **spam suspect** RE: Missing multi-values despite NUM.VALUES ALL

[Rotman, David]

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.)



David Rotman, Ph.D.
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819



On Wed, Jul 3, 2013 at 11:48 AM, Dean, Terri <tdean at jjc.edu> wrote:

>  Can someone please assist me with this?  Thank you. - Terri****
>
> ** **
>
> *From:* download-list-bounces at cedarville.edu [mailto:
> download-list-bounces at cedarville.edu] *On Behalf Of *Dean, Terri
> *Sent:* Wednesday, June 12, 2013 3:44 PM
> *To:* 'download-list at cedarville.edu'
> *Subject:* [Download-List] Missing multi-values despite NUM.VALUES ALL****
>
> ** **
>
> 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?****
>
> ** **
>
> 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.****
>
> ** **
>
> 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  ****
>
> ** **
>
> 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.****
>
> ** **
>
> 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 3rd line item
> which totals $3,925.47.****
>
> *VOUCHER AMT*
>
> *GL NUMBERS--------*
>
> *GL AMTS*
>
> 3996.52****
>
> 12-30210-652111****
>
> 6.75****
>
> 12-30210-652111****
>
> 49.00****
>
> 12-30210-652111****
>
> 225.47****
>
> 12-30210-652111****
>
> 15.30****
>
> ** **
>
> This is what should be printing.****
>
> *VOUCHER AMT*
>
> *GL NUMBERS--------*
>
> *GL AMTS*
>
> 3996.52****
>
> 12-30210-652111****
>
> 6.75****
>
> 12-30210-652111****
>
> 49.00****
>
> 12-30210-652111****
>
> 225.47****
>
> 12-30210-655129****
>
> 3700.00****
>
> 12-30210-652111****
>
> 15.30****
>
> ** **
>
> When I LIST the fields that are in the DOWNLOAD, all the data in GL.NOand 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.****
>
> ** **
>
> Thank you,****
>
> Terri****
>
> _______________________________________________
> download-list mailing list
> download-list at cedarville.edu
> http://mail.cedarville.edu/mailman/listinfo/download-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20130703/482c9be9/attachment.html>