G/L Account Inquiry
General Ledger Menu -> Account Inquiry
This program is the basic General Ledger account inquiry. Activity can be reviewed for one account at a time.
The source posting function name is included on the spreadsheet output and the expanded detail output using the "Paging" option. For more information on the source posting functions, refer to G/L Activity By Posting Source.
To view detailed postings by a transaction or transaction group, refer to the Account Inquiry by Transaction # utility instead.
The prompts by account are:
ACCOUNT NUMBER
Enter the account number to be displayed, or select it from the G/L Account Search window.
DIVISION, ALL, OR SEL
•Type ALL to include all divisions in the report.
•To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
•Type SEL to select several specific divisions or divisions by accounting region to include in the report, as outlined in Division Select By Region.
Note: This report respects the Divisional Restricted Views designated for the operator.
YEAR START DATE
Enter your fiscal year start date.
This defaults to the date previously defined when the GL account totals were last summarized, and can be over-typed as required.
PERIOD START DATE
Enter the date to begin the inquiry.
This defaults to the date previously defined when the GL account totals were last summarized, and can be over-typed as required.
PERIOD END DATE
Enter the end date for the inquiry.
This defaults to the date previously defined when the GL account totals were last summarized, and can be over-typed as required.
PRODUCT
This field can be left blank to include all transactions in the selection range.
A product number can be enter to select only transactions relating to that specific product in the selection range. An Inventory Search window is provided to search for the product number.
ACCUMULATE PRIOR BALANCE
Uncheck this box to restrict the total balances of the Debits and Credits, and the balance difference that are displayed, to just the transactions in the date range selected.
This could be faster as the software is not required to calculate the balance forward.
Check this box to include the sum of prior entries to produce a balance forward for Debits, Credits, and the balance difference.
This may take longer processing time depending on the volume of data history.
Note: When Accumulating Prior Balances the General Ledger accounts are totalled as follows:
Asset or Liability: Balance forward is from beginning of time.
Revenue or Expense: Balance forward is from Fiscal Year Start selected above.
REPORT OPTIONS
Select one of the following output options:
•Select Paging to generate the information in a detailed paging screen format providing the ability to move through the transactions and to drill down to document and G/L details, as outlined in G/L Transaction Details.
•Select Print to generate the output according to the reporting selection currently defined for this session in the Printer Selection window, accessible from the Printer -> Set Printer option located on the menu bar at the top of the screen.
Output can be in summary or detail.
•Select Excel to export the output the G/L transaction Detail to a spreadsheet.
The ability to email the spreadsheet or display it on the screen is controlled by the Prompt to Email Spreadsheets flag set in Company Miscellaneous Parameters.
Note: Report totals are not generated on the spreadsheet format.
OUTPUT TYPE
This field applies only when the Report Option is for the Display format.
Select one of the following output type options for the display:
•Select Summary to view only totals for that date range.
This option is not available for the Paging or Excel output options.
•Select Detail to view each transaction for that account for that date range.
Finished?
Click ACCEPT to generate the output, or click CANCEL to abort.
Example of Detailed Display Inquiry:
(with no paging screen & accumulating prior balance)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
G/L ACCOUNT INQUIRY FOR: 4000 RENTAL REVENUE
DIVISION: HEAD OFFICE
FROM: 10/01/20XX TO: 10/31/20XX
TRANS# DIV DATE SOURCE REFERENCE DEBIT CREDIT PRODUCT/SERV TAX DETAILS
------ --- ---- ------ --------- ----- ------ ------------ --- -------
101015 1 10/01/20XX 573328 SWANSON ELEC. 3000.00 1901-01
101017 1 10/01/20XX 573329 CASH SALES 450.00 S007
101020 1 10/05/20XX 573330 CASH SALES 200.00 S008
101023 1 10/20/20XX 573331 FORD CORP. 4500.00 2301-03
101025 1 10/31/20XX 573332 CASH SALES 1000.00 1401-00
101030 1 10/31/20XX 573333 CASH SALES 1043.00 S003-A
101036 1 10/31/20XX 573334 CASH SALES 105.00 SERV1
0.00 11243.00
BALANCE: 56124.56-
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Topic Keyword: GLGL15