Previous  Next          Contents  Index  Glossary  Library

Taking a Snapshot of Inventory Quantities

Before you can generate tags for a physical inventory, you must take a snapshot of all system on-hand quantities for your items. The snapshot saves all current item on-hand quantities and costs. Oracle Inventory uses this information as the basis for all physical inventory adjustments. All tag counts you enter for this physical inventory are compared with these static quantities. This allows you to resume normal inventory operations after you have entered your counts but before you have authorized all final physical inventory adjustments. You can perform your recounts or investigate certain results without holding up transaction processing.

For example, suppose that at the start of your physical inventory the system on-hand quantity for item WIDGET in a particular bin is 30. Oracle Inventory saves this information with the physical inventory snapshot. During the warehouse count, you count a total of 25 units of item WIDGET in the same bin. Before you approve your counts and perform your adjustments, you resume normal transaction operations, and consequently, item WIDGET reaches a system on-hand quantity of 45. At this point, you perform your physical inventory adjustments. Oracle Inventory computes the adjustment as the difference between the tag count and the snapshot quantity, NOT the current system quantity of the item that has now reached 45. So in this case, the adjustment is 25 - 30 = -5 units. When the adjustment is posted, the new system on-hand quantity becomes 40 units.

   To freeze the system on-hand quantities:

See Also

Overview of Physical Inventory

Generating Physical Inventory Tags


         Previous  Next          Contents  Index  Glossary  Library