1. Search “Physical Inventory Journal”
  2. Actions à Functions à Calculate Inventory
  3. Fill in the following:

Posting date, Document No, Item No, Location Code

    4. Click OK the system will bring how many pieces of that item there is in  that location

    5. There are 3 different ways to process Physical Inventory

 

1st case: Physical Inventory matches Calculated Inventory

In this case, if “Pieces (Calculated)” is 4, “Pieces (Phys Inventory)” will also be 4. Once Physical Inventory Journal Lines are posted, no inventory adjustments will be made

 

2nd case: Physical Inventory is less than Calculated Inventory

  • In this case, if “Pieces (Calculated)” is 45, and “Pieces (Phys Inventory)” is 44.
  • Go to Line à Item Tracking Lines
  • Process à Select Entries
  • Select the missing serial number then close the window


  • Once Physical Inventory Journal Lines are posted, the system will make a negative adjustment of 1 piece for that item in that location


Item Ledger Entries

3rd case: Physical Inventory is more than Calculated Inventory

  • In this case, if “Pieces (Calculated)” is 44, and “Pieces (Phys Inventory)” is 45.

  • Go to Line à Item Tracking Lines

  • Process à Create Customized SN

  • Enter the missing Serial Number

 Once Physical Inventory Journal Lines are posted, the system will make a positive adjustment of 1 piece for that item in that location

Item Ledger Entries