Business

User Tools

Site Tools

Trace: • FIN3550 - 65% Instruction Expenditure Ratio • (OBSOLETE) HRS4550 - Payroll Benefits Expense Distribution • BAM1000 - File Report Detail • FIN1450 - Detail General Ledger by Account Per

Sidebar

Table of Contents

finance:reports:financereports:journalschecksdetailledgers:detailgeneralledgerbyacctper
Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book(0 page(s))
 Help

FIN1450 - Detail General Ledger by Account Per

Finance > Reports > Finance Reports > Journals, Checks, Detail Ledgers > Detail General Ledger by Acct Per

The report allows the user to select a specific fund, function, object, subobject, and program code for which to print transactions. The user can select From and To accounting periods. Vendor transactions allow for printing of either the name of the vendor or the reason for the transaction. Report information is displayed based on the masked account codes set in the User Profiles table for the logged-on user.

Notes:

  • If any errors are encountered while running the report, an error listing is printed at the end of the report. The user can use this information to locate the account code that is in error. The error for the specific account code is printed at the end of the account code line. The following are the errors that may be displayed:
    • Transactions do not equal balance - There are transactions, but the beginning amounts plus the transactions do not equal the ending amounts.
    • EOM does not equal balance - There are no transactions, but the beginning amounts and the ending amounts are not equal.
    • Error suspect records - Class does not equal 1-8.
  • The report displays account transactions using the From Accounting Period and To Accounting Period report parameters. The beginning account balances are calculated by using a Starting Accounting Period of the Finance Fiscal Year of 07 or 09 (fiscal year July or September) and adding all transactions up to the from accounting period. The ending balance is calculated by adding all requested transactions and the beginning balance.

Note: If the Starting Accounting Period of the Finance Fiscal Year report parameter is equal to the From Accounting Period and To Accounting Period report parameters, and the user types Y in the Include Previous Months' Balances? (Y/N) report parameter, the program assumes a beginning balance of zero, since there is no difference between the starting accounting period and the from accounting period.

Example 1: The user types Y in the Include Previous Months' Balances? (Y/N) report parameter. The Starting Accounting Period of the Finance Fiscal Year, From Accounting Period, and To Accounting Period report parameters are all set to 09. The system assumes a zero balance, since there is no difference between the accounting periods.

Example 2: The user types Y in the Include Previous Months' Balances? (Y/N) report parameter. The Starting Accounting Period of the Finance Fiscal Year, From Accounting Period report parameter is set to 07, and the From Accounting Period and To Accounting Period report parameters are set to 09. The system displays the balances from 07 to 08 and any transactions created in 09.

Parameter Parameter Description
Include Previous Months' Balances? (Y/N)

Y - Include balances from previous months on the report.

N - Do not include balances from previous months on the report.

This is a required field.

Enter the Starting Accounting Period of the Finance Fiscal YearType 07 or 09 to indicate the first month of the Finance fiscal year.
From Accounting PeriodType the two-digit from accounting period. This is a required field.
To Accounting PeriodType the two-digit to accounting period. This is a required field.
Print Vendor Name (N), Reason (R)

N - Print the vendor name on the report.

R - Print the reason on the report.

This is a required field.

Include Requisition soft encumbrance transactions when PO encumbrance exists? (Y/N)

Y - Include requisition soft encumbrance transactions on the report when a purchase order encumbrance exists.

N - Do not include requisition soft encumbrance transactions on the report when a purchase order encumbrance exists.

This is a required field.

Use Check date (C) or Transaction date (T) for check transactions

C - Use the check date for check transactions on the report.

T - Use the transaction date for check transactions on the report.

This is a required field.

Enter significant digits for fields to select on

Type the account code numbers or account code number mask separating multiple account code numbers with a comma (e.g., 199-XX-XXXX.XX-XXX-XXXXXX, 224-XX-XXXX.XX-XXX-XXXXXX). Or, click Ellipsis Icon to create an account code mask. Otherwise, leave blank to use all account codes.

Enter Optional Report TitleType a report title using a maximum of 60 alphanumeric characters.
Include Budget? (Y/N)Y - Include all accounts.

N - Exclude 5XXX-8XXX accounts.

Generate the report.

finance/reports/financereports/journalschecksdetailledgers/detailgeneralledgerbyacctper.txt · Last modified: 2022/10/03 18:53 by emoreno

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.