Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

NAV 2009 R2 - Item export and import

(0) ShareShare
ReportReport
Posted on by 422

Hi, I am trying to update my test DB with live. There are few items created after I copied the test DB.

I want to import all those items to my test. I have data port from item table.

I exported item as text file from live using a dataport

I am trying to import the same item using the same data port in the test, but showing below error while importing:

'This No. is used as Barcodes for Item .'

There are no barcodes with that item number. Is there any other solution for this?.

,Abdul.

*This post is locked for comments

  • AbduTeeyech Profile Picture
    AbduTeeyech 422 on at
    RE: NAV 2009 R2 - Item export and import

    okay, thank you.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: NAV 2009 R2 - Item export and import

    Hi,

    The change you have made is correct.  

  • AbduTeeyech Profile Picture
    AbduTeeyech 422 on at
    RE: NAV 2009 R2 - Item export and import

    Hi Mahesh,

    I already ran it using debug itself and got to know that there is a validation in the item table No. field, which blocks importing. How ever, I had a confusion on the validation code. please see below:

    IF Barcode1.GET("No.") THEN;

     ERROR(

       Text99001525,

       FIELDCAPTION("No."),Barcode1.TABLECAPTION,TABLECAPTION,Barcode1."Item No.");

    I do not know why they put ';' after IF condition. So it was blocking.

    Now I removed that ';' from .GET, now it is imported.

    Hope my changes will affect the system table.

    Thank you for your advise.

    ,Abdul

  • Verified answer
    mmv Profile Picture
    mmv 11,465 on at
    RE: NAV 2009 R2 - Item export and import

    Hi,

    This is actually a part of LS Retail integration.  This code works correctly.  

    If you still couldn't find any Barcode with that Item No, perhaps you may debug to check whether the code is executed correctly.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans