Original Message:
Sent: 08-16-2024 18:57
From: George Khairallah
Subject: Misys Software and Sage 300 ?
If by "connected" you're referring to an "integration" with QB, then the answer is yes. It does integrate directly to Quickbooks Desktop (all editions) as well as Quickbooks Online. (Different integration mechanisms)
Yes you can definitely pull data directly from SQL via any known method (SSMS, ODBC, etc... )
I'm not entirely clear on your question about pulling QB data into the SQL tables. MISys does allow transfers of GL, PO, Vendor Bills, Inventory Adjustments, WO, Manufacturing Costs, SO, Invoicing, and Customer and Vendor Records as part of the integration. So, as a result, you technically have some data that exists in Quickbooks and also exists in the MISys DB.
If you are looking to get data from Quickbooks independently from MISys though, you can also use QODBC to connect directly to the Quickbooks company file and pull whatever data you need that way.
------------------------------
George Khairallah
CTO / Co-Founder | gotomyerp, LLC
george.k@gotomyerp.com | 877-888-5525
https://gotomyerp.com
------------------------------
Original Message:
Sent: 08-16-2024 18:50
From: Michele Herzog
Subject: Misys Software and Sage 300 ?
@George Khairallah Do you know if MIsys is connected to QB, does it still work as SQL, meaning you can pull tables from SQL? If yes, is it just the data within Misys or does this allow QB data to be pulled into the SQL tables?
------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]