Sales Order Line error – Cannot create a record in order line. Record already exist

Introduction

In this blog article, we will see how to resolve the below error while creating a record in Sales Line in AX 2012.

Solution:

This error causes because Sales Line has a primary index set as InventTransId and the value for it is not being generated while inserting a new record in Salesline.

1. Go to Inventory Management -> Setup -> Inventory Management Parameters -> Go to Number Sequence tab
2. Select Lot Id -> Right click -> Select View Details
3. In the General Tab -> Uncheck the manual checkbox.

OR

 
This error can also be caused because there exist unused Number Sequence list.

1. Go to Accounts Receivable -> Setup -> Accounts Receivable Parameters -> Go to Number Sequence Tab
2. Select Sales order -> Right click -> Select View Details
3. On Action Pane Select Manual Clean up -> Select current Tab.

4. On Number Sequence Form -> Select Cleanup

5. Click OK.