About general ledger lookup

The general ledger (GL) lookup shows financial transactions booked to the general ledger.

Prerequisites

1. Fiscal Years (Admin > STParm) Parameter Code ZZFISC: The parameter code ZZFISC needs an entry for each fiscal year to be queried. The value should be FYXXYY, where XX and YY are the year codes - for example FY2324 for the Fiscal Year 2023-2024. If a fiscal year is the same as a calendar year, FY2023 would represent Fiscal Year 2023.

2. General Ledger Control (Accounting > GL Control) Current Fiscal Year: The Current Fiscal Year should be set in General Ledger Control, and should match the numeric values of an existing ZZFISC parameter code value (GL Current Fiscal Year 2324 for ZZFISC FY2324.)

3. General Ledger Account Maintenance (Accounting > GL Account Maintenance) Accounts Set Up For Current Fiscal Year: The General Ledger Account entries have a Fiscal Year identifier, and need to have new Fiscal Year entries. For example, a General Ledger account "Payroll" would need to have a FY2223 entry, a FY2324 entry, and so on. There is a copy function on the General Ledger Account Maintenance page to copy all General Ledger accounts from one Fiscal Year to the next.

4. General Ledger Funds (Accounting > GL Funds) Fiscal Year entry and dates: The General Ledger Funds table needs an entry for the current fiscal year, with appropriate period begin and end dates. There is a copy function on the General Ledger Funds page to copy the Fiscal Year entry from one year to the next.

5. General Ledger Budget Table (Accounting > GL Budget) Account Entry: The General Ledger Budget table needs to have at least one account entry for the current fiscal year, even if the balance is zero. There is a copy function on the General Ledger Budget Table page to copy accounts from one fiscal year to the next.

6. Configure Cost Center Permissions (Accounting > Cost Center Permissions): This controls what accounts the user can see.

Required permissions

Use general ledger lookup

1. Go to Accounting > GL Lookup.

2. Select the Cost Center, Cost Center Group or PET Number.

3. Optionally select additional criteria.

   Open

   

4. Click Submit.

5. A new screen appears; click the magnifying glass to display detail for each GL account; use the Export to Excel to download detail for each GL account.

   Open