Re: Question about queries

Thanks Barry,

The info is greatly appreciated. If we can only get those toners to really
match OEM spec, it would be great.



-----Original Message-----
From: bpcs-l-bounces+yshargorodsky=yysinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+yshargorodsky=yysinc.com@xxxxxxxxxxxx] On Behalf Of
Barry Robins
Sent: Friday, May 07, 2010 11:16 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Question about queries

Kitten and Momma are home! He is looking really good and is playful and
on his feet (paws) again.

The other one that was sick yesterday has not shown any now symptoms and
is doing well.

We will keep the one that spent time at the vet's separated from the
others for a couple of days and if all is still going well, he can come
back to hang with his family.

No. No one knows what caused it. Sure was one expensive and nerve
wracking mystery.


Best regards,



Barry Robins

iSeries/BPCS Support Team

Static Control Components

(919) 774-3808 ext. 1315

Email to: BarryR@xxxxxxxxxxx

Any copyrighted material sent to you is for your own internal use only.
No portion of any copyrighted material may be reproduced in any form,
or by any means, without prior written permission from Static Control.
Users are not permitted to modify, distribute, publish, transmit or
create
derivative works of any material found contained herein for any public
or commercial purpose.


-----Original Message-----
From: bpcs-l-bounces+barryr=scc-inc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+barryr=scc-inc.com@xxxxxxxxxxxx] On Behalf Of Al
Sent: Friday, May 07, 2010 12:37 PM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Question about queries

Also be careful if your FISCAL calendar is different from MONTHs
calendar
... some people want totals by FISCAL month, not calendar month.

To satisfy such people, query/400 is a poor tool, unless you select
files
that already summarize data into fiscal periods.

-
Al Mac
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of
rob@xxxxxxxxx
Sent: Friday, May 07, 2010 9:44 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Question about queries

In the "Define result fields" I have:
DATEC digits(ildate)
YEARMONTH substr(datec,1,6)
In the "Select sort fields" I used
Sort
Prty A/D Field
10 A YEARMONTH
20 A ILSAL1
In the "Select report summary functions" I used "1=Total" on ILQTY.
In "Define report breaks" I used
Break Sort
Level Prty Field
1 10 YEARMONTH
2 20 ILSAL1
In "Select output type and output form" I used "2=Summary only"

Results:
YEARMONTH Slsmn MTD
Number Adjustments
000001 200504 1
000002 TOTAL 948715.194
000003
000004 200504 7
000005 TOTAL 1206903.000
000006
000007 200504 8
000008 TOTAL 36649.000
...
000081
000082 200504
000083 TOTAL 8471378.233
...




Rob Berendt