Sage 100

We are working with a new Sage 100 ERP Advanced client to bring in QuickBooks History. Does anyone have a way to export the QuickBooks payments and credit card refunds with the invoice applied to information? The QB reports export the invoice paid if the payment only applies to one invoice. If the payment applies to multiple invoices, the invoice field on the report is blank.

This comes up from time to time and the consensus on conversions is to convert totals, perhaps monthly totals for GL and leave the detail in the old system for lookup. I believe at one time Sage offered a conversion routine that appeared to be outsourced overseas though I do not know what type of history may have been brought over (if any). The issue with history is that it's difficult to import accurately and if the customer doesn't check it (they won't) then you'll get a call in 9 months when they spot an issue asking why the import of history is inaccurate.

This is why we say we do not do history other than GL out of QB. You can bring them in unreconciled, but to my knowledge there is no referential integrity. The one company I know who was trying to do something was RISE. Suresh Ketha is the principal there sketha@risecorp.com. 972-853-7704 He will probably be nice to you if you mention Gary Feldman @ I-BN, but you never know.

I agree with Wayne and Gary regarding what we support bringing into Sage 100. However, I think your question is more focused on how to get data out of QB rather than how to get it into MAS. This a set of free ODBC drivers you can install onto a machine running QB (at least there is in QBE). With these, it is possible to pull master file and transaction data into and Excel spreadsheet for further manipulation. I don't know if this will pull the data you are looking for specifically on payment history but it is where I would look to if you can't find it within QB. One caveat, I am currently working with a client moving from QBE to Sage 500 (no comments about sunsets!). The ODBC drivers worked well pulling data for Customers, Vendors, Items, and GL detail history. However, we have not been able to pull detail transaction history for sales due to the volume of records within QB (I highly suspect some data corruption errors as well). We set up the extraction and let it run overnight several times without any success. We even let it run for 60 hours over a weekend once and it never returned a single record. All this to say, I can't promise success on pulling transaction history. Particularly if you are working with a really large data set or one that has a history of frequent failures. Good luck.

Thanks for the comments and direction. At one time Sage had Data Migrator tools and we were certified on this. Then Sage went to Greytrix for conversion from QuickBooks. We are having Greytrix convert the client from QBE to Sage 100 ERP. Greytrix has converted all of the QB data to Sage 100 ERP except for the Sales History. The records for Sales History runs forever and continues to crash. I have used the ODBC to bring the data QBE into Excel and Access. This does contain the detail on payments, however, it does not bring in the field setup in QBE as Account with the Sage Customer Code. The Credit Card Payment does contain a field I can use to identify the Sage Customer Code. We may have to deal with the payments against mulitple invoices manually. Merry Christmas to All

@ChristyPfleger can you bring in the Customer Master from QBE into another table in Access or Excel and relate the tables to get your Sage ID? Just a thought. Thank you for the Christmas wishes.

Thanks for the idea. I will try that.