| Table of Contents | ||
|---|---|---|
|
About
...
general ledger lookup
The general ledger (GL) lookup shows financial transactions booked to the general ledger.
General Ledger Lookup Configuration
For the General Ledger Lookup to produce intended results, these settings need to be configured.
...
Prerequisites
Fiscal Years (Admin > STParm) Parameter Code ZZFISC: The parameter code ZZFISC needs an entry for each fiscal year to be queried. The value tends to 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.
General Ledger Control (Accounting > GL Control) Current Fiscal Year: The Current Fiscal Year should be set in the General Ledger Control page, and should match the numeric values of an existing ZZFISC parameter code value (GL Current Fiscal Year 2324 for ZZFISC FY2324.)
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.
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.
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.
Access General Ledger Lookup
Permission #812 is required to access this function.
Specific cost centers and cost center groups shown are controlled by cost center permissions.
Navigate Configure Cost Center Permissions (Accounting > Cost Center Permissions): This controls what accounts the user can see.
Required permissions
Module | Number | Description |
|---|---|---|
General Ledger | 812 | Use general ledger lookup |
Use general ledger lookup
Go to Accounting > GL Lookup.
Select the Cost Center, Cost Center Group or PET Number.
Choose Optionally select additional criteria.
Click Submit.
A new screen appears; use click the magnifying glass to display detail for each GL account; use the Export to Excel to download detail for each GL account.
