GL monthly balances

For actual amounts we use the GLAMOUNTS table joined with the GLCGCPY table:
DB_BEG_BAL + CR_BEG_BAL gives you the beginning balance.
DB_AMOUNT_01 + CR_AMOUNT_01 gives you Period 1 balance. Repeat for additional periods

For actual units we use the GLUNITS table joined with the GLCGCPY table:
DB_BEG_BAL + CR_BEG_BAL gives you the beginning balance.
DB_UNITS_01 + CR_UNITS_01 gives you Period 1 balance. Repeat for additional periods

For budget we use the FBDETAIL table joined with the GLCGCPY table:
Amount fields:
DB_BEG_BAL + CR_BEG_BAL gives you the beginning balance.
DB_AMOUNT_01 + CR_AMOUNT_01 gives you Period 1 balance. Repeat for additional periods.

Units fields:
DB_BEG_BAL_UNT + CR_BEG_BAL_UNT gives you the beginning balance.
DB_UNITS_01 + CR_UNITS_01 gives you Period 1 balance. Repeat for additional periods.

We use the GLCGCPY (company group) table to pull records for only the companies in a certain group as we have restructured our GL and have historical information related to closed companies. So we only pull for active companies in the company group we are interested in.

Thank you so much for your prompt response! I will create an SQL or crystal

You are welcome!

If you need the AU and Account descriptions:
GLNAMES contains the COMPANY, ACCT_UNIT and DESCRIPTION.
GLCHARTDTL contains the ACCOUNT, SUB_ACCOUNT and ACCOUNT_DESC