GL95.1 - Account Analysis Use GL95.1 (Account Analysis) to inquire on a wide range of account information for a company based on specific account and period criteria. Choose the Account button to display account period and year to date totals. Choose the AcctUnit button to display accounting unit period and year to date totals. Choose the Company button to display company period and year to date totals. Choose the Annual button to display period totals, year to date totals, and beginning balances for the current year and last year. Choose the Totals button to display beginning balances, period totals, ending balances, and the percentage change for the current year and last year. Choose the Chart button to display chart detail. Information you define on this subform will override the company, account, and period data you selected in GL95.1 Choose the Org View button to display accounting unit view detail. Updated Files RATOTALS - Used to store total amounts. ULTOTALS - Used to store totals for an accounting unit list and an account range. Referenced Files CUCODES - Used to validate currency codes. FBDETAIL - Used to access posting account period budget balances. FBHEADER - Used to validate budgets. GLADDRESS - Used by common library; not referenced in this program. GLCGCPY - Used to access companies associated to a company group. GLCHART - Used to validate the chart. GLCHARTDTL - Used to access detail account information. GLCHARTSUM - Used to access summary account information. GLCPYGRP - Used to validate a company group. GLMASTER - Used to access posting account information. GLNAMES - Used to validate accounting units. GLSYSTEM - Used to validate companies. MXLISTHDR - Used to validate accounting unit lists. MXLISTMBR - Used to access accounting units associated with an accounting unit list. MXVIEWDTL - Used to access accounting unit view detail. MXVIEWHDR - Used to validate an accounting unit list. RWGRPDET - Used to retrieve ranges of levels, accounts, and subaccounts. RWHEADER - Used by common library; not referenced in this program. RWROWDET - Used by common library; not referenced in this program. ULPOST - Used to access last posting date and time. GL95.2 - Fiscal Year Summary Use GL95.2 (Fiscal Year Summary) to view the annual current and last year and year-to-date period amounts or units based on the parameters you select in GL95.1 (Account Analysis). Updated Files RATOTALS - Used to store total amounts. ULTOTALS - Used to store totals for an accounting unit list and an account range. Referenced Files CUCODES - Used to validate currency codes. FBDETAIL - Used to access posting account period budget balances. FBHEADER - Used to validate budgets. GLADDRESS - Used by common library; not referenced in this program. GLCGCPY - Used to access companies associated with a company group. GLCHART - Used to validate the chart. GLCHARTDTL - Used to access detail account information. GLCHARTSUM - Used to access summary account information. GLCPYGRP - Used to validate a company group. GLMASTER - Used to access posting account information. GLNAMES - Used to validate accounting units. GLSYSTEM - Used to validate companies. MXLISTHDR - Used to validate an accounting unit list. MXLISTMBR - Used to access accounting units associated with an accounting unit list. MXVIEWDTL - Used to access accounting unit view detail. MXVIEWHDR - Used to validate an accounting unit view. RWGRPDET - Used to retrieve ranges of levels, accounts, and subaccounts. RWHEADER - Used by common library; not referenced in this program. RWROWDET - Used by common library; not referenced in this program. ULPOST - Used to access the last posting date and time. GL95.3 - Totals Use GL95.3 (Totals) to view current fiscal year and last fiscal year beginning balances, period range totals, and ending balances. Choose the Annual button to view the annual current and last year and year to date amounts or units. Updated Files RATOTALS - Used to store total amounts. ULTOTALS - Used to store totals for an accounting unit list and an account range. Referenced Files CUCODES - Used to validate currency codes. FBDETAIL - Used to access posting account period budget balances. FBHEADER - Used to validate budgets. GLADDRESS - Used by common library; not referenced in this program. GLCGCPY - Used to access companies associated with a company group. GLCHART - Used to validate the chart. GLCHARTDTL - Used to access detail account information. GLCHARTSUM - Used to access summary account information. GLCPYGRP - Used to validate a company group. GLMASTER - Used to access posting account information. GLNAMES - Used to validate accounting units. GLSYSTEM - Used to validate companies. MXLISTHDR - Used to validate an accounting unit list. MXLISTMBR - Used to access accounting units associated with an accounting unit list. MXVIEWDTL - Used to access accounting unit view detail. MXVIEWHDR - Used to validate an accounting unit view. RWGRPDET - Used to retrieve ranges of levels, accounts, and subaccounts. RWHEADER - Used by common library; not referenced in this program. RWROWDET - Used by common library; not referenced in this program. ULPOST - Used to access the last posting date and time. GL95.4 - Chart Query Use GL95.4 (Chart Query) to view specific chart information. Any information you select overrides the information you selected in GL95.1 (Account Analysis). After you complete the form and press OK, the Periods vs. Year to Date subform appears. Use this subform to view period and year-to-date chart amounts for the year and period you selected in GL95.1 (Account Analysis). In this subform, you can view additional detail. Updated Files RATOTALS - Used to store total amounts. RWFORMAT - Used to build a format for use by this program. ULTOTALS - Used to store totals for an accounting unit list and an account range. Referenced Files CMPUTE - Used by common library; not referenced in this program. CUCODES - Used to validate currency codes. FBDETAIL - Used to access posting account period budget balances. FBHEADER - Used to validate budgets. GLADDRESS - Used to validate companies. GLCGCPY - Used to access companies associated with a company group. GLCHART - Used to validate the chart. GLCHARTDTL - Used to access detail account information. GLCHARTSUM - Used to access summary account information. GLCPYGRP - Used to validate a company group. GLMASTER - Used to access posting account information. GLNAMES - Used to validate accounting units. GLSYSTEM - Used to validate companies. MXLISTHDR - Used to validate an accounting unit list. MXLISTMBR - Used to access accounting units associated with an accounting unit list. MXVIEWDTL - Used to access accounting unit view detail. MXVIEWHDR - Used to validate an accounting unit view. RWDICT - Used to validate data dictionary items. RWGRPDET - Used to retrieve ranges of levels, accounts, and subaccounts. RWHEADER - Used by common library; not referenced in this program. RWROWDET - Used by common library; not referenced in this program. ULPOST - Used to access the last posting date and time. GL95.5 - Periods vs. YTD Use GL95.5 (Periods vs. Year-to-Date) to display period and year-to-date chart amounts for the year and period selected in GL95.4 (Chart Query). Choose the Cur,Last button to display current and last year amounts for the chart you selected in GL95.4. Choose the Act,Bud button to displays year-to-date and budget amounts for the chart you selected in GL95.4. Choose the CSV Export button to create a comma separated value (.csv) file. Updated Files RATOTALS - Used to store total amounts. ULTOTALS - Used to store totals for an accounting unit list and an account range. Referenced Files CUCODES - Used to validate currency codes. FBDETAIL - Used to access posting account period budget balances. FBHEADER - Used to validate a budget. GLADDRESS - Used by common library; not referenced in this program. GLCGCPY - Used to access companies associated with a company group. GLCHART - Used to validate the chart. GLCHARTDTL - Used to access detail account information. GLCHARTSUM - Used to access summary account information. GLCPYGRP - Used to validate a company group. GLMASTER - Used to access posting account information. GLNAMES - Used to access accounting unit information. GLSYSTEM - Used to access company information. MXLISTHDR - Used to validate an accounting unit list. MXLISTMBR - Used to access accounting units associated with an accounting unit list. MXVIEWDTL - Used to access accounting unit view detail. MXVIEWHDR - Used to validate an accounting unit view. RWGRPDET - Used to access level, account, or subaccount groups. RWHEADER - Used by common library; not referenced in this program. RWROWDET - Used by common library; not referenced in this program. ULPOST - Used to access the last posting date and time. GL95.6 - YTD Current Year vs. Last Year Use GL95.6 (YTD Current Year vs. Last Year) to view year-to-date amounts for the current year and the prior year. Choose the Period button to view current and last year amounts for a specific period. Choose the Act,Bud button to display year to date and budget amounts for a specific chart of accounts. Choose the CSV Export button to create a comma separated value (.csv) file. Updated Files RATOTALS - Used to store total amounts. ULTOTALS - Used to store totals for an accounting unit list and an account range. Referenced Files CUCODES - Used to validate currency codes. FBDETAIL - Used to access posting account period budget balances. FBHEADER - Used to validate a budget. GLADDRESS - Used by common library; not referenced in this program. GLCGCPY - Used to access companies associated with a company group. GLCHART - Used to validate the chart. GLCHARTDTL - Used to access detail account information. GLCHARTSUM - Used to access summary account information. GLCPYGRP - Used to validate a company group. GLMASTER - Used to access posting account information. GLNAMES - Used to access accounting unit information. GLSYSTEM - Used to access company information. MXLISTHDR - Used to validate an accounting unit list. MXLISTMBR - Used to access accounting units associated with an accounting unit list. MXVIEWDTL - Used to access accounting unit view detail. MXVIEWHDR - Used to validate an accounting unit view. RWGRPDET - Used to access level, account, or subaccount groups. RWHEADER - Used by common library; not referenced in this program. RWROWDET - Used by common library; not referenced in this program. ULPOST - Used to access the last posting date and time. GL95.7 - Periods Current Year vs. Last Year Use GL95.7 (Periods Current Year vs. Last Year) subform to view period amounts for the current year and the prior year. Choose the CSV Export button to create a comma separated value (.csv) file. Updated Files RATOTALS - Used to store total amounts. ULTOTALS - Used to store totals for an accounting unit list and an account range. Referenced Files CUCODES - Used to validate currency codes. FBDETAIL - Used to access posting account period budget balances. FBHEADER - Used to validate a budget. GLADDRESS - Used by common library; not referenced in this program. GLCGCPY - Used to access companies associated with a company group. GLCHART - Used to validate the chart. GLCHARTDTL - Used to access a detail account. GLCHARTSUM - Used to access a summary account. GLCPYGRP - Used to validate a company group. GLMASTER - Used to access a posting account. GLNAMES - Used to access an accounting unit. GLSYSTEM - Used to access a company. MXLISTHDR - Used to validate an accounting unit list. MXLISTMBR - Used to access accounting units associated with an accounting unit list. MXVIEWDTL - Used to access accounting unit view detail. MXVIEWHDR - Used to validate an accounting unit view. RWGRPDET - Used to access level, account, or subaccount groups. RWHEADER - Used by common library; not referenced in this program. RWROWDET - Used by common library; not referenced in this program. ULPOST - Used to access the last posting date and time. GL95.8 - YTD Actual vs. Budget Use GL95.8 (Year-to-date Actual vs. Budget) subform to view year-to-date and budget amounts for a specific chart of accounts. Choose the Period button to view current and last year amounts for a specific period. Choose the CSV Export button to create a comma separated value (.csv) file. Updated Files RATOTALS - Used to store total amounts. ULTOTALS - Used to store totals for an accounting unit list and an account range. Referenced Files CUCODES - Used to validate currency codes. FBDETAIL - Used to access posting account period budget balances. FBHEADER - Used to validate a budget. GLADDRESS - Used by common library; not referenced in this program. GLCGCPY - Used to access companies associated with a company group. GLCHART - Used to validate the chart. GLCHARTDTL - Used to access a detail account. GLCHARTSUM - Used to access a summary account. GLCPYGRP - Used to validate a company group. GLMASTER - Used to access a posting account. GLNAMES - Used to access an accounting unit. GLSYSTEM - Used to access a company. MXLISTHDR - Used to validate an accounting unit list. MXLISTMBR - Used to access accounting units associated with an accounting unit list. MXVIEWDTL - Used to access accounting unit view detail. MXVIEWHDR - Used to validate an accounting unit view. RWGRPDET - Used to access level, account, or subaccount groups. RWHEADER - Used by common library; not referenced in this program. RWROWDET - Used by common library; not referenced in this program. ULPOST - Used to access the last posting date and time. GL95.9 - Periods Actual vs. Budget Use GL95.9 (Periods Actual vs. Budget) subform to view period range actual and budget totals for a specific chart of accounts. Choose the CSV Export button to create a comma separated value (.csv) file. Updated Files RATOTALS - Used to store total amounts. ULTOTALS - Used to store totals for an accounting unit list and an account range. Referenced Files CUCODES - Used to validate currency codes. FBDETAIL - Used to access posting account period budget balances. FBHEADER - Used to validate a budget. GLADDRESS - Used by common library; not referenced in this program. GLCGCPY - Used to access companies associated with a company group. GLCHART - Used to validate the chart. GLCHARTDTL - Used to access a detail account. GLCHARTSUM - Used to access a summary account. GLCPYGRP - Used to validate a company group. GLMASTER - Used to access a posting account. GLNAMES - Used to access an accounting unit. GLSYSTEM - Used to access a company. MXLISTHDR - Used to validate an accounting unit list. MXLISTMBR - Used to access accounting units associated with an accounting unit list. MXVIEWDTL - Used to access accounting unit view detail. MXVIEWHDR - Used to validate an accounting unit view. RWGRPDET - Used to access level, account, or subaccount groups. RWHEADER - Used by common library; not referenced in this program. RWROWDET - Used by common library; not referenced in this program. ULPOST - Used to access the last posting date and time. INVOKED Programs GLBL IFUP GLRV IFSG GLCV |