This topic describes the available costing reports. Reports are available through the Application's Standard Report Submission window.
This chapter covers the following topics:
Use the Item Cost Detail Report to view the cost of an item in each of the inventory organizations in which it is stored. The costs shown are based on the cost calendar, period, and cost method selected. The report can be printed by inventory organization, item and item class.
Navigate to the Submit Request window.
Enter the Legal Entity for which you want to run the report.
Enter the cost Calendar Code for which you want to item costs
Enter the cost calendar Period for which you want to item costs.
Enter the Cost Type for which you want to item costs.
To report item costs for a range of inventory organizations, enter the first inventory organization of the range in From Organization.
To report item costs for a range of inventory organizations, enter the last inventory organization of the range in To Organization.
To report item costs for a range of items, enter the first item of the range in From Item.
To report item costs for a range of items, enter the last item of the range in To Item.
To report item costs for a range of cost categories, enter the first cost category in the range in From Cost Category.
To report item costs for a range of cost categories, enter the last cost category in the range in To Item Cost Category.
Enter the currency in which the report is generated in Report Currency.
Enter the exchange rate for the currency in Exchange Rate.
The Costed Indented Bill of Materials Report is a listing of all the products, co-products, by-products, intermediates, and raw materials that are used in the production of a specific product in terms of Standard Cost break-up. The report enables you to drill-down on costs to ingredient levels for better sourcing decisions. You can request this report from the Item Cost Details and the Standard Cost Roll up window. The report does not provide information for Actual Costing or Lot Costing Cost Types.
To run the Costed Indented Bill of Materials report
Navigate to the Submit Request window.
Enter Costed Indented Bill of Materials in the name field.
Enter the Legal Entity for which the report is to be generated. Required.
Enter the Cost Calendar to consider to generate the report. Required.
Enter the Period in the Cost calendar for which you want to generate the report. Required.
Select the Cost Type. Options are Standard, Actual, and Lot Costing. Required.
Enter any of the following fields to narrow the scope of the report:
From Organization and To Organization to generate the report for a range of organizations.
From Item and To Item to generate the report for a range of items.
From Cost Class and To Cost Class to generate the report for a range of cost classes.
Enter Maximum BOM Level as the maximum number of BOM levels to include in the report. The default value is 10. You can update this field. Required.
Enter Number of Indentation Character as the number of indentation characters to include in the report. The default value is 2. You can update this field. Required.
Select the Report Type to specify the detail level you want on the report. Options are:
All to display Summary, Cost component, and BOM Item level details
BOM Summary Only to display summary data for Material, Resource, Fixed Overhead, and Standard Cost Adjustment usage categories, for a product at each level of BOM
BOM Item Details to display Summary and BOM Item level details. The BOM Item Details breakup displays for a combination of Item, Cost Component, and Analysis Code.
Cost Component Details to display Summary and Cost Component level details. The Cost Component Details breakup displays for a combination of cost component , analysis Code, and Item.
Indicate how the report is to be sorted in the Sort By field. Options are:
Item
Organization
Click OK, then Submit.
ReportThe Actual Cost Adjustments Report reflects actual cost adjustments made for a specific cost calendar and period. You can print cost adjustment information for all items in all inventory organizations, or restrict the report to one or more items in one or more specific inventory organizations.
Navigate to the Submit Request window.
Enter Legal Entity for which you are adjusting the cost.
Enter the cost calendar for which you are printing actual cost adjustments in the Calendar Code field.
Enter the cost Period Code within the cost calendar for which you are printing actual cost adjustments.
Enter the Cost Type for the type of actual costing adjustments that will be included in the report.
To report actual cost adjustments for a range of inventory organizations, enter the first inventory organization of the range in From Organization.
To report actual cost adjustments for a range of inventory organizations, enter the last inventory organization of the range in To Organization.
To report actual cost adjustments for a range of items, enter the first item of the range in From Item.
To report actual cost adjustments for a range of items, enter the last item of the range in To Item.
ReportThe GL Expense Allocation Definition Report lists the definitions of the accrued general ledger expenses to be allocated to specified items. You can list definitions for all general ledger expense allocation codes, or restrict the report to only desired ones.
Navigate to the Submit Request window.
EnterLegal Entity for which you are listing General Ledger cost allocation account definitions.
To report on a range of allocation codes, enter the first allocation code in the range in From Allocation code.
To report on a range of account codes, enter the last allocation code in the range in To Allocation Code.
The GL Expense Allocation Detail Report is a detailed list of all of the expense costs that were allocated to item components from the indirect expense accruals. You can list allocation detail for all expense allocation codes, or restrict the report to allocations for only desired ones.
Navigate to the Submit Request window.
EnterLegal Entity for which you are listing general ledger cost allocation details.
EnterCost Calendar to which expenses will be allocated to the mapped accounts.
Entercost calendar Period Code to which expenses will be allocated to the mapped accounts. This must be an open period.
To report on a range of expense allocations, enter the first allocation code of the range in From Allocation code .
To report on a range of expense allocations, enter the last allocation code of the range in To Allocation Code.
The Cost Organization Association Report lists the cost organizations associated with the inventory organizations, or inventory organizations associated with cost organizations.
Navigate to the Submit Request window.
To report associations for a range of cost organizations, enter the first cost organization of the range in the From Cost Organization field.
To report associations for a range of cost organizations, enter the last cost organization of the range in the To Cost Organization field.
To report associations for a range of inventory organizations, enter the first inventory organization of the range in the From Inventory Organization field.
To report associations for a range of inventory organizations, enter the last inventory organization of the range in the To Inventory Organization field.
If you want to list cost organizations associated with each specific inventory organization, choose cost organizations in the Sort By fields. To list inventory organizations associated with a specific cost organization, select the inventory organization option.
The GL Item Cost Detail Report lists the cost updates generated by the cost update process. Use this report to verify the updated cost and make corrections before executing the subsidiary ledger process. You can restrict the report to one or more items or inventory organizations, and select from four report types:
GL Item Cost Detail
GL Item Cost Summary
Zero/Negative Item Cost Detail
Zero/Negative Item Cost Summary
Navigate to the Submit Request window.
Enter the Calendar Code for which the report is to be generated in the field.
Enter the Priod for which this report is to be generated in the Period field. The period defined can be for an open, frozen, or closed period.
The Cost Method defined by the calendar displays. However, the default can be changed.
To report for a range, enter the first item class of the range in From Item Class.
To report for a range, enter the last item class of the range in To Item Class.
To report for a range of items, enter the first item of the range in From Item.
To report for a range of items, enter the last item of the range in To Item.
To report for a range, enter the first inventory organization of the range in From Whse.
To report for a range, enter the last inventory organization of the range in To Whse.
Indicate the Report Type to be printed in the field. There are four options:
GL Item Cost Detail
GL Item Cost Summary
Zero/Negative Item Cost Detail
Zero/Negative Item Cost Summary
Indicate whether the report should be generated by either an item or inventory organization in Sort By.
The Inventory Valuation report provides a tool to evaluate the cost of items in inventory by organization. This report lists the true value of inventory items for a specified period of time, in specified organizations. The costs listed are the accounting costs for the item in the organization, if available. Otherwise, the cost of the item for the legal entity is used. The inventory valuation can be based on balances available at report printing time, or the closing balance for the end of a specified calendar period.
The report is listed by item within organization. This includes item onhand balances for both primary and secondary units of measure, unit cost and total cost (value). You can print the report for one or more organization or items.
Navigate to the Submit Requests window.
Enter the Legal Entity for which you are listing general ledger cost allocation detailsd.
Enter the beginning organization for the report in From Organization.
Enter the ending organization for the report in To Organization.
Enter the beginning item for the report in From Item.
Enter the ending item for the report in To Item.
To show current inventory valuation balances (that is, inventory valuation at report printing time), select Yes in Current Balance. Otherwise, select No and complete the Fiscal Year and Period to show inventory valuation as of a particular calendar and period closing date.
To show inventory valuation as of a particular fiscal calendar year enter the cost calendar code in Fiscal Year.
To show inventory valuation as of a particular period closing date, enter the period code for the cost calendar year in Period Number.
If the report is to be run for a currency other than the legal entity's base currency enter it in Report Currency . The report uses the legal entity's base currency by default.
If an alternate currency is entered above, then specify the exchange rate in Exchange Rate. The report uses a default value of 1.0.
You must complete inventory month-end processing in order for this report to reflect accurate month-end balances.
The Batch Yield Variance Report is available through OPM Process Execution. Please refer to Oracle Process Manufacturing Process Execution User's Guide for details.
The Material Usage and Substitution Variance Report is available through OPM Process Execution. Please refer to Oracle Process Manufacturing Process Execution User's Guide for details.
The OPM Lot Cost Detail Report lists costs generated by the lot cost process. You can verify the calculated costs.
Run the Lot Cost Process.
Navigate to the OPM Lot Cost Detail Report window.
Enter the Legal Entity for which the report is to be generated.
Select the appropriate Cost Type.
To report for a range of inventory organizations, enter the first inventory organization in the range in From Organization.
To report for a range of inventory organizations, enter the last inventory organization in the range in To Organization.
To report for a range of items, enter the first item in the range in From Item.
To report for a range of items, enter the last item in the range in To Item.
To report for a range of lots, enter the first lot in the range in From Lot.
To report for a range of lots, enter the last lot in the range in To Lot.
To report for a range of item cost category, enter the first item category in the range in From Item Cost Category.
To report for a range of item cost category, enter the last item category in the range in To Item Cost Category.
If the report is to be run for a currency other than the legal entity's base currency enter it in Currency. The report uses the legal entity's base currency by default.
If an alternate currency is entered above, then specify the exchange rate in Exchange Rate. The report uses a default value of 1.0.
Click Ok.
The OPM Lot Cost History Report displays the lot history to analyze how the costs are calculated. A history of item and lot is maintained for costing purposes. This history detail includes all the receipts of a lot into inventory, all consumptions of the lot, and adjustments.
Run the Lot Cost Process.
Navigate to the OPM Lot Cost History Report window.
Enter the Legal Entity for which the report is to be generated.
Select the appropriate Cost Type.
To report for a range of inventory organizations, enter the first inventory organization in the range in From Organization.
To report for a range of inventory organizations, enter the last inventory organization in the range in To Organization .
To report for a range of items, enter the first item in the range in From Item.
To report for a range of items, enter the last item in the range in To Item.
To report for a range of lots, enter the first lot in the range in From Lot.
To report for a range of lots, enter the last lot in the range in To Lot.
To report for a range of item cost category, enter the first item category in the range in From Item Cost Category.
To report for a range of item cost category, enter the last item category in the range in To Item Cost Category.
To report for a range of dates, enter the first date in the range in From Date.
To report for a range of dates, enter the last date in the range in To Date.
If the report is run for a currency other than the legal entity's base currency, then enter it in Currency. The report uses the legal entity's base currency by default.
If an alternate currency is entered above, then enter the exchange rate in Exchange Rate.
Click Ok.
The Detailed Subledger report is run to print accounting transactions and event classes for an organization as specified in the parameters. You must run the OPM Accounting Pre-Processor for an organization and use the reference number generated to run the Detailed Subledger report.
Prerequisites
To submit the Detailed Subledger report
Navigate to the Submit Request window.
Enter Detailed Subledger Report in the Name field.
Enter any of the following fields to narrow the scope of the report:
Reference No. that is generated after running the OPM Accounting Pre-Processor.
Note: If you enter the Reference No, then the Ledger, Cost Type, Fiscal Year, Period, Start Date, and End Date values default from the associated run of the OPM Accounting Pre-Processor.
Legal Entity for which the report is to be generated.
Ledger for which the report is to be generated.
Cost Type for which the report is to be generated.
Fiscal Year for which the report is to be generated.
Period for which the report is to be generated.
Organization Code of the organization for which the report is to be generated.
Enter the Start Date and the End Date to run the report for a specific range of dates.
Optionally, enter the Entity Code for which you want to run the report. This is an optional field. Valid values are:
Inventory Transactions
Order Management
Process Execution
Purchasing Transactions
Inventory Revaluation
For example, if you select Process Execution, then the report shows accounting entries for transactions in OPM Process Execution only.
Optionally, enter the Event Class for which you want to run the report. This is an optional field. The list of values displays only those event classes that belong to the entity code you specify. For example, if you select Process Execution as the entity code then the following event classes display in the list of values:
Batch Close Variance
Batch Material Transactions
Batch Resource Transactions
Optionally, enter the Event Type for which you want to run the report. The list of values displays only those event types that belong to the event class you specify.
Select Include Zero Amt. Lines as Yes if you want the report to include transactions with zero values also.
Click OK.
Click Submit.