## Reviewing Advanced Cost Accounting Financial Reports for Profitability Analysis

This chapter provides an overview of Advanced Cost Accounting financial reports for profitability analysis and discusses how to:

- Review the Profitability by Cost Object report.

- Review the Income Statement by Cost Object report.

- Review the Trial Balance by Cost Object report.

- Review the Trial Balance by Object Account for Cost Object report.

### Understanding Advanced Cost Accounting Financial Reports

This section discusses Advanced Cost Accounting financial reports, the comparison of profitability of multiple projects and lists prerequisites.

#### Prerequisite

Before you complete the tasks in this section, run the Post To Cost Analyzer Balances program (R1602) to update the Cost Analyzer Balances table (F1602).

#### Advanced Cost Accounting Financial Reports

JD Edwards EnterpriseOne Advanced Cost Accounting provides four financial reports that you can use for profitability analysis and financial reporting with cost objects. The reports are:

- Profitability by Cost Object report (R16023)

- Income Statement by Cost Object report (R16024)

- Trial Balance by Cost Object report (R16025)

- Trial Balance by Object Account for Cost Object report (R16026).

The format for these financial reports is very similar to that of other financial reports within the JD Edwards EnterpriseOne General Accounting system. The difference is that instead of running them by company, business unit, and so on, you can run them by cost object.

All four reports print information from the Cost Analyzer Balances table (F1602), so you must make sure to update this table before running any of the reports. The Cost Analyzer Balances table is updated when you run the Post To Cost Analyzer Balances program (R1602).

#### Comparison of Profitability of Multiple Projects

After you have defined all of the costs for different projects, you can combine the costs to determine the profitability of a project and then compare its profitability to that of other projects. For example, if your company manufactures bicycles, you can compare the profitability of all models from the simplest road bicycle to the most expensive racing bicycle.

To compare the profitability of items by cost objects, use the financial reports provided by JD Edwards EnterpriseOne Advanced Cost Accounting. In the example, cost objects are the different models of bicycle.

### Reviewing the Profitability by Cost Object Report

This section provides an overview of the Profitability by Cost Object report and discusses how to:

- Run the Profitability by Cost Object report.

- Set processing options for Profitability by Cost Object (R16023).

#### Understanding the Profitability by Cost Object Report

This report helps you determine the profitability of a certain product line, customer, business unit, or any other cost object. You can choose any combination of cost objects in any hierarchy and the report will print the profitability for each.

This report prints information from the Cost Analyzer Balances table (F1602) by cost analyzer view, so you must update this table before running the report. The F1602 table is updated when you run the Post To Cost Analyzer Balances program (R1602).

See Also

Posting Entries to the Cost Analyzer Balances Table

#### Running the Profitability by Cost Object Report

Select Reporting menu (G1625), Profitability by Cost Object.

#### Setting Processing Options for Profitability by Cost Object (R16023)

Processing options enable you to specify the default processing for programs and reports.

Process

1. Enter the period number and fiscal year for the report to be based on. If left blank, the financial reporting date will be used. For the financial reporting date to be company specific you must sequence by company or business unit. | Period Number Specify a number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the preparation of financial reports. Fiscal Year Specify a four-digit number that identifies the fiscal year. You can enter a number in this field or leave the field blank to indicate the current fiscal year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 2008, and ends September 30, 2009. The end of the first period is October 31, 2008. Specify the year 2008 rather than 2009.
2. Blank Cost Objects. | 1 = Suppress, Blank = Print

Cost Objects

1. Enter the order in which the Cost Objects should be reported. Leave blank not to include that Cost Object. | Cost Object 1 Cost Object 2 Cost Object 3 Cost Object 4 Item Number
2. Enter the Cost Object View Number for the Cost Analyzer Balances File. | Specify a number from 1 to 10 that specifies how the system posts records from the Account Ledger table (F0911) to the Cost Analyzer Balances table (F1602). This number also specifies which managerial accounting posting code (PM01 - PM10) in the F0911 table to update as posted. For example, if the view number is 1, then the system updates PM01 with a P when the F0911 record is marked as being posted.

### Reviewing the Income Statement by Cost Object Report

This section provides an overview of the Income Statement by Cost Object report and discusses how to:

- Run the Income Statement by Cost Object report.

- Set processing options for Income Statement by Cost Object (R16024).

#### Understanding the Income Statement by Cost Object Report

You can use this report to track revenues, expenses, and the net income or loss for a particular cost object. The report format is similar to other JD Edwards EnterpriseOne income statement reports. You can run the report over a specific cost analyzer view or over all views.

This report prints information from the Account Master table (F0901), the Business Unit Master table (F0006), and the Cost Analyzer Balances table (F1602). You must run the Post To Cost Analyzer Balances program (R1602) to update table F1602 before running the Statement by Cost Object report.

See Also

Posting Entries to the Cost Analyzer Balances Table

#### Running the Income Statement by Cost Object Report

Select Reporting menu (G1625), Income Statement by Cost Object.

#### Setting Processing Options for Income Statement By Cost Object (R16024)

Processing options enable you to specify the default processing for programs and reports.

Select

1. Period Number | Specify the period number that the report should be based on. If left blank, the current financial reporting period will be used.
2. Fiscal Year | Specify the fiscal year that the report should be based on. If left blank, the current financial reporting year will be used.

Print

1. Account Level Of Detail | Specify the lowest level of account level of detail to print on the report.
2. Reverse Sign | Specify whether to reverse the sign of amounts printed on the report. Values are: 0: No sign reversal. Amounts will print in their original debit and credit format. 1: Reverse the sign for all account types. Revenues will print as positive and expenses as negative. 2: Reverse the sign for revenue accounts only. Revenues and expenses will print as positive.
3. Calculate Net Income | Specify if net income should be calculated. Values are: Blank: Do not calculate. 1: Calculate.
4. Headings | Specify how to print the headings. Values are: Blank Print headings on the first page only. 1: Print headings with page number and date on each page. 2: Print headings without page number, but print date on each page.
5. Date Title Type | Specify the date title type to print in the page header. If left blank, no date title will print.

Cost Objects

1. Cost Object/Item Number | Specify which cost object is to be used in the report. If item number is to be used instead of cost object, the processing option value should equal 5. Values are: 1: Cost Object 1 2: Cost Object 2 3: Cost Object 3 4: Cost Object 4 5: Item Number
2. Cost Object Type OR Item Number Type | Specify to select either a cost object type or an item number type to be used in the report. For cost object type, use the visual assist. Values for item number type are: 1: Short Item Number 2: Long Item Number 3: Third Item Number Note. If one of the item number types is selected, the value for processing option 1 needs to equal 5.
3. Cost Object and 4. Item Number | Specify the cost object or item number to be used in the report.
5. View Number | Specify the view number to be used in the report. If a value of zero is entered, all valid view numbers will be used.

### Reviewing the Trial Balance by Cost Object Report

This section provides an overview of the Trial Balance by Cost Object report and discusses how to:

- Run the Trial Balance by Cost Object report.

- Set processing options for Trial Balance by Cost Object (R16025).

#### Understanding the Trial Balance by Cost Object Report

To verify the accuracy of individual ledger account balances and the overall ledger, use the Trial Balance by Cost Object report (R16025). You can also use this report to analyze the debit and credit totals that make up the trial balance for a specific cost object item. The format is similar to that of other JD Edwards EnterpriseOne trial balance reports.

The Trial Balance by Cost Object report allows you to specify whether to use information from the Account Ledger table (F0911) or the Cost Analyzer Balances table (F1602). If you decide to use information from the F1602 table, you must remember to run the Post To Cost Analyzer Balances program (R1602) before running the R16025. The F1602 table is updated only when you run the Post to Cost Analyzer Balances program.

See Also

Posting Entries to the Cost Analyzer Balances Table

#### Running the Trial Balance by Cost Object Report

Select Reporting menu (G1625), Trial Balance by Cost Object.

#### Setting Processing Options for Trial Balance by Cost Object (R16025)

Processing options enable you to specify the default processing for programs and reports.

Period

Fiscal Year | Specify the last two digits of the fiscal year for which the trial balance will be printed. For example, enter 08 for 2008. If you complete this processing option, you must also specify the ending period number in the Period Number processing option. If you leave this processing option blank, the program uses the fiscal year defined for the JD Edwards EnterpriseOne General Accounting system on the Company Setup form and recorded in the Company Constants table (F0010).
Period Number | Specify the period for which the trial balance will be printed. If you complete this processing option, you must also specify the fiscal year for the ending period in the Fiscal Year processing option. If you leave this processing option blank, the program uses the current period defined for the JD Edwards EnterpriseOne General Accounting system on the Company Setup form and recorded in the Company Constants table (F0010).

Print

1. Account Number Format | Specify the format for printed account numbers. Values are: 1: Standard account number (The default is business unit.object.subsidiary) 2: Short account ID (The system assigns) 3: Third GL number (Your organization can assign during account setup) If you leave this processing option blank, the system uses the standard account number.
2. Accounts with Zero Balances | Specify whether the system includes or omits accounts with zero balances for the specified period. Values are: Blank: Include accounts. 1: Omit accounts. Note. Accounts that are assigned a posting edit code of N print even when you set this processing option to 1. Accounts that are assigned a posting edit code of N are header accounts, which do not have balances.
3. Page Breaks | To skip to a new page when the business unit number changes, enter 1. If you leave this processing option blank, the system prints without page breaks.

LOD

1. Lowest Level of Detail | Specify the lowest level of detail to print on the report. You can enter a value between 1 and 9 to tell the system to print that level of detail. For example, if you specify level 7 as the lowest level and your chart of accounts includes levels 8 and 9, level 7 will include the totals for accounts with level 8 and 9 amounts, but the system will not print the detail for levels 8 and 9. Alternatively, you can leave this processing option blank to print all levels of detail on the report. Note. If your chart of accounts was create in a manner that skips levels, the system might produce inaccurate results when it rolls-up detail levels.

Ledger

1. Ledger Type | Specify the type of ledger. The value that you specify must exist in the Ledger Type UDC table (09/LT). If you do not complete this processing option, the system prints amounts for the AA (actual amounts) ledger type. Note. If you specify the CA (foreign currency) ledger type, and the CA ledger type includes amounts for multiple currencies, the totals will be meaningless.

Subledger

1. Subledger | Specify to print amounts for accounts with subledgers. Choices are: Enter a specific subledger number. Enter *. The report will include all subledgers. Leave this processing option blank. The report will include only accounts without subledgers. If you complete this processing option, you must also complete the Subledger Type field. You can specify the subledger type or select it from the Select User Define Code form in the Subledger Type field.
2. Subledger Type | Specifies the table containing the subledger numbers (system 00/type ST). For example, subledger type A identifies the Address Book Master table (F0101). If you complete this processing option, you must also complete the Subledger field.

Currency

1. Currency Code | Specify the currencies that the system includes in the report when you post account balances by currency. To limit the report to amounts for a specific currency code, enter the code for the currency. The value that you enter must exist in the Currency Codes table (F0013). To include amounts for all currencies, enter * (asterisk). Leave this processing option blank if you do not post balances by currency. Note. If you specify the CA ledger type in the Ledger Type processing option, and the CA ledger type includes amounts for multiple currencies, the totals will be meaningless unless you enter a specific currency code for this processing option.

Cost Objects

1. Enter the Cost Object Code to be reported on. | Specify the cost object for the system to use to print the report. Enter a valid cost object code. You can also specify that the system report on a specific item number. If you want to report on a specific item number, enter a value of 5.
2. Enter the Cost Object Type. | Specify the cost object type for the system to use to print the report. Enter a valid cost object type. Or, if you specified in the Cost Object Code processing option to report on a specific item number, enter the format of the item number. Values are: 1: Short item number 2: Third item number 3: Long item number
3. Enter the Cost Object. | Specify the cost object for the system to use to print the report. Enter a valid cost object. Or, if you specified in the Cost Object Code processing option to report on a specific item number, enter the item number. If you want to report on a specific item number, the format must match the value specified in the Cost Object Type processing option. If you want to report on all object types, enter *.
Enter the source for the account information. | Specify the source file for the system to use to print the report. Values are: Blank: Account Ledger table (F0911) 1: Cost Analyzer Balances table (F1602)
Cost Object View Number for Cost Analyzer Balances | Specify the cost analyzer view for the system to use to print the report. Enter the number of a valid cost analyzer view. If you leave this processing option blank or enter 0, the system prints the report for all cost analyzer views.

### Reviewing the Trial Balance by Object Account for Cost Object Report

This section provides an overview of the Trial Balance by Object Account for Cost Object report and discusses how to:

- Run the Trial Balance by Object Account for Cost Object report.

- Set processing options for Trial Balance by Object Account for Cost Object (R16026).

#### Understanding the Trial Balance by Cost Object Report

You can use this report to verify the accuracy of individual ledger account balances and your overall ledger. This report consolidates object accounts across many business units.

This report allows you to specify whether to use information from the Account Ledger table (F0911) or from the Cost Analyzer Balances table (F1602).

If you decide that you want to use information from the Cost Analyzer Balances table (F1602), you must remember to run the Post to Cost Analyzer Balances program (R1602) before running the Trial Balance by Object Account for Cost Object. The Cost Analyzer Balances table (F1602) is updated only when you run the Post to Cost Analyzer Balances program.

See Also

Posting Entries to the Cost Analyzer Balances Table

#### Running the Trial Balance by Object Account for Cost Object Report

Select Reporting menu (G1625), Trial Balance by Object Account for Cost Object.

#### Setting Processing Options for Trial Balance by Object Account for Cost Object (R16026)

Processing options enable you to specify the default processing for programs and reports.

Period

Fiscal Year | Specify the last two digits of the fiscal year for which the trial balance will be printed. For example, enter 08 for 2008. If you complete this processing option, you must also specify the ending period number in the Period Number processing option. If you leave this processing option blank, the program uses the fiscal year defined for the JD Edwards EnterpriseOne General Accounting system on the Company Setup form and recorded in the Company Constants table (F0010).
Period Number | Specify the period for which the trial balance will be printed. If you complete this processing option, you must also specify the fiscal year for the ending period in the Fiscal Year processing option. If you leave this processing option blank, the program uses the current period defined for the JD Edwards EnterpriseOne General Accounting system on the Company Setup form and recorded in the Company Constants table (F0010).

Print

1. Enter a Model Business Unit to retrieve account descriptions from. | Specify the model business unit for the system to use to retrieve account descriptions. Enter a valid model business unit.
2. Accounts with Zero Balances | Specify whether the system includes or omits accounts with zero balances for the specified period. Values are: Blank: Include accounts. 1: Omit accounts. Note. Accounts that are assigned a posting edit code of N print even when you set this processing option to 1. Accounts that are assigned a posting edit code of N are header accounts, which do not have balances.

LOD

1. Lowest Level of Detail | Specify the lowest level of detail to print on the report. You can enter a value between 1 and 9 to tell the system to print that level of detail. For example, if you specify level 7 as the lowest level and your chart of accounts includes levels 8 and 9, level 7 will include the totals for accounts with level 8 and 9 amounts, but the system will not print the detail for levels 8 and 9. Alternatively, you can leave this processing option blank to print all levels of detail on the report. Note. If your chart of accounts was create in a manner that skips levels, the system might produce inaccurate results when it rolls-up detail levels.

Ledger

1. Ledger Type | Specify the type of ledger. The value that you specify must exist in the Ledger Type UDC table (09/LT). If you do not complete this processing option, the system prints amounts for the AA (actual amounts) ledger type. Note. If you specify the CA (foreign currency) ledger type, and the CA ledger type includes amounts for multiple currencies, the totals will be meaningless.

Subledger

1. Subledger | Specify whether to print amounts for accounts with subledgers. Choices are: Enter a specific subledger number. Enter *. The report will include all subledgers Leave this processing option blank. The report will include only accounts without subledgers. If you complete this processing option, you must also complete the Subledger Type field. You can specify the subledger type or select it from the Select User Define Code form in the Subledger Type field.
2. Subledger Type | The user defined code (system 00/type ST) that specifies the table containing the subledger numbers. For example, subledger type A identifies the Address Book Master table (F0101). If you complete this processing option, you must also complete the Subledger field.

Currency

1. Currency Code | Specify the currencies that the system includes in the report when you post account balances by currency. To limit the report to amounts for a specific currency code, enter the code for the currency. The value that you enter must exist in the Currency Codes table (F0013). To include amounts for all currencies, enter * (asterisk). Leave this processing option blank if you do not post balances by currency. Note. If you specify the CA ledger type in the Ledger Type processing option, and the CA ledger type includes amounts for multiple currencies, the totals will be meaningless unless you enter a specific currency code for this processing option.

Cost Objects

1. Enter the Cost Object Code to be reported on. | Specify the cost object for the system to use to print the report. Enter a valid cost object code. You can also specify that the system report on a specific item number. If you want to report on a specific item number, enter a value of 5.
2. Enter the Cost Object Type. | Specify the cost object type for the system to use to print the report. Enter a valid cost object type. Or, if you specified in the Cost Object Code processing option to report on a specific item number, enter the format of the item number. Values are: 1: Short item number 2: Third item number 3: Long item number
3. Enter the Cost Object. | Specify the cost object for the system to use to print the report. Enter a valid cost object. Or, if you specified in the Cost Object processing option to report on a specific item number, enter the item number. If you want to report on a specific item number, the format must match the value specified in the Cost Object Type processing option. If you want to report on all object types, enter *.
4. Enter the source for the account information. | Specify the source file for the system to use to print the report. Values are: Blank: Account Ledger table (F0911) 1: Cost Analyzer Balances table (F1602)
5. Cost Object View Number for Cost Analyzer Balances | Specify the cost analyzer view for the system to use to print the report. Enter the number of a valid cost analyzer view. If you leave this processing option blank or enter 0, the system prints the report for all cost analyzer views.