Review Cost Accounting Distributions

A single inventory transaction can generate multiple cost transactions, for which Cost Accounting creates accounting data.

In the Cost Accounting work area use the Review Cost Accounting Distributions page to see cost information and distributions related to each transaction, as well as receipt layers for receipt transactions, and depletion layers for issue transactions.

On the Review Cost Accounting Distributions page, you can search for transactions by entering your search criteria. The search parameters available differ based on the Search By option. The search by options available to define your search criteria are listed here:

• Classic Search: This is the default search by option and allows you to search for all transactions.

• Reference Number: Search for transactions based on a reference number such as purchase order, transfer order, sales order, work order, and transaction reference.

• Item Number: Search for transactions in a period for a particular item.

• Costing Status: Search for transactions based on their status. This search by option is particularly useful to identify transactions that haven’t been costed or are in the error status.

• Transaction Type: Search for transactions within a specified date range and further filter them by transaction type.

• Accounting Status: Search for transactions that aren't accounted or are in error status and resolve any reconciliation issues due to unaccounted transactions. All the accounting statuses are supported.

  • Error: Search for all transactions that are in error in a period.

  • Not Accounted: Search for all transactions that aren't accounted in a period.

  • Draft Accounted: Search for all draft accounted transactions in a period. For better performance, always restrict the transaction date range to a shorter duration.

  • Final Accounted: Search for all final accounted transactions in a period. For better performance, always restrict the transaction date range to a shorter duration.

  • Multiple: Search for transactions where distributions for all cost transaction layers are in different accounting statuses like error, final accounted, and so on.

  • Not Applicable: Search for transactions that aren't applicable for accounting. Examples include distribution amounts less than the minimum accountable unit (MAU) for the currency

  • Excluded from Accounting: Search for transactions that are excluded from accounting based on the cost profile setup. Examples include scrap transaction being included into inventory for a work order.

Note: When searching for transactions based on the costing status, using the fully costed status could result in almost all transactions for the specified period and duration and unlikely to be helpful.

When you perform a classic search, all the relevant transactions are listed in a table on the page. For each transaction all the relevant transaction details and costing details are listed. For more information about a transaction, you can select the transaction and click View Details. On the Details pop-up window, you can see the receipt layers or the issue layers depending on the transaction type. Also, all the cost information, cost distributions, transaction errors, and journal entries are listed on the respective tabs in the window.

For all other search by options, the search results are segregated across different tabs on the page.

• Cost Transactions: View inventory and inter-company physical and logical transactions.

• Cost Adjustments: View manual or automatic cost adjustments to receipt costs and inventory value.

• COGS Transactions: View COGS recognition transactions.

• Work Order Transactions: View resource, operation scrap, and work in process job close transactions.

A color-filled circle next to the tab name is shown indicating that the tab contains search results. Similar to the classic search, for each transaction all the relevant transaction details and costing details are listed. Also, for more information about a transaction, you can select the transaction and click View Details.

Run Cost Distribution Details Report

From the Review Cost Accounting Distributions page, you can run the Cost Distribution Details Report. This report can be generated for all the search by options, except classic search.

For the search criteria that you enter, the report provides a list of cost distributions and accounting information such as accounting line type, account, and accounted amount along with basic transaction information in a spreadsheet-friendly format.

You can also run this report from the Scheduled Processes work area.