Valued
Transaction Register by Warehouse Report
The warehouse manager can
use the Valued Transaction Register by Warehouse (CRVTRW) report
to analyze all transactions processed in his or her warehouse each day.
Using the Valued Transaction Register by Warehouse (CRVTRW) report,
the inventory accountant can also review the general ledger entries generated
by each transaction.
The following types of transactions
are displayed on the Valued Transaction Register by Warehouse (CRVTRW)
report:
-
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 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: an update
to an items asset distribution via the Item Account Change (IAC) screen
or Group Account Update (GAU) screen
-
Whse GA Chg: an update
of a warehouses 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 items general ledger distribution
are displayed on the Valued Transaction Register by Warehouse (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
All of the transactions listed
on the report for February 28, 1997, are direct issue transactions. The
third transaction displayed on the report shows that 790 corrugated cartons,
item 0005587, were issued directly to a customer from warehouse 428315R.
The general ledger distribution for the group account entry and the value
of the transaction are also displayed on the report. Accounting rules have
not been applied to the GL distributions; in other words, these transactions
are displayed prior to posting.
The Valued Transaction
Register by Warehouse (CRVTRW) report is available in RMDS after nightly
production each day. The report should be reviewed daily. The Valued
Transaction Register by Warehouse (CRVTRW) report is located in RMDS
in the report group IN261-1.