Transaction Register (Oracle Inventory Help)


	Previous	Next		Contents	Index	Glossary	Library

Transaction Register

Use the Transaction Register:

as an audit report

to review the transaction date versus the exact date an item was transacted

to review the reason an item was moved into a subinventory by running the report for reason only and limiting the from and to subinventory

to check the value of inventory

to report the categories of items that have shipped and the total unit cost for the category

for tracing serial numbers by location

If you run this report without any detail and for a date range, you can use it as a batch transaction report.

Attention: This register should not be used to reconcile your inventory transactions or balances to your general ledger. This report displays a transaction value for all transactions including receipts of expense items into asset subinventories. These transactions are not part of your inventory balances. In addition, this report does not show valuation charges, such as the average or standard cost update.

Report Submission

Use the Transaction Reports or Submit Requests window and enter Transaction register in the Name field to submit the report.

Report Parameters

Sort By

Choose to sort the report by one of the following options:

Item

Transaction Date

Transaction Type

Source Type

Reason

Subinventory

Category

Unit of Measure

Choose to report in either the Primary or Transaction unit of measure

Transaction Dates From

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

To

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

Audit Detail

Enter Yes or No to indicate whether to print audit detail.

Reason Detail

Enter Yes or No to indicate whether to print reason detail.

Location Detail

Enter Yes or No to indicate whether to print location detail.

Category Detail

Enter Yes or No to indicate whether to print category detail.

Serial Number Detail

Enter Yes or No to indicate whether to print serial number detail.

Lot Number Detail

Enter Yes or No to indicate whether to print lot number detail.

Items From

Enter a 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.

Transaction Types From

Enter a beginning transaction type to restrict the report to a range of transaction types.

To

Enter an ending transaction type to restrict the report to a range of transaction types.

Transaction Reasons From

Enter a beginning transaction reason to restrict the report to a range of transaction reasons.

To

Enter an ending transaction reason to restrict the report to a range of transaction reasons.

Subinventories From

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

Subinventory To

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

Category Set

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

Categories From

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

To

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

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 a beginning source to restrict the report to a range of sources.

To

Enter an ending source to restrict the report to a range of sources.

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.