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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV 2009 R2 - Item exp...
Microsoft Dynamics NAV (Archived)

NAV 2009 R2 - Item export and import

(0) ShareShare
ReportReport
Posted on by AbduTeeyech 428

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

I have the same question (0)
  • Verified answer
    mmv Profile Picture
    mmv 11,471 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.

  • AbduTeeyech Profile Picture
    AbduTeeyech 428 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

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

    Hi,

    The change you have made is correct.  

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

    okay, thank you.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November 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