PHYSICAL COUNTING IN ORACLE EBS R12.2
Counting is used to verify the System On hand Quantity with Actual (Physical Qty) Quantity of the item and perform the adjustments in System OHQ.
These are two types of counting.
-
Physical Counting
-
Cycle Counting
Physical Counting:
It is used to verify the System On-hand Quantity and Actual Quantity of the item based on Sub inventory or Organization and perform the adjustments.
Normally we will perform this counting yearly once or twice. During Physical Counting, the Total Inventory will freeze and can’t do any Transactions.
Step 1: Define the item through get on-hand quantity
Here we are defining three items like
IPHONE 4S, IPHONE 5S, IPHONE 6S
Step 2: Define Sub inventories
We are creating a sub inventories like SKV
Step 3: Items should have on-hand quantity
Through miscellaneous receipt we can get the on-hand quantity.
Like
IPHONE 4S =100, IPHONE 5S =100, IPHONE 6S =100.
Step 4: Define Physical Inventory
Navigation: Inventory ? Counting ? Physical Inventory ? Physical Inventories
Click on New, the below dialog box appears.
You add the Tolerance and Qty of your choice.
Click on Snapshot, system automatically generate concurrent program.
Step 5: Generate Physical Inventory Tags
Navigation: Counting ? Physical Inventory ? Tag Generation
Click on Generate.
Now the system will run “Generate physical inventory tags” concurrent program.
Step 6: Run “Physical Inventory Tag Listing” Report
Navigation: View ? Request ? Submit New Request ? Single Request
Output of the report:
Step 7: Enter Physical(Actual) Quantity of the Item/Physical Inventory Tag counts
Navigation: Inventory ? Counting ? Physical Inventory ? Tag Counts
Select the Physical Inventory Name and then Click on Find
Now u will get one message like
Just click on Yes.
Now u will get below window
In the above you enter the quantity as 10 for all three Items, IPHONE 4S, 5S, 6S.
Step 8: Approve the Adjustments
Navigation: Inventory ? Counting ? Physical Counting ? Approve Adjustments
Click on Find and Click on Yes, now you will get below window
Then u can select the Approve radio button against these 3 items and mention the approver.
Step 9: Performing the adjustments
Go to Physical inventory definition form query with our physical inventory
Navigation: Inventory ? Counting ? Physical Inventory ? Physical Inventories
Click on “Launch Adjustments“
Now you will get below window
Click on “Launch Adjustments”
Now system automatically generate concurrent program.
Select View ?Request (Its Normal Below)
Step 10: Check out the On-hand quantity
Now go to inventory and select the on hand quantities for these 3 items as below.
Before we had 100 qty for each item after completing the physical counting we will get original qty of 10 each.
You can also view from Inventory ?Material Transaction, search for the item
This concludes Physical Counting.
Recommended Posts
