Monthly Transaction Register

The warehouse manager can use the Monthly Transaction Register (CRVTRW) report to analyze the transactions processed in the Inventory module. Using this report, the warehouse manager can review the general ledger entries generated by each transaction.

The Monthly Transaction Register (CRVTRW) report is similar to the Valued Transaction Register by Warehouse (CRVTRW) report. Although the Valued Transaction Register by Warehouse (CRVTRW) report only displays the transactions for a single day, the Monthly Transaction Register (CRVTRW) report displays all of the transactions from the preceding month.

The Monthly Transaction Register (CRVTRW) report is organized by warehouse. Each active item in the warehouse is listed on the report. The following information is displayed for each transaction on the report:

• Item number and description
• Date and time of transaction
• Quantity of the item
• Order number
• Average cost of the item

• Receipt: the receipt of a replenishment or purchase order
• Receipt Rev: the return or receipt reversal of a replenishment or purchase order
• Movement: the movement of inventory from one warehouse location to another via the Move Inventory (MI) screen or the Direct Transfer (DT) screen
• Order Ship: the issuing of inventory against a usage order
• Order Return: the return of inventory against a usage order
• Issue: the direct issue of inventory via the Direct Issue (DI) screen in the Inventory module
• Return: the direct return of inventory via the Direct Return (DR) screen in the Inventory module
• Adjustment -: an inventory reduction as a result of posting cycle count results or a direct adjustment via the Deduct Inventory Adjustments (DIAU) screen
• Adjustment +: the positive adjustment of inventory levels resulting from the posting of cycle count results or a direct adjustment via the Add Inventory Adjustments (AIAU) screen
• Average Cost Chg: the manual adjustment of the average cost of an item/warehouse combination via the Average Cost Change (ACC) screen
• Item GA Chg: the update to an item’s asset distribution via the Item Account Change (IAC) or Group Account Update (GAU) screen
• Whse GA Chg: the update of a warehouse’s distribution via the Warehouse Account Change (WAC) screen
• UO Replnsh: an internal replenishment order

The unit cost at which the item is valued in the general ledger and the item’s general ledger distribution are displayed on the Monthly Transaction Register (CRVTRW) report. In addition, the following information can be displayed in the ORDER field on the report:

• The usage order number for usage order and internal replenishment transactions
• The purchase order number for receipt transactions
• The reference number associated with an item movement, direct issue, or direct return

The warehouse manager can review the Monthly Transaction Register (CRVTRW) whenever it is necessary. It is located in RMDS in the report group IN275-1.