You are browsing the archive for physical inventory tag.

by oracleguru

8.5 Approve Physical Inventory Tag Counts

ORACLE APPS COMMUNITY > Tutorial > physical inventory tag

 

  • Form Application: Inventory
  • Form Name: INVADPAP
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVADPAP.fmx

Physical Inventory process helps in matching system on-hand with actual physical on-hand. During physical inventory, first inventory snapshot is taken then tags are generated. Actual on-hand quantity physically found is captured on tag. System determines based on physical inventory setup if any of the variance (system qty/value – actual qty/value) requires ‘APPROVAL’ or not. All approval needed must be approved/rejected. Once approved, inventory on-hand will be adjusted to match with actual count quantity.

Navigation: Inventory responsibility -> Counting -> Physical Inventory -> Approve Adjustments

  • Select the ‘Name’ of Physical Inventory
  • Click ‘Find’
  • Check ‘YES’ to query out of tolerance adjustment  tags only

Output shows all tags that are out of tolerance and requires approval. This screen show the system quantity, actual quantity and variance quantity. Select any of the tag and check ‘Approve’ or ‘Reject’ or ‘None’ radio button.

Save the tag count approval. Once tag variances are approved next step is to adjusting the approvals. Approvals doesn’t automatically approve the on-hand inventory in Oracle, next step of Adjusting must be done.

Adjust Approved Physical Inventory Counts

Adjust Approved Physical Inventory Counts

 

 

 

 

 

 

 

 

Tags: , , , , , No Comments »

by oracleguru

8.4 Enter Physical Inventory Tag Count

ORACLE APPS COMMUNITY > Tutorial > physical inventory tag

 

  • Form Application: Inventory
  • Form Name: INVADPTE
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVADPTE.fmx

Physical Inventory process helps in matching system on-hand with actual physical on-hand. During physical inventory, first inventory snapshot is taken then tags are generated. Once tags are generated, actual on-hand quantity physically found is captured on tag.

Navigation: Inventory responsibility -> Counting -> Physical Inventory -> Tag counts

  • Select the ‘Name’ of Physical Inventory
  • Click ‘Find’
  • Check ‘YES’ to query all existing tags

Output shows all tags generated. Select the tag for which on-hand quantity will be entered.

  • Enter the count quantity in ‘quantity’ field.

Save the tag count entered. Now you have actual count entered and system on-hand on tag. Based on Physical Inventory setup, oracle decided if there is a variance if it requires approval. Next step in physical inventory process is APPROVE / REJECT.

Enter Physical Inventory Tag Counts

Enter Physical Inventory Tag Counts

 

 

 

 

 

 

 

Tags: , , , , No Comments »

by oracleguru

8.3 Physical Inventory Tag Generation

ORACLE APPS COMMUNITY > Tutorial > physical inventory tag

  • Form Application: Inventory
  • Form Name: INVARPGT
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVARPGT.fmx
  • Request Application: Inventory
  • Request Code:INCAPT
  • Request Name: Generate Physical Inventory Tags

Physical Inventory (PI) is a process in which actual on-hand quantity counted and adjusted with system (Oracle apps ERP) on-hand quantity. Typically this is performed every year, but some businesses may decide to do more often. During Physical Inventory all inventory transactions are locked-up, no inventory movements are performed. Once Physical Inventory parameters are setup, and inventory snapshot is taken next step is to generate TAGs. Tags are printed documents that prints the snapshot information. Each record of snapshot is printed on a separate tag. Tag will have Item, Location etc information. The person who does PI counting use the tag to capture the information of actual on-hand.

Navigation: Inventory responsibility -> Counting -> Physical Inventory -> Tag Generation

  • Select the existing Physical Inventory (PI) name
  • Select the ‘Tag Type’ – Default tags or Blank tags
  • Check if ‘Serial Number’ information to be printed on ‘Tag’
  • Enter ‘Starting Tag’ number
  • Enter ‘Digit Increments’ for each tag
  • Ending tag and number of tags are defaulted based on snapshot.
  • Click on ‘Generate’
  • Concurrent program ‘Generate Physical Inventory Tags’  is submitted

Navigate to view requests. Wait until concurrent request is completed before proceeding with next steps.

Physical Inventory Tag Generation

Physical Inventory Tag Generation

 

 

 

 

 

 

 

 

Tags: , , , , , , No Comments »