Here is how you want your report to look:
04/14/11¢PAGE 1 14:56:22 FILLED CUSTOMER ORDERS ¢DETAIL CUST-ID ITM-ID SHIP-QTY UNIT-PRICE SHIP-PRICE --------- ---------- ----------- ------------- ------------- 01008 C10000 0000002 00029.50 59.00 C10001 0000004 00021.00 84.00 C10002 0000006 00014.00 84.00 C10005 0000002 00066.75 133.50 TOTAL CUST-ID 01008 360.50 AVERAGE ITEM PRICE 00032.81 01009 A60005 0000001 00219.99 219.99 A60008 0000002 00179.99 359.98 A70000 0000004 00099.99 399.96 TOTAL CUST-ID 01009 979.93 AVERAGE ITEM PRICE 00166.65 01010 H20006 0000005 00012.99 64.95 H30000 0000004 00124.99 499.96 H40000 0000015 00015.99 239.85 H20001 0000003 00021.99 65.97 H30002 0000006 00069.99 419.94 H10002 0000010 00004.99 49.90 H20004 0000002 00021.99 43.98 H70001 0000100 00038.99 3,899.00
|
Copyright © 2014 CA.
All rights reserved.
|
|