Steve,
We are on 8.3.2, so I hope the file names are still the same.
Use iSeries Data Transfer to create an Excel file from the GLH file.
If necessary, use AS400 Query over GLH file to extract/sort/cut down the data you're interested in and create a work file, then drop this into excel via Data transfer.
We also use a piece of software called CoolSpools to create Excel files from iSeries data files, which is really easy to use and produces really good excel files. I have no affiliation to the company, just think it's a really good bit of software which we use extensively.
Cheers
Tom Molyneux
National Oilwell Varco
Completion & Production Solutions
Greengate Way, Greengate, Chadderton
M24 1SA
Direct: +44 161 214 2142
Tom.Molyneux@xxxxxxx | www.nov.com
-----Original Message-----
From: BPCS-L [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve Keller
Sent: 17 December 2014 13:32
To: 'bpcs-l@xxxxxxxxxxxx'
Subject: [BPCS-L] CEA/General Ledger
We are being audited by IRS and I need to get general ledger data at the detail level into excel or csv file.
Does anyone know the best approach in getting this data?
We are on LX version 8.3.4
Thanks,
Steve Keller
CONFIDENTIALITY NOTICE: The information contained in this e-mail communication and any attached documentation may be privileged, confidential or otherwise protected from disclosure and is intended only for the use of the designated recipient(s). It is not intended for transmission to, or receipt by, any unauthorized person. The use, distribution, transmittal or re-transmittal by an unintended recipient of this communication is strictly prohibited without our express approval in writing or by e-mail. If you are not the intended recipient of this e-mail, please delete it from your system without copying it and notify the above sender.
--
This is the 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.
________________________________
Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Stonedale Road, Oldends Lane Industrial Estate, Stonehouse, Gloucestershire, GL10 3RQ
midrange.com
