AX 2012 Add reference not showing options on number sequence

Issue : Add reference not showing options on number sequence.

Above issue may arise if a customized number sequence is created through code.

Solution:

1. Go to AOT>Tables> NumberSequenceTable
2. Open table and find for number sequence created and note recid.

3. Open NumberSequenceScope table and find dataArea for which number sequence created. Note recId.
4. Open NumberSequenceDataType table and find datatype created (number sequence required for ex. Service order id). Note recid.

5. Open NumberSequenceReference table and filter datatypeid field with recid of NumberSequenceDataType table .
6. It will show missing number sequence id. Set number sequence table recid in numberSequenceId field.

7. Update NumberSequenceScope field on NumberSequenceTable .