3 May’17

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


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


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.



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.

Written by

Sohagani Shah

ERP Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more
  • Cause and Solution for Scribe MSMQ not receiving Message from AX

    10 March’ 2018

    Issue: Microsoft Message Queuing (MSMQ) service running on Server might be unable to receive messages. Therefore, messa...

    Read more
  • User Privileges on SharePoint – D365 Document Integration

    10 March’ 2018

    Overview: Often, we wonder what could be wrong where we see a generic error on Documents in Dynamics 365. Something lik...

    Read more