Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / ItemLookUp versus Alia...
Microsoft Dynamics RMS (Archived)

ItemLookUp versus Alias - which has precedence? (UPC-->EAN transition)

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We have a manufacturer who switched all their products from UPC barcodes to EAN barcodes.

They are only providing pricing update files with EAN numbers and no UPCs.

Many products are in our database twice. Once with the UPC (older stock) as the ItemLookUp and once with the EAN (newer stock) as the ItemLookUp.

We want to scan a (older stock) product's UPC number and still get the current/new pricing.

If, for each EAN product, we load in an alias that's the old UPC number, will RMS pull up the old product with that number as the ItemLookUp or will it pull up the newer product with the alias?

It's a bit messy, we'd have a DB record with "12345" as the ItemLookUp and a second DB record with "12345" as an alias.

The universe might explode. Unless it's documented and known, it's a recipe for trouble.

Anyone know? Or any elegant solution that I'm missing?

Thanks!

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ItemLookUp versus Alias - which has precedence? (UPC-->EAN transition)

    RMS uses the itemlookupcode first,  then scans aliases,  then matrix items.  

    This is done all within the same query with sql indexes,  so you might see differences sometimes.  

    you could do a table update.

    update item set itemlookupcode = ItemLookupCode + 'OLD' where ItemLookupCode in (select Alias from Alias)

    this appends old to any itemlookupcode that also exists in the alias table as an alias.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ItemLookUp versus Alias - which has precedence? (UPC-->EAN transition)

    How block editing itemlookupcode field en Dynamics RMS in Mode Manteninance.

  • ALT Profile Picture
    ALT 5 on at
    RE: ItemLookUp versus Alias - which has precedence? (UPC-->EAN transition)

     RMS will not allow you to do this.   Change the old Itemlookupcode to 12345-OLD and add the old itemlookupcode 12345 as an alias to the new item.

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans