Re: IWP Price Book Report

Had some PC problems recently and not able to respond to the list.  Lloyd
logged a support call, and we suggested that he change his report from
detail to summary.  Instead of printing every price record, by summarizing
to the item level, the price breaks show across the line instead of stepping
down the page.  Lloyd had already done the "hard" work of identifying the
price break categories and getting them to print in the individual columns.
Summarizing these calculations to the item level proved to be just the trick
he needed.
 
Momentum is the developer of Info WorkPlace (IWP), inTuator, and JacanaForms
 
Regards,
-Greg
 
Greg Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@xxxxxxxxxx
www.jacana.com
 
Making Information Work for you Business
www.intuator.com


  _____  

From: Lloyd Degnon [mailto:ldegnon@xxxxxxxxx] 
Sent: Thursday, August 31, 2006 12:31 PM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] IWP Price Book Report



I have created an extremely basic Info Workplace(Jacana) Subset in order
to print out price books from MAPICS.  I linked the Base Price File with
the Page 5 Pricing file and created a report with qty columns going
across in the hopes to have one line entry per Item Number per Price
Book.  I got all of the math done to calculate the Qty prices correctly,
but I cannot seem to be able to figure out a way to get rid of the
"Stair Stepping"  See below...

PBook Item Number Class Qty 1 Qty 10 Qty 25 Qty 50 Qty 100 Qty 250 Qty
500 Qty 1000 Qty 2500 Qty 5000
OEM     8100006     2      360.713       0         0         0
0         0         0         0             0         0
OEM     8100006     2         0      354.942       0         0
0         0         0         0             0         0
OEM     8100006     2         0              0 346.285        0
0         0         0         0             0         0
OEM     8100006     2         0              0         0  331.856
0         0         0         0             0         0
OEM     8100006     2         0              0         0          0
317.428          0         0         0             0         0
OEM     8100006     2         0              0         0          0
0 302.999        0        0             0         0
OEM     8100006     2         0              0         0          0
0         0 274.142       0             0         0
OEM     8100006     2         0              0         0          0
0         0         0 259.713           0         0
OEM     8100006     2         0              0         0          0
0         0         0         0 251.056 0
OEM     8100006     2         0              0         0          0
0         0         0         0              0 245.285


Lloyd H. Degnon
I.S. Manager
AmPro Computers, Inc.
5215 Hellyer Ave.
Building #110
San Jose, CA 95138
(408) 360-4365
ldegnon@xxxxxxxxx <mailto:ldegnon@xxxxxxxxx> 
www.AmPro.com <http://www.ampro.com/>