Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

NAV 2009 R2 - Item export and import

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans