|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.