Physical Inventory
created By: Omar Magdey
Supply Chain Module
Physical inventory
Use physical inventories to reconcile system-maintained
item on-hand balances with actual counts of inventory.
Accurate system on-hand quantities are essential for
managing supply and demand, maintaining high service
levels, and planning production.
You can perform these physical inventory tasks :
01 Define a physical inventory
02 Generate a physical inventory snapshot
03 Generate physical inventory tags
04 Record physical inventory tags
05 Approve physical inventory tags
Post physical inventory adjustments
06
01- Define a physical inventory
1- 2-
3-
02- Generate a physical inventory snapshot
• It means taking a snapshot of the current inventory quantity
on the system.
03- Generate physical inventory tags
• You generate and print physical inventory
tags for counting inventory items.
• Physical inventory tags represent actual
paper tags that some companies use to
count inventory items. A tag contains the
count for a group of a given item.
Print Physical Inventory Tags
To generate and print physical inventory tags
04- Record physical inventory tags
• You use physical inventory tags to record the physical
counts of inventory items. Although you can record only
one item on a tag, multiple tags can reference the same
item, with each tag referring to a unique physical
location for an item.
• To record tags, you can create a single dynamic tag for a
physical inventory to enter counts for any item without a
pre-generated tag number. You can also create dynamic
tags for unexpected item count entries, and default
tags, blank tags, or both for counting miscellaneous
items.
Physical count done on the ground
05-Approve physical inventory tags
• The system's position is determined by the difference
between the physical quantity and the quantity
defined on the system when creating the physical
inventory through:
- The adjustments are determined by the approval option you define for your physical
inventory. If you approve an adjustment, Oracle Inventory Management adjusts your inventory
balance by that quantity. If you reject an adjustment, Inventory Management doesn't change
the on-hand quantity.
- Physical inventory adjustments don't occur until they're posted.
06- Post physical inventory adjustments
• When you post physical inventory adjustments, Oracle
Inventory Management creates a material transaction,
adjusting the item quantity and debiting or crediting the
adjustment account that the user specifies for the physical
inventory.
• If the count of an item matches the snapshot on-hand quantity,
no adjustment transaction is posted.
• After inventory adjustments are posted, users can't make any
changes to the physical inventory. They can't generate new
tags or update tag counts.