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) / Exporting Items to new...
Microsoft Dynamics RMS (Archived)

Exporting Items to new POS

(0) ShareShare
ReportReport
Posted on by Community Member

I am getting a new POS System, we have been in business since 2004 and a lot of part# have changed as well as matrix attibutes/dimensions. how do I export information that contains, dimensions and attributes?

*This post is locked for comments

I have the same question (0)
  • Kevin Antosh Profile Picture
    Kevin Antosh 1,649 on at

    Hi!  I'm assuming that you currently use Microsoft Dynamics RMS? What POS system are you moving to as that will have a large effect on what, if any, data can be imported in to the new POS software program.

  • Community Member Profile Picture
    Community Member on at

    So we are switching to NCR Counterpoint.

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,649 on at

    Cool - I've worked on several RMS to NCR CP SQL conversions. Your NCR CounterPoint Partner/Dealer/VAR has a tool that can convert some of the data in the RMS SQL database to the NCR CounterPoint SQL database. Because of differences in the databases, generally only the basic customer, supplier and inventory information is transferred over (eg: PLU, short description, long description, cost, retail price, and supplier data). Customer purchase history can not be transferred so plan on keeping RMS running on one computer for historical data. Whether other product attributes can be transferred over needs to be discussed with your NCR CounterPoint SQL partner/dealer/VAR directly.

  • Community Member Profile Picture
    Community Member on at

    Kevin Antosh

     

    Will Microsoft Dynamics 2.0 application work on a Win 10 Pro OS?  That way we can have all computer stations able to run the old and new POS.  If it will do you have a path or installer that I can put on the new workstations.

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,649 on at

    Hi John, RMS can run on Windows 10 Pro with possible conflicts (it has been hit or miss). Contact your Microsoft Dynamics RMS partner for more details as well as the media for installing RMS. My recommendation would only be to have the new POS stations run RMS Manager and not RMS POS so the staff is not confused as to which POS system to use. You may want to lock down the security settings in RMS as well so the staff doesn't attempt to create PO's, etc. in RMS.  Is there a reason why your RMS Partner/Dealer/VAR and NCR CounterPoint Partner/Dealer/VAR are not helping with the transition?

  • Community Member Profile Picture
    Community Member on at

    Kevin Antosh, can that old historical data be exported to a CSV file and just be referenced from and excel sheet or would it be too big?

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,649 on at

    Yeh - it would be too big in most cases and not in a format that an average person could understand/search.

  • Community Member Profile Picture
    Community Member on at

    Hi Kevin,

    My name is Shelia, and I just came across your post. Would the Counterpoint system you're referring to be the same one that you actually access it via Anzio Lite or Anzio Win? This is a very old system but a good one. We are changing over to Business Central and I'm concerned about exporting all of our data from Counterpoint to Business Central. There is over 30 years of data that has to be transferred.  If you are talking about the same system, do you have suggestions or advice of the best way to accomplish this? Thank you so much!

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,649 on at

    Hi Shelia - no. Best advice would be to work with you NCR CounterPoint and Business Central contacts to see what import/export options are available.

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