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.

Note: When searching for transactions based on the 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 option, the search results are segregated across the Cost Transactions, Cost Adjustments, COGS Transactions, and Work Order Transaction tabs on the page. 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.