We were audited by the IRS on a MUCH earlier version of BPCS.
Our version had a program called GLD230 which lists detail activity for
whatever range of profit centers, accounts, periods, etc. we asked for in a
single fiscal year . we can also do this for a prior year, but I don't
remember if we can do it for a closed year, or one for which we have purged
the journal. You should check to see if you have a similar program, with a
A Gotcha: for some types of transactions, we post to GL in summary format,
where one GL transaction may reflect thousands of transactions in the rest
of BPCS. This can be unacceptable to some auditors.
Now at End Year, before closing GL, we archive files associated with GL
reports, so that if there is another IRS audit, we hopefully can clone some
GL report, substitute the files from the archives of whatever year they are
auditing, and run whatever reports needed with data from end of that year.
We are also doing this with SOME of the supporting files from other areas of
BPCS which feed into the GL, such as Billing Invoices.
Via OPSNAV we get AS/400 report to TXT format to send to the auditors
handling this, from a prior year (we change auditors every few years, and
IRS was auditing a prior year), which was a hassle, because ordinarily we
send such reports via unencrypted e-mail, but the ISPs had some ceiling on
size of attachments you can send, and we had exceeded that. So we delivered
it on a CD ROM. Then when it got to the IRS, they did not like the
You need to check latest on ISP restriction. The last time I checked it was
10 Meg for most of them, with a few, such as gMail, supporting much more.
In general, when a TX file is poured into an XL, the size increases
So then we ran a few pages each of all the different sequence options
available from that program, asked the people to show this to the IRS, and
have them select the sequence closest to what they wanted. Then we reran
the process based on their selection.
99% of the vanilla BPCS reports, in OUR version, are hostile to Excel.
* There are columns with different kinds of things in the same
* Totals are sometimes off-set from the data columns they are
* IBM uses data edits that are not always recognized as valid by
Microsoft, so during the conversion from IBM to Microsoft, we have to be
constantly correcting Microsoft, to agree with the IBM formats.
* Reports, intended for green bar, have stuff on the top of every
page, which is counter-productive to getting it into a nice looking Excel.
So for some of our reports, we have a green bar version, and an
Alister Wm Macintyre (Al Mac)
From: BPCS-L [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve Keller
Sent: Wednesday, December 17, 2014 7:32 AM
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
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
As an Amazon Associate we earn from qualifying purchases.