I need the OLEDB table that will give me the transactions that have been
posted as a special posting to the prior year. I have tried the following
'@L68APST', '@L68BPST' and '@L80APST'. They all give an error message:
"Table does not exist".

The table, G/L Account Information (@L80AACT) "Opening Balances" does not
match the G/L Detailed Listing Report's "Opening Balances". And the
'@L80AACT' does not have a column that shows the net transactions posted to
prior year.

I've written an application for my client that starts with the beginning
balances in the retained earning (fund balances) accounts. These balances
need to match the final audited (adjusted) balances in order to be relevant
to the balances that are in the report.

Please let me know which table that I can access through the OLEDB that will
bridge the gap between the Opening Balances per G/L Account Information
table and the Adjusted Opening Balances per the G/L Detailed Listing.

You need to use the "Mask" qualifier.

This from the GeneralSample.xls

Mask:
Used with the information returned from Info: to access a data file which has Wildcards in the name.

Example: Set GLTrans = Connection.Execute("@L65APST|Mask:PST" )
would return a recordset containing all the records in the GLPST transaction file.

If you have the most recent GL you should use @L80APST as the table name.

Also, for a 12 period GL select only those records where the FP < 13.

Here is a sample SQL

select * from LOCALDATA...[@L80APST|Mask:PST]where FP < 13

Which selects all fields for all ?Special postings? to prior year.