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 / Microsoft Dynamics NAV (Archived) / Update table No. Serie...
Microsoft Dynamics NAV (Archived)

Update table No. Series Line Sales from Excel to Navision 2009

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

 

I am trying to update the table  12145 (No. Series Line Sales) in order to increment all the series number from 2015 to the next years until 2020. I am using Na-vision 2009

I am trying to paste the result from Excel but I receive this error message:

“The last operation carried out on ( often paste) and was ignored because the number of characters ( 10 ) would have exceeded the maximum number allowed for the text box Series Code”

 

Can you please help me?

It is another way to update this table?

Why is copy/paste not working?

 

Regards,

Claudiu Petria

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,204 Super User 2026 Season 1 on at

    it seems that series code has more than 10 characters in excel. please check

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,073 on at

    Hi Claudiu,

    NAV 2009 and below not support past data from Excel directly. I think your NAV Partner can help you on this.

  • Community Member Profile Picture
    Community Member on at
    Codice serie Service Center Nr. riga Data inizio Nr. iniziale Nr. finale Avvisa al nr. Incremento-per nr. Ultimo nr. utilizzato Aperto Ultima data utilizzata
    V-NC+ 046-01 30000 01/01/2015 15NC046+00001 1 15NC046+00016 Sì 21/09/2015
    V-NC+ 046-01 40000 01/01/2016 15NC046+00001

     For example, only the red values are changing but when i copy from excel the second and third row i receive that error

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,204 Super User 2026 Season 1 on at

    Paste rows is not valid in NAV2009.

    all columns are trying to insert in Series code field

    because of that you are getting above error.

    You need to write a dataport/xmlport for this.

  • mmv Profile Picture
    mmv 11,471 on at

    Hi,

    You need to use a dataport to import the data.

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 March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans