web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Cannot create multiple...
Small and medium business | Business Central, N...
Suggested Answer

Cannot create multiple invoice

(1) ShareShare
ReportReport
Posted on by JH-10021052-0 2
​
 I tried to create multiple invoice in a excel file at a time. However, I enconter the following warning "The Extended Text Line already exists. Identification fields and values:
Table Name='Item',No .= '998',Language Code=",Text No .= '2179',Line
No .= '1000'" for some order. How to identify which item cause this error?

 

​
Categories:
Microsoft Dynamics NAV
I have the same question (0)
  • Suggested answer
    Dr Gomathi MVP, MCT Community lead, MLE Profile Picture
    Dr Gomathi MVP, MCT... 395 Moderator on at

    The error message indicates that an Extended Text Line with the same key values (Table Name = 'Item', No. = '998', Text No. = '2179', Line No. = '1000') already exists in Microsoft Dynamics NAV. This typically happens when importing multiple invoices via Excel, where duplicate extended text lines are being inserted for the same item.

     

    How to Identify the Item Causing This Error

     

    Check the Extended Text Table:

     Open SQL Server Management Studio (SSMS) and run the following query to check for duplicate records:
    SELECT * FROM [YourDatabaseName].[dbo].[Extended Text Line]
WHERE [No_] = '998' AND [Text No_] = '2179' AND [Line No_] = '1000'
    ​​​​​​​
    This will show existing records that are causing the conflict.
     

    1. Review Your Excel File:

       
      • Look for duplicate entries where the same Item No (998) and Text No (2179) appear multiple times with the same Line No (1000).
      • Ensure that extended text lines are not unintentionally duplicated for the same item.
      •  

    2. Modify the Import Process:

       
      • If using Configuration Packages, export the data first and check if duplicates exist.
      • If using a custom AL import, modify the code to prevent inserting extended text if it already exists: 
      • IF NOT ExtendedTextLine.GET(ItemNo, TextNo, LineNo) THEN
    ExtendedTextLine.INSERT;
         
    3. Manually Remove Duplicates in NAV:
      • Navigate to the Extended Text Lines page in NAV.
      • Filter for Item No. 998 and Text No. 2179.
      • Remove any duplicate extended text lines.
     
    Once you've identified and fixed the issue, try re-importing the invoices. Let me know if you need further assistance! 

     
     
    Regards,
     
    Dr. Gomathi S
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 22,342 Super User 2026 Season 1 on at
     Table Name='Item',No .= '998',Language Code=",Text No .= '2179',Line
    No .= '1000'" for some order.

    Its clearly that, the error occurs because an Extended Text entry already exists for Item 998 with Text No. 2179 and Line No. 1000.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,012 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 986 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 659 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans