Symptom
You enter zero as leading numbers in the field External Reference in Sales Order or in the field External document ID in supplier invoice, and then you observe that those zeros are being removed or disappearing automatically.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to the Sales Orders work center
- Select the Sales Orders view
- Search for the Sales Order ABC (ABC represents the ID of the Sales Order)
- Add 00 (zeros) in the External Reference field
- Press Enter button
or
- Go to Supplier Invoicing work center
- Go to New supplier invoice without reference to Purchase order under common tasks
- Add 00 (zeros) in the External document ID
- Press Enter button
Cause
It happens because the values you entered in the External Reference field/ External document ID are containing only numbers. Also in general we do not expect any document numbers being generated with leading zeros when they contain only numbers and thus we remove them.
Resolution
In order to have the leading zeros you need to customize by creating new extension field and ask your partners to make the External Reference number to alpha numeric (contains number and characters). For example: 00123A. In this case, the leading zeros will not disappear after pressing Enter button.
or
You can add it to as new requirement on Customer Influence Forum at https://influence.sap.com/sap/ino/#/campaign/886
Keywords
Leading Zeros ; External Reference ; Sales Order; Supplier invoice;External document ID , KBA , zero's disappeared , AP-SLO-SO , Sales Order , AP-SIP-SIV , Supplier Invoice , How To