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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Export all Aliases
Microsoft Dynamics RMS (Archived)

Export all Aliases

(0) ShareShare
ReportReport
Posted on by Community Member

I'm exporting an inventory file out of RMS.

I've got accumulated aliases - some items have 2,3,or more aliases.

When I run:

"Select * from Alias"  

It returns just 3 columns: ID, ItemID, and Alias - but I need a query that returns ALL aliases.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    That table only holds the aliases, no item properties.  What you need to do is join the item table to the alias table.

    Try this:

    select * from alias

    left join [item] on [item].id = alias.ItemID

  • Community Member Profile Picture
    Community Member on at

    This doesn't fix my issue.

    My problem isn't that I am missing the rest of the item properties.

    My problem is that when I look at an item within RMS - many of them have multiple aliases listed: UPC, EAN, internal item code, etc.

    I would assume that running " select * from alias " would generate a list of ALL of those aliases - but instead, it appears to only return ONE alias per record.

    Where are the rest of the aliases stored??  How do I run a query to return them all?

  • Verified answer
    RMS Wizard Profile Picture
    RMS Wizard 1,205 on at

    Click on the Item ID column title and you will notice the sorted list shows a line entry for each alias. The Item ID will appear multiple times if an item has more than one alias. This is more obvious if you run Store Operations Manager, Reports, Items, Alias List and sort the report by Item Lookup Code. To export data from the report, click the Export icon in the report toolbar, set Destination to File and File Format to CSV or Tab Delimited.

  • Community Member Profile Picture
    Community Member on at

    Rad - you're right - i had completely failed to notice that the item ID repeats in that list - I kept expecting to see multiple entries tied to the master Item record...

    On to a little excel wizarding i guess.

  • Community Member Profile Picture
    Community Member on at

    If you only need to look up alias for each item that you enter.    The quickest way to is to use RPS Item Manager Addon from retailpossolutions.com      Let me know if this helps

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 RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans