Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS forum
Answered

Assigning bar codes to items

(0) ShareShare
ReportReport
Posted on by 70

Is there a way to bar code items en mass? Like by category or even a Shift + Click method? Trying to assign bar codes to 60 thousand different items is a pain.

  • Community member Profile Picture
    Community member 19 on at
    Assigning bar codes to items
    Hello Hasan,
     
    I do have an excel list with all the items' $InventTable_1.ItemId$ and $InventItemBarcode_1.itemBarCode$ (I generated the barcode numbers separately with a UPC-A app) but how do I mass upload them? From Data Management? how?
  • ImMikeD Profile Picture
    ImMikeD 70 on at
    RE: Assigning bar codes to items

    Once I found the correct string to enter, this worked perfectly.  Thank you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Assigning bar codes to items

    Do u already have a list of those barcodes in Excel with 2 columns (ItemLookupCode and barcode)? or u need to generate non-existing barcodes from scratch then assign them to items?

    If u already have the list, then it's easy, just confirm then I will tell u how to import them into a temp table then with a simple query we can do the assignment

    A Hassan

    RMS Leaders

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Assigning bar codes to items

    Thsi would need to be done with a SQL query

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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,876 Super User

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,425 Super User

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans