SAP Knowledge Base Article - Public

3073757 - Unit code cannot be selected in Physical Inventory Tasks excel

Symptom

You find some unit codes cannot be selected in Physical Inventory Tasks excel, while the UoMs are released and can be used in the system.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Physical Inventory work center.
  2. Go to Task Control view.
  3. Select task ABC. (ABC represents the task ID)
  4. Click on Confirm with Microsoft Excel button.
  5. System will automatically download the Physical Inventory Task excel. 
  6. You try to select unit code DEF in the drop-down list, however it is not available there. (DEF represents the unit code)

Cause

The drop-down list in the excel is based on the standard units of measure.

Resolution

This list in the excel can be enhanced by unhiding the 'Validation' sheet on the excel.

In the validation sheet the new UoMs can be added to the static code list for the Counted Quantity UoM.

Keywords

Unit code, UoM, Physical Inventory Tasks, Confirm with Microsoft Excel, Physical Inventory, Excel , KBA , AP-PIP , Physical Inventory Processing , Problem

Product

SAP Business ByDesign all versions