1. Home
  2. Point-Of-Sale Software
  3. Export from MS POS?

Export from MS POS?

I have a customer that wants to look at using the MS POS. They currently use QuickBooks 2003, and are upgrading to QB2007. I have tested it some, but the problem I am running it to is that you have to have QB installed on the same computer that runs the MS POS. Is there a way to make the account assignments, and then do an export from MSpos (make some type of file) and then import it to QB? The client has an accountant that does not work at the store, and does not come in to the store very often, maybe once a month. They do not want to have to re-input the data.

I have thought about having QB installed both at the store, and at the accountants home, doing a backup at the accountant?s, restoring the backup at the store, importing the info from MSPOS, back up QB at the store, and then restoring that backup to the accountant?s computer. But that is a lot of running around.

Thanks

Reply to
YostNetSolutions
Loading thread data ...

Hi I had a problem you are talking about ... You do not have to reinsert database again ... I did so ... Run MS POS Administrator utillity connect to database and then run query "select * from item"... You will see a lot of needed and unneeded coloumns ... Just go to file then and export it into .csv file ... then you can just open the file with ms excel and remove unvanted columns ... BE CAREFULE ... when you open .csv file directly with excel it removes first "0" s from item lookup kodes ... to avoid it just open a new excel file and then import data, make any filed you want as text , and then edit it ... Hope it will help you ...

P.S. Can I download your inventory database ? Please

Reply to
Ashot

Just have RMS create a QB export file rather than using the direct connection method. Export the file and email/upload the file to the accountant.

Mike McCormick, CPA

YostNetSoluti> I have a customer that wants to look at using the MS POS. They currently use

Reply to
Mike McCormick

Reply to
YostNetSolutions

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.