|
Posted by tl on July 23, 2007, 2:20 pm
Please log in for more thread options Hi convoluted,
I saw that wizard. I think I'll try it first...the query thing is kind of
scary for me. Thank you for your response. It's good to know that someone
has had some success with the import wizard.
"convoluted" wrote:
> My understanding is that POS (Microsoft Point of Sale) was an in-house
> development whereas RMS was purchased from another company (back when it was
> Quicksell / QS Commerce), so they're more like stepbrothers....anyway, in
> MSPOS Manager, check the inventory wizard you'll see an option for a data
> import where you can import items, customers and suppliers; I've had some
> limited exposure to MSPOS but I recall doing a data import from a flat file
> (csv, xls); the help guide is actually pretty good and the import process is
> relatively simple as well. You'll need to find a way to export your RMS data
> either through running a report (ie item list) then exporting to excel; or if
> you're up to the task of doing a select query in administrator that might be
> a cleaner export file, as you'll get to choose which columns the import
> wizard will need for the import mapping (ie ItemlookupCode, price, cost,
> description, supplier, etc); Export the results of your query to the flat
> file you'll use for the import. Unfortunately I uninstalled my laptop copy
> of MSPOS so this is as far as I can take you, but if you get stuck just add
> to your post.
>
> "tl" wrote:
>
> > How do I go about transferring my database (inventory, customers, suppliers,
> > etc) from RMS Version 1.2 to Microsoft Dynamics POS Version 2.0. I got a
> > "sweet deal" from Citibank, which includes a pre-loaded POS system and a
> > great credit card processing rate. It was represented as including set-up
> > and transfer of info from my old program to my new one, but, alas, that was
> > only a sales pitch. They set up the hardware, loaded the POS software and
> > said "see ya!". Now I'm left with setting up the new network and trying to
> > transfer all my old data.
> >
> > Please say there's an easy way to do this transfer. After all, POS is RMS's
> > son...right?
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap