[Download-List] Missing multi-values despite NUM.VALUES ALL

Dean, Terri tdean at jjc.edu
Wed Jun 12 16:44:25 EDT 2013


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

Thank you,
Terri
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20130612/e5244643/attachment.html>


More information about the download-list mailing list