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.


Tom Molyneux

National Oilwell Varco
Completion & Production Solutions
Greengate Way, Greengate, Chadderton
M24 1SA
Direct: +44 161 214 2142
Tom.Molyneux@xxxxxxx |

-----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


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,
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at


Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Stonedale Road, Oldends Lane Industrial Estate, Stonehouse, Gloucestershire, GL10 3RQ

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-2022 by 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.