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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.