4Reports and Inquiry
Option 3Balances by Subsidiary Code Report
This function prints a summary of the Subsidiary Codes by Account file by account number within subsidiary code. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Subsidiary Codes by Account information, this step provides sequencing of data records by Subsidiary Code and Account, with no option to change the sequence at run time. Selection of data records is provided by Account Component, Subsidiary Code, Subsidiary code Type, and Alpha Sort, with the option to enter user-specified comparisons at run time.
- Step 2This disposition type is used for all standard General Subsidiary reports.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Balances by Subsidiary Code Report, this step formats the Subsidiary Codes by Account information. The following data items are shown: Account, Description, Added On, Subsidiary Code Type, Alpha Sort, Month-to-Date Balance, Year-to-Date Balance, and Life-to-Date Balance. As appropriate, group headers and totals are printed whenever a change occurs in Subsidiary Code.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 16:17 LGG Page: 1
Balances by Subsidiary Code Report
Account Description Date Added Type Sort MTD Balance YTD Balance LTD Balance
=================================================================================================================================
Subsidiary Code COMPUTER 1 COMPUTER New Computer Syst. Development
1150001000MA Equipment 07/10/89 1 COMPUTER .00 .00 121630.00
1170001000 Accumulated Depreciation 07/10/89 1 COMPUTER 1904.00- 1904.00- 30844.00-
4040001000 Depreciation Expense 07/10/89 1 COMPUTER 1904.00 1904.00 30844.00
4080000000 Salaries Expense 07/10/89 1 COMPUTER 50421.74 50421.74 128273.83
4090000000MA Repairs and Maintenance, Mfg. 07/10/89 1 COMPUTER 3789.84 3789.84 37500.35
4110000000 Travel and Entertainment 07/10/89 1 COMPUTER 4645.39 4645.39 60286.64
4160000000 Direct Labor 07/10/89 1 COMPUTER 54499.44 54499.44 159065.75
4180000000 Indirect Labor 07/10/89 1 COMPUTER 7151.30 7151.30 92365.99
—————— —————— ——————
— Subsidiary Code Subtotals —> 120507.71 120507.71 599122.56
============= ============ =============
Subsidiary Code GENERAL 2 GENERAL Non Project-Specific Costs
1150001000MA Equipment 07/10/89 2 GENERAL .00 .00 476670.00
1170001000 Accumulated Depreciation 07/10/89 2 GENERAL 55917.00- 55917.00- 711143.74-
4040001000 Depreciation Expense 07/10/89 2 GENERAL 55917.00 55917.00 55917.00
4080000000 Salaries Expense 07/10/89 2 GENERAL 33888.78 33888.78 33888.78
4090000000MA Repairs and Maintenance, Mfg. 07/10/89 2 GENERAL 56783.41 56783.41 56783.41
4110000000 Travel and Entertainment 07/10/89 2 GENERAL 30091.77 30091.77 30091.77
4160000000 Direct Labor 07/10/89 2 GENERAL 103633.51 103633.51 103633.51
4180000000 Indirect Labor 07/10/89 2 GENERAL 17580.65 17580.65 17580.65
—————— —————— ——————
— Subsidiary Code Subtotals —> 241978.12 241978.12 63421.38
============ ============ ============
Subsidiary Code JONES 2 JONES Salesperson Sam Jones
3010001001MA Sales, Manufacturing 07/10/89 2 JONES 139742.17- 411194.51- 411194.51-
4010000001MA Cost of Goods Sold, Sales/Mfg. 07/10/89 2 JONES 5625.78 15004.70 15004.70
4020000001MA Sales Commissions, Mfg. 07/10/89 2 JONES .00 27145.24 27145.24
4100000001MA Promotion/Advertising, Mfg. 07/10/89 2 JONES 4100.00 11200.00 11200.00
4110000001MA Travel & Entertainment, Sales 07/10/89 2 JONES 7381.16 15939.33 15939.33
4190000001MA Freight Out, Sales/Mfg. 07/10/89 2 JONES 1485.17 4642.08 4642.08
—————— —————— ——————
— Subsidiary Code Subtotals —> 121150.06- 337263.16- 337263.16-
=========== ============= =============
Subsidiary Code PETERS 2 PETERS Salesperson George Peters
3010001001MA Sales, Manufacturing 07/10/89 2 PETERS 130429.41- 382984.83- 382984.83-
4010000001MA Cost of Goods Sold, Sales/Mfg. 07/10/89 2 PETERS 5311.16 14640.76 14640.76
4020000001MA Sales Commissions, Mfg. 07/10/89 2 PETERS .00 25255.54 25255.54
4100000001MA Promotion/Advertising, Mfg. 07/10/89 2 PETERS 3200.00 10450.00 10450.00
4110000001MA Travel & Entertainment, Sales 07/10/89 2 PETERS 5874.62 14158.82 14158.82
4190000001MA Freight Out, Sales/Mfg. 07/10/89 2 PETERS 1239.08 3515.66 3515.66
—————— —————— ——————
— Subsidiary Code Subtotals —> 114804.55- 314964.05- 314964.05-
============= ============= =============