This chapter contains the following topics:
Section 21.1, "Understanding Advanced Cost Accounting Financial Reports"
Section 21.2, "Reviewing the Profitability by Cost Object Report"
Section 21.3, "Reviewing the Income Statement by Cost Object Report"
Section 21.4, "Reviewing the Trial Balance by Cost Object Report"
Section 21.5, "Reviewing the Trial Balance by Object Account for Cost Object Report"
This section discusses Advanced Cost Accounting financial reports, the comparison of profitability of multiple projects and lists prerequisites.
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).
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).
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.
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).
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).
Select Reporting menu (G1625), Profitability by Cost Object.
Processing options enable you to specify the default processing for programs and reports.
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.
1 = Suppress, Blank = Print
Cost Object 1
Cost Object 2
Cost Object 3
Cost Object 4
Item Number
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.
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).
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.
Select Reporting menu (G1625), Income Statement by Cost Object.
Processing options enable you to specify the default processing for programs and reports.
Specify the period number that the report should be based on. If left blank, the current financial reporting period will be used.
Specify the fiscal year that the report should be based on. If left blank, the current financial reporting year will be used.
Specify the lowest level of account level of detail to print on the report.
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.
Specify if net income should be calculated. Values are:
Blank: Do not calculate.
1: Calculate.
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.
Specify the date title type to print in the page header. If left blank, no date title will print.
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
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. |
Specify the cost object or item number to be used in the report.
Specify the view number to be used in the report. If a value of zero is entered, all valid view numbers will be used.
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).
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.
Select Reporting menu (G1625), Trial Balance by Cost Object.
Processing options enable you to specify the default processing for programs and reports.
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).
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).
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.
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. |
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.
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. |
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. |
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.
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.
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. |
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.
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
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 *.
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)
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.
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).
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.
Select Reporting menu (G1625), Trial Balance by Object Account for Cost Object.
Processing options enable you to specify the default processing for programs and reports.
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).
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).
Specify the model business unit for the system to use to retrieve account descriptions. Enter a valid model business unit.
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. |
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. |
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. |
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.
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.
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. |
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.
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
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 *.
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)
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.