AC100 – BALANCE SHEET
|
The AC100
produces a Balance Sheet from the GL_JOURNAL based on parameters selected.
The Balance Sheet will show Debit, Credit and Net Balance for each account,
each group of accounts (by Item/Sub), totals for all asset accounts, totals
for all liability accounts and a net balance of assets and liabilities based
on the parameters selected. An overall
balance sheet is provided at the end of the report showing only the Item/Sub
summary level for the balance sheet.
GL-JOURNAL level details can be printed using a report parameter. If the reports parameters are set with using only the
fiscal year and the posting date range set for the beginning range of the
fiscal year and the ending date for any month end period (or for the ending
date of the fiscal year) a standard balance sheet will be produced. The
parameters within the SY31 screen allow the balance sheet to filter the
records using combinations of: |
·
Fiscal year, posting date range and type, item, sub. ·
Fiscal year, posting date range, type, item, sub, and any
combination of account segments. ·
Fiscal year, posting date range, type, item, sub, and any
combination of account segments that have been limited with wildcard queries (i.e.
in the sample segment 4 is ‘ACCT’ then segment 4 could be queried by using
‘5%’ selecting all accounts that begin with ‘5’ or could be queried
using ‘%002’ selecting all accounts
that end in ‘002’) These
combinations allow a great deal of flexibility in use of the report,
including (but not limited to) the ability to produce a standard balance
sheet or produce specific segments of a balance sheet showing payables or
receivables to specific authorities, groups of authorities, by roll types,
years, or by any account segments. |
||
|
NOTE: The specific fields
with permissible entries to be filled in or left blank are listed
below. Ignore fields that are not in the list next to the screens. |
|||
|
Figure 1. SY41 (TOP) |
1. Job: Report name should always appear
here. For example, AC100. 2. Server Name: Keep the server name that
first appears. 3. Printer_Name:
Select a
valid printer or keep the displayed printer if one is present. 4. Jurisdiction: Enter your jurisdiction. 5. Tax Year: Enter the fiscal year. 6. Spool File Name: Enter AC100.LIS to create the file in text format. 7. Beginning Date: Enter beginning posting date. 8. Ending Date: Enter ending posting date. 11. ALT1 PRINT (JOURNAL DETAILS(Y/N)): Enter ‘Y’ to print detail journal entries at the end of
the report. 12. ALT2 (STARTING JOURNAL NO.): Enter starting journal number to include. If blank all
will be listed. 13.
FCU: Formatting code. Keep the default printer setting that is
present when the screen appears. If blank, enter HPLL132. 16. ORDER BY (ENDING JOURNAL NO.): Enter ending journal number to include. If null, all will
be selected. 17. PARAM1 SEG1: Enter specific segment 1 data to filter the
selection. The field allows multiple
codes separated by commas. If null, all will be selected. 18. PARAM2 SEG2: Enter specific segment 2 data to filter the
selection. The field allows multiple codes separated by commas. If null, all
will be selected. 19. PARAM3 SEG3: Enter specific segment 3 data to filter the
selection. The field allows multiple codes separated by commas. If null, all
will be selected. 20. PARAM4 SEG4: Enter
specific segment 4 data to filter the selection. The field allows multiple
codes separated by commas. If null, all will be selected. 21. PARAM5 TYPE ITEM SUB:
Enter specific type, item and sub group.
If null, all will be selected. |
|
|
Figure 2. SY 41
(BOTTOM) |
||
Press
[Submit Job]. The system will notify you when the report is finished.
REPORT SAMPLE
.
