We also use SEQUEL from Advanced Systems Concepts to email and download 
reports.  It is an extremely valuable tool to our small staff.  I have 
replaced almost all the standard BPCS reports with custom SEQUEL reports 
that can be printed, emailed, or saved in several formats including xls, 
dbf, rtf, txt,, and htm.

Tony Kleier
Robbins, Inc.
Office: 513-619-5957
Fax: 513-619-6057
akleier@xxxxxxxxxxxxxxxx
www.robbinsfloor.com



"DeeDee Virgei" <DeeDee.Virgei@xxxxxxxxxxxxxx> 
Sent by: bpcs-l-bounces+akleier=robbinsfloor.com@xxxxxxxxxxxx
12/10/2004 08:50 AM
Please respond to
"SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>


To
"SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
cc

Subject
RE: [BPCS-L] Printing to a File







Hi Wendy,

We've been using SEQUEL to download and email reports for many years... If 
you don't have SEQUEL, you could use Client Access 'Data Transfer from 
iSeries' (.tto files) to Excel or to a Tab Delimited file. 
Here is an IBM site that may help:  
http://www-1.ibm.com/support/docview.wss?uid=nas11f969ff9547fdb8f86256e7c00679338

I bought an inexpensive MC book 'The OS/400 and Microsoft Office 2000 
Integration Handbook' a couple years ago; it really helped us get started 
w/ a lot of back and forth communication between Microsoft products and 
the iSeries (BPCS).  I'm sure there are similar and more up-to-date books 
on the market now...  Good luck.

DeeDee Virgei 
Project Leader

Nelson Stud Welding, Inc.
 -----Original Message-----
From:            bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx 
[mailto:bpcs-l-bounces+deedee.virgei=nelsonstud.com@xxxxxxxxxxxx]  On 
Behalf Of Bunch, Wendy
Sent:            Friday, December 10, 2004 8:10 AM
To:              bpcs-l@xxxxxxxxxxxx
Subject:                 [BPCS-L] Printing to a File


Is it possible for the user to print a report, such as the Account 
Receivable aging, to a file for import into excel?  Isn't this something 
fairly simple on an AS400 environment, BPCS version 6.1.2?   We have a 
request from our auditors for many of our monthly std reports to be in an 
excel format for them to test. 

Wendy Bunch
Cost Accountant
Wabash Technologies
1375 Swan Street
PO Box 829
Huntington, IN  46750-0829
Direct (260) 355-4204
Main  (260) 355-4100
Fax    (260) 355-4265
wbunch@xxxxxxxxxxxxxx
This is an e-mail from Wabash Technologies, Incorporated.  It is 
confidential to the ordinary user of the above e-mail address.  It may 
contain copyright and/or legally privileged information.  No other person 
may read, print, store, copy, forward, or act in reliance on it or its 
attachments.  If you received this in error, please e-mail to 
humanresources@xxxxxxxxxxxxxx


_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: deedee.virgei@xxxxxxxxxxxxxx



_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: akleier@xxxxxxxxxxxxxxxx


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.