David,
 
The easiest way to handle multi-member files, such as the SHPACT and other
Mapics batch transaction files, is to use a CL program to create an override
and then run the report.  First build a subset based on the file as if it
was a regular database file, include links to any other files necessary for
your reporting.  
 
Then to include all of the batches in a report, setup an override to the
filename defined in the subset - whether it is a physical or a logical file.
For the shop activity transactions, use an override as follows:
 
OVRDBF FILE(SHPACT) MBR(*ALL)
 
The member option *ALL will cause all batches to be included.
 
After setting up the override, to run the report from the CL, use the RPTRUN
command.  This command is designed to run reports in batch and accepts
parameters for the record selections.
 
IWPDTA/RPTRUN REPORT(MYREPORT) SELECT('X' 'Y' 'Z')
 
For the select parameter, make an entry for each selection in the sequence
defined in the report.
 
Thats all there is to it.
 
 
Momentum is the developer of Info/WP, JacanaForms and Jacana inTuator.
 
Regards,
-Greg
 
Gregory Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@xxxxxxxxxx
www.jacana.com <http://www.jacana.com/> 
 
Making Information Work for your Business
www.intuator.com <http://www.intuator.com/> 
 

-----Original Message----- 
From: Kemp, David [mailto:dkemp@xxxxxxxxxx] 
Sent: Thursday, 8 April 2004 11:00 
To: MAPICS ERP System Discussion 
Subject: RE: PCC Batch File & A Couple of Questions 


Thanks to all for the responses.  You have been very helpful.  Through your
input we have been able to verify our data and move forward.

Now I have two more questions: 

What is a good source to read to understand more completely the issue of
AS/400 files, members, records, etc? 

For those who use IWP or Jacana, is there a way to link the SHPACT file in a
subset such that the order number in all of the batch records can be pulled
to a report.

Thanks, 
David 


-----Original Message----- 
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Dave Lauderdale 
Sent: Wednesday, April 07, 2004 7:49 PM 
To: MAPICS ERP System Discussion 
Subject: RE: PCC Batch File 

When you go to the shop activity entry screen, do these five suspended
batches have a record count?  If not, then the batches were opened, but
nothing entered.  If there is a record count, takt one of the batch numbers
and append it to the member name that begins with "BCH" when you do a RUNQRY
on the SHPACT file.  For example, if the batch number is 597, run the
following command:

RUNQRY QRYFILE((AMTLIBx/SHPACT BCH597)) 

This will display the records in batch 597. 

David   

-----Original Message----- 
From: Kemp, David [mailto:dkemp@xxxxxxxxxx] 
Sent: Wednesday, April 07, 2004 11:06 AM 
To: MAPICS ERP System Discussion 
Subject: RE: PCC Batch File 


Pete, 

Thanks for the response.  We currently have five suspended batches of labor
transactions in PCC but the SHPACT file has no records.  Does this make
sense?

David 


-----Original Message----- 
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Pete Olshavsky 
Sent: Wednesday, April 07, 2004 7:12 AM 
To: MAPICS ERP System Discussion 
Subject: Re: PCC Batch File 

David, Data keyed on the PCC data entry goes into a file called SHPACT in
AMTLIB(x) 
  
Pete 

"Kemp, David" <dkemp@xxxxxxxxxx> wrote: 
We are in the process of changing our methods for entering labor hours. We
are transitioning to entering labor hours in PCC and would like to know
where the keyed data is stored before Shop Activity Update is performed.
Does anyone know the name of the file that holds these records?

Thanks in Advance, 
David Kemp 


_______________________________________________ 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,

visit: http://lists.midrange.com/mailman/listinfo/mapics-l 
or email: MAPICS-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/mapics-l. 


--------------------------------- 
Do you Yahoo!? 
Yahoo! Small Business $15K Web Design Giveaway - Enter today
_______________________________________________ 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,

visit: http://lists.midrange.com/mailman/listinfo/mapics-l 
or email: MAPICS-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/mapics-l. 


_______________________________________________ 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,

visit: http://lists.midrange.com/mailman/listinfo/mapics-l 
or email: MAPICS-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/mapics-l. 

_______________________________________________ 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,

visit: http://lists.midrange.com/mailman/listinfo/mapics-l 
or email: MAPICS-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/mapics-l. 


_______________________________________________ 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,

visit: http://lists.midrange.com/mailman/listinfo/mapics-l 
or email: MAPICS-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/mapics-l. 


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.