3 May’17

D365 GeneralSales 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.

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

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more