Use this screen to review postings you made to the General Ledger either by account or by project. You can create inquiries for either one or multiple periods by account or by project. Line items will describe the activity (debit and credit) that posted to either the account or to the project in question.
You can obtain more detail for the posted transaction in the Posting Detail subtask (accessed by selecting the Posting Detail subtask link).
The Account Activity Inquiry screen is made up of two blocks, a table window, and a subtask. You can use them in the following manner:
The Select block contains fields for inquiry type, account, project, periods to display, beginning/ending balances, and current period/prior periods activity. The Table Window contains fields that display the individual journal postings that support the period balance
Use the Posting Detail subtask to view additional posting detail for the selected fiscal year, period, account, and project.
To obtain the greatest accuracy, use this screen once you have closed the period(s) in question.
Use the fields in this block to tailor the inquiry that you are making.
Select this radio button to review postings made to the General Ledger by account.
Select this radio button to review postings made to the General Ledger by project.
Enter, or use Lookup to select, an account. You originally assigned the account in the Accounts screen (Accounting\Maintain\Accounts\Accounts).
Enter the level of detail needed. If you enter a large number, the report will be more detailed. If you enter a small number, the report will be less detailed.
|
|
Note: Entering a "zero" in this field will result in a report with full detail. |
Select this checkbox to include lower levels of the account.
Enter, or use Lookup to select, a project. You originally assigned the project in the Projects screen (Projects\Maintain\Project\Projects).
Enter the level of detail needed.
If you enter a large number, the report will be more detailed. If you enter a small number, the report will be less detailed.
|
|
Note: Entering a "zero" in this field will result in a report with full detail. |
Select this checkbox to include lower levels of the project.
Enter, or use Lookup to select, a fiscal year.
Period *
Enter, or use Lookup to select, a period.
This field displays the total of the beginning balance.
This field displays the total of the prior period activity.
This field displays the total of the current period activity.
This field displays the total of the ending balance.
This field displays the subperiod the transaction was posted to the General Ledger.
This field displays the specified project.
This field displays the name of the project.
This field displays the specified organization.
This field displays the name of the organization.
This field displays the journal code for the posted transaction.
This field displays the posting sequence for the posted transaction.
This field displays the amount of the posted transaction.
This field displays the amount of the posted transaction expressed in terms of your company's transaction currency.
This field displays the currency code of your company's transaction currency.
This field displays a description of the posted transaction.
This field displays the number of hours posted to the transaction.
This field displays the general labor category of the posted transaction.
This field displays a description of the general labor category.
This field displays the project labor category of the posted transaction.
This field displays a description of the project labor category.
This field displays the effective billing date of the posted transaction.
This field displays the timesheet date of the posted transaction.
This field displays the ID.
This field displays the ID Type (Vendor, Employee, Customer, or Subcontractor).
|
|
Note: The following values are used for the ID Type when posting to the general ledger: N – Non Labor Post IWO Journal Post JEs V – Vendor Create/Post AP Vouchers for Travel Expense/Advance/Company Paid Expense Post Cash Disbursements Post Vouchers (Vendor Labor or No Labor) Compute/Post Unrealized Gains/Losses – AP Gain/Loss Post IWO Journal Post JEs S – Vendor Employee Post Vouchers (Vendor Employee Labor) Post IWO Journal Post JEs E – Employee Post IWO Journal Post Labor Distribution Post JEs C – Customer Post Standard Bills Post Cash Receipts Adjust A/R Underpayment Amounts Post Milestone/Percent Compete Bills Post Progress Payment Bills Post Project Product Bills Post Manual Bills Post Customer Product Bills Compute/Post Unrealized Gains/Losses – AR Gain/Loss O – Customer Post Sales Order Journal I – Inventory Post Inventory Journal |
This field displays the check number of the posted transaction.
This field displays the voucher number of the posted transaction.
This field displays the PO number of the posted transaction.
This field displays the vendor, employee, or vendor employee name associated with the ID field for this posted transaction.
This field displays the invoice number of the posted transaction.
This field displays the journal entry number of the posted transaction.
This field displays the cash receipt number of the posted transaction.
This field displays the bill number of the posted transaction.
This field displays the item ID of the posted transaction.
This field displays the revision number of the posted transaction.
This field displays the first reference number of the posted transaction.
This column displays the name of the first reference number of the posted transaction.
This field displays the second reference number of the posted transaction.
This column displays the name of the second reference number of the posted transaction.
* A red asterisk denotes a required field.
Select this link to open the Posting Detail and view additional posting detail for the selected fiscal year, period, account, and project.
This screen accesses the GL_DETL (GL Detail) table.
