Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Advice for Complete St...
Microsoft Dynamics RMS (Archived)

Advice for Complete Store inventory

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

Hi Everyone, 

    I work for a retail company here in Memphis, TN. We recently moved over to POS system (were using the old samsung cash registers before) and we are about to do our complete inventory for the first time for all our stores. We have about 18 stores right now. We are running RMS on our systems, integrated by a cloud computing software known as Opsuite (created by Positive technology). RMS HQ has been replaced by Opsuite.

  My main issue right now is handheld devices. So far, I've done some inventory on my own, using RMS PI directly or even scanning all items on an excel and then importing, but I want to see if there are some good devices that I can use that would directly sync with RMS and prompt me if there is an invalid/non-existing item that I just scanned, that way I can tag it. Or if there even is a device that will save everything I scan in a CSV file that I can later extract and import into RMS? I was reading about the motorola MC-55 and MT2000, but I'm not sure how exactly they work. Do they connect to my RMS database? Or do they collect the data and then I import it? Couldn't get much from the manuals that I read. 

I'm new to this, and I'm the one who has to figure all this out. Any help would be greatly appreciated. Any tips on how I should begin counting so that I don't make mistakes would be great too. 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Advice for Complete Store inventory

    I have an app that can be used with an Android or I-Phone that will allow you to enter item lookup codes and if the items are found allow you to edit the quantities. This goes directly into the database so you don't need to import a CSV file. It also allows multiple smart phones and PCs to lookup and change quantities at the same time. Please contact me at:  dcandrsn@aol.com if you are interested.

  • NickZnavor Profile Picture
    NickZnavor 715 on at
    RE: Advice for Complete Store inventory

    The MC-55 will connect directly to the database, but you need to purchase/run Mobile Manager on the device.

    I have created addons that use your smart phone, with an in-store-online webapp, that allows real time communication with the rms database, over wifi. But this was built store specific and would need some work for more generalized use.

    But I have used mobile manager on an mc5040 and It works pretty good. It will also allow you to count offline and upload with a csv file saved on the device, but I have never gotten this to work.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Advice for Complete Store inventory

    [quote user="uahmed90"]Or if there even is a device that will save everything I scan in a CSV file that I can later extract and import into RMS?[/quote]

    I am interested in this too though to answer the question above: it depends on what you want in the CSV file. A CSV file is just a text file. If you want a line in the text file for each item in the store, that would be easy. Open a text file on your device and just scan the UPC with a barcode scanner once for each you have on the shelf. If you have 4, you scan it four times and you'll have four lines in your text file each with the UPC once. You can program your barcode scanner to tag a return character onto the code it scans. Most people have their scanners set up this way so you don't have to press the ENTER/RETURN key on the keyboard each time you scan something.

    You could also format your CSV file by typing your quantity on the shelf, then entering a comma, then scanning the barcode. Then you'd have one line per SKU versus versus one line per physical object in your store.

    As for directly interfacing with RMS in realtime, no idea. Anyone?

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans