3531111 - Custom Unit of Measure is not Available in Supplier Invoice Excel Template

When accessing the Supplier Invoice Excel template, the custom Unit of Measure (UoM) is not available in the drop-down in column 'Unit'. 

SAP Business ByDesign

1. Go to Supplier Invoicing work center.
2. Go to Invoice Entry view. 
3. Click in New button and select Import from Microsoft Excel. 
4. Open the downloaded Excel template. 

The custom UoM ABC is not available (ABC is the custom UoM). 

The custom unit of measure doesn't appear in the standard Supplier Invoice Excel template by default. So, it has to be manually added. 

Steps to add the unit of measure in the Supplier Invoice Excel template:

1. Open the Excel Template. 
2. Navigate to Home. 
3. In Cells section, click in Format. 
4. In Visibility, go to 'Hide & Unhide' and select 'Unhide Sheet'.
5. Select Validation.
6. Click in OK.
7. Here maintains the ABC unit of measure following the same rule of the other already maintained units. 
8. Save it.
9. The UoM should be available in the 'Data' sheet.

For better understanding of the Excel, please check Microsoft material "Hide or Unhide worksheets". 

• Microsoft Support: Hide or Unhide worksheets
• KBA: 1675834 - How to Add a New Unit of Measure for Quantities

KBA , SRD-SRM-SI , Supplier Invoicing , How To