Description:

An actual count of the goods owned by the company. The actual counts are then compared to the quantities reported on the detailed inventory records. If a difference exists, the quantity shown on the inventory record should be changed to the physical count.

Counting is used to verify the On-hand System 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 On-hand System 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 you will get one message like

Just click on, Yes.

Now you 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 you 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 (It’s 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 the original qty of 10 each.

You can also view from Inventory Material Transaction, search for the item.

This concludes Physical Counting.

Summary:

A physical count is an actual count of the goods in stock. This is a carefully coordinated counting process in which counting areas are segregated, and count teams examine assigned inventory areas, recording their counts on count sheets.

Queries?

Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.

Recent Posts

Start typing and press Enter to search