Total Pageviews

June 26, 2016

6/26/2016 01:12:00 AM
Oracle Inventory

Inactive Items Report

Use the Inactive Items Report to print items that have not had an inventory transaction since the date you specify. You can use this report to isolate items that have become inactive and verify their status.

Item Reservations Report 

Use the Item Reservations Report to determine how many units of an item are reserved for an account, an account alias, or for user–defined source types.

Lot Transaction Register

Use the Lot Transaction Register for lot transaction audits. You can use this report to audit lot transactions for a specified time interval, for a range of dates, for ranges of items or categories, of for other criteria. You can use the report to analyze the cost and value of transacted items under lot control. You can also use this report to cross–reference lot numbers to serial numbers.

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.

Move Order Pick Slip Report
Use the Move Order Pick Slip Report to print move order pick slips. You can run this report before or after the move order transaction is committed.

Material Account Distribution Summary
Use the Material Account Distribution Summary report to review your inventory accounting activity. If you detect unusual accounts or amounts, use the Material Account Distribution Detail report to print the transaction in detail. You can also use the Material Account Distribution Summary Report to verify your inventory account activity against your inventory valuation increases or decreases for the accounting period. Finally, you can use this report to reconcile an account across several periods.

Serial Number Transaction Register

Use the Serial Number Transaction Register for serial number transaction audits. You can use this report to audit serial number transactions for a specified time interval, location or group of locations, reason or group of reasons, or other criteria. For example if your user–defined reason codes include Fail or Rework, you can use this report to isolate the serial numbers for these reason codes. You can use this report as a balancing report to determine if both the receipt and issue of a serial number have occurred. You can also use this report to determine the monetary value of serial numbered items in inventory or of items under serial number control that have been shipped.

Transaction Historical Summary Report

Use the Transaction Historical Summary Report to report past item quantities, past item value, or past inventory balances. The report calculates historical balances based on a rollback date. You can use the Balance and Value version of the report totals to determine the gross change in monetary value of a subinventory or inventory for a period of time. You can also use this report to measure the volume of throughput in the inventory.