Material Account Distribution Detail (Oracle Inventory Help)


	Previous	Next		Contents	Index	Glossary	Library

Material Account Distribution Detail

Use the Material Account Distribution Detail Report to view the accounts charged for inventory transactions. You can review inventory transaction values transferred to the general ledger by GL batch. This feature helps you reconcile your inventory accounting to your general ledger. See: Period Close.

Report Submission

Use the Transaction Reports, Cost and Period Close Reports, or Submit Requests window and enter Material account distribution detail in the Name field to submit the report.

Report Parameters

Sort By

Choose one of the following options:

Account Sort the report by general ledger account.

Account, Item Sort the report by general ledger account and then by item.

Item, Account Sort the report by item and then by general ledger account.

Account, Subinventory Sort the report by general ledger account and then by subinventory.

Subinventory, Account Sort the report by item, then by subinventory, and then by general ledger account.

Transaction Type Option

Display Transaction Source Type	Display the transaction source type name.
Display Transaction Type	Display the transaction type name.

Transaction Dates From

Enter a beginning required transaction date to restrict the report to a range of transaction dates.

To

Enter an ending required transaction date to restrict the report to a range of transaction dates.

Accounts From

Enter the beginning account to restrict the report to a range of accounts.

To

Enter the ending account to restrict the report to a range of accounts.

Category Set

Enter a category set. The report shows transactions associated with this category set.

Categories From

Enter the beginning category to restrict the report to a range of categories in the selected category set.

To

Enter an ending category to restrict the report to a range of categories in the selected category set.

Items From

Enter the beginning item to restrict the report to a range of items.

To

Enter an ending item to restrict the report to a range of items.

Subinventories From

Enter the beginning subinventory to restrict the report to a range of subinventories.

To

Enter an ending subinventory to restrict the report to a range of subinventories.

Transaction Values From

Enter a beginning transaction value to restrict the report to a range of transaction values.

Note: When you use this option, the report evaluates the transaction amounts in absolute value. Therefore, if you enter a from value of 100, the report selects all transactions with positive (debit) or negative (credit) values greater than or equal to 100.

To

Enter the ending transaction value to restrict the report to a range of transaction values.

Note: When you use this option, the report evaluates the transaction amounts in absolute value. Therefore, if you enter a to value of 100,000, the report selects all transactions with positive (debit) or negative (credit) values less than or equal to 100,000.

GL Batch

Enter a general ledger batch number.

Transaction Source Type

Choose one of the following options. In addition to the predefined source types listed below, you may have additional user-defined source types.

Account Report general ledger account transactions.

Account alias Report account alias transactions.

Cycle Count Report cycle count transactions.

Internal order Report internal order transactions.

Internal Requisition Report internal requisition transactions.

Inventory Report inventory transactions.

Job or Schedule Report job or repetitive schedule transactions.

Physical Inventory Report physical inventory transactions.

Purchase order Report purchase order transactions.

RMA Report return material authorization transactions.

Sales order Report sales order transactions.

Standard cost update Report standard cost update transactions.

Sources From

Enter the beginning source value to restrict the report to a range of source values for the transaction source type you specified.

To

Enter the ending source value to restrict the report to a range of source values for the transaction source type you specified.

Transaction Type

If you entered a transaction source type, you can enter a transaction type. The report shows only transactions associated with this transaction type. If you do not enter a value in this field, the report prints transactions for all transaction types.

Transaction Reason

Enter a transaction reason. The report shows only transactions associated with this transaction reason. If you do not enter a value in the field, the report prints transactions for all transaction reasons.

Currency

Select a currency. You can run this report for any defined currency, but your functional currency is the default. If you select another currency, item costs are converted to the selected currency using the End of Period rate you select in the Exchange Rate field.

Exchange Rate

Select an exchange rate. If you do not select your functional currency, the default is the most recent End of Period rate. However, you can select any prior End of Period rate.

Account	Sort the report by general ledger account.
Account, Item	Sort the report by general ledger account and then by item.
Item, Account	Sort the report by item and then by general ledger account.
Account, Subinventory	Sort the report by general ledger account and then by subinventory.
Subinventory, Account	Sort the report by item, then by subinventory, and then by general ledger account.

Account	Report general ledger account transactions.
Account alias	Report account alias transactions.
Cycle Count	Report cycle count transactions.
Internal order	Report internal order transactions.
Internal Requisition	Report internal requisition transactions.
Inventory	Report inventory transactions.
Job or Schedule	Report job or repetitive schedule transactions.
Physical Inventory	Report physical inventory transactions.
Purchase order	Report purchase order transactions.
RMA	Report return material authorization transactions.
Sales order	Report sales order transactions.
Standard cost update	Report standard cost update transactions.