Rob, yes iow, what is display here is what the user gets based on their req. Now they would rather see the total per inv. I am trying to devote as little time as possible to this process so thought that if I can just adjust the file for them.
colinwilliams@xxxxxxxxxxxxxxx wrote: Mike,
Are you just trying to total up the Sales Tax Dollars and Detail Net
amount fields ?
Select
shipped_invoice_number,sum(sales_tax_dollars),sum(detail_net_amount)
from invoices group by shipped_invoice_number
Cheers
Colin.W
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Berman
Sent: 04 March 2008 15:23
To: rpg400-l@xxxxxxxxxxxx
Subject: Totalling
Hi - I have a detail file of invoice numbers and amounts that will
contain more than one item per invoice. I would like to obtain a total
per invoice and list this via SQL. Rather than making another RPG
program.
the data is like this:
SHIPPED SHIPPED DIV ACCT STORE SALES DETAIL
INVOICE INVOICE CODE NO NO TAX NET
DATE NUMBER DOLLARS AMOUNT
6/11/07 1101661 50 92584 7001 25.54 125.88
6/11/07 1101661 50 92584 7001 25.54 299.76
6/11/07 1101662 50 92584 7002 25.54 125.88
6/11/07 1101662 50 92584 7002 25.54 299.76
6/11/07 1101663 50 92584 7003 25.54 125.88
6/11/07 1101663 50 92584 7003 25.54 299.76
6/11/07 1101664 50 92584 7004 25.54 125.88
6/11/07 1101664 50 92584 7004 25.54 299.76
I would like to use the existing file here and change the records that
it will show the total per invoice and delete what is no longer needed.
Or is creating a work file output here the only option?
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
it now.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
"EMF " made the following annotations.
------------------------------------------------------------------------------
Bank of Scotland Treasury is a division of Bank of Scotland plc which is part of the HBOS Group. Incorporated and registered in Scotland number SC327000. Registered Office: The Mound, Edinburgh EH1 1YZ.
Authorised and regulated by the Financial Services Authority, 25 The North Colonnade, Canary Wharf, London E14 5HS.
In Australia, Bank of Scotland plc is registered as a foreign company, Australian Registered Body Number 126 955 557. The liability of its members is limited.
The information contained in this message is confidential and is intended for the addressee only. Internet communications are not necessarily secure. If you have received this message in error or there are any problems please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. Information contained herein does not constitute a recommendation, solicitation or any offer to buy or sell any securities described herein. Any comments which do not relate to business activities are not endorsed by us. This mail and any attachments have been scanned for viruses prior to leaving the Bank of Scotland Treasury network. Bank of Scotland Treasury will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any virus being passed on.
Bank of Scotland Treasury reserves the right to monitor and record e-mail messages sent to and from this address for the purposes of investigating or detecting any unauthorised use of its system and ensuring its effective operation.
==============================================================================
---------------------------------
Never miss a thing. Make Yahoo your homepage.
midrange.com
