Go through the 3 sections below in order to setup the QuickBooks Link for use with your installations of BusinessMaster and QuickBooks:
1. Download and Install CoreObjects <Top>
CoreObjects is a necessary component used to drive the QuickBooks Link. Contact us for the link to download CoreObjects, if we have not already sent it to you.
Double-click the Installer to begin the installation routine. Click the Next button from the Welcome screen to continue the installation:
This takes you to the License Agreement screen. Click the Yes button to continue the installation:
Click the Next buttons through the remaining screens until you get to the Finish screen. Click the Finish button and the installation of CoreObjects is complete:
If you are going to be installing the Accounting Export on multiple computers on your company network, then you will want to transfer the CoreObjects installer to the shared mastersolutions directory on your server so it can be installed on the additional computers.
2. Download and Install the QuickBooks Link <Top>
The next step is to download the QuickBooks Link for the appropriate version of Microsoft Access that you use. Save it to your c:\mastersolutions directory:
If have purchased the QuickBooks Link, then please Contact us with your Company Name, and the Version of Microsoft Access that you use, and we will email you with a download link.
Note: QuickBooks 2002 or newer must be installed on any computer that will be running the QuickBooks Link.
Once your download is complete, double-click on the Installer file to begin the installation routine. This will bring you to the InstallShield Welcome Screen. Click the Next Button to continue installation:
This takes you to the License Agreement screen. Select the option to Agree to the License Agreement, and click the Next Button to continue installation:
Click the Next button at the Customer Information screen. You may customize this if you wish:
Click the Next button at the Setup Type screen. Leave it set to the Typical installation option:
Click the Install Button to continue installation:
When the files have been installed, click the Finish Button to complete the installation:
If you are going to be installing the QuickBooks Link on multiple computers on your company network, then you want to wait until you have configured this installation of the QuickBooks Link before you copy "BMS-AccountingExport.mde" to the other computers. You will not need to run the QuickBooks Link Installer file again. Click here for information on how to do this.
3. Configure the QuickBooks Link <Top>
Go to c:\mastersolutions. Create a desktop shortcut to this program by right clicking on the file "BMS-AccountingExport.mde". Go to the menu option "Send To" and select "Desktop (create shortcut)" as pictured below:
Now go to your desktop and double-click the shortcut labeled "Shortcut to BMS-AccountingExport.mde" to open the Accounting Export. Click the Utilities Button to start the configuration:
Now click the QB Preferences Button:
Now click the GetQBFilePath button, then browse for and select your company QuickBooks file. In our example, we are using a Sample Company located in the Intuit directory on the local computer, but your company file will probably be located on a shared server accessed via a mapped network drive. Once you have selected your Company File, click the Close Button to go back to the Utility screen:
Now click the Relink Files button:
This brings up the EZ Attachment Manager for the QuickBooks Link. This is where you connect the QuickBooks Link to you BusinessMaster Data Files. The EZ Attachment Manager will come up blank. Select "Company1" from the Select Company Drop Down Menu:
This will bring up a list of two data groups. Select Group1 and click the Change File button. This file will be named "BMS-Maindata_be.mdb, or "Data1.mdb":
Browse for the "BMS-MainData_be.mdb" or "Data1.mdb" database file that most likely resides on your mastersolutions mapped network drive. Click the OK button when you have selected it to set the path in the EZ Attachment Manager. Repeast the process for Group2. It should either be mapped to "c:\mastersolutions\BMS-TempTables.mdb", or "c:\mastersolutions\TempData.mdb", depending on which one you have in that directory. Once you have set the Paths, click the Attach/Reattach Tables to Data Files button:
After the Attachments have been successfully made, click the OK Button and close the EZ Attachment Manager.
Minimize the QuickBooks Link now and make sure you have your QuickBooks Company File open in logged in with the Admin login, and that the file is in Single User mode.
Here is a screenshot of the QuickBooks login interface. You should login with the Admin User Name, or a User Name that has the Admin status for your Company File:
Here is a screenshot of where you switch to Single User Mode in your QuickBooks File. If it is already in Single User mode, it will say Switch to Multi User Mode here:
Now bring up the QuickBooks Link again and from the Utilities screen, click the UpdateLocalData button:
If you get any messages about setting your QuickBooks file path, then your initial settings weren't saved. If this happens, then when the QB Preferences screen pops up, select the path again where you QuickBooks file lives, and completely close out of the QuickBooks Link and reopen it. Then click the Utilities button and with your QuickBooks open in Single User, Admin mode, click the UpdateLocalData button again. This time you should see QuickBooks flashing in the task bar. Pull up QuickBooks and click the Yes, Always button for the Application Certificate that is open.
Now the QuickBooks Link will go through and verify the connection to your QuickBooks file. At this point, minimize the QuickBooks Link and pull up QuickBooks and go to Edit/Preferences/Integrated Applications/Company Preferences, and click the Properties button for msaccess.exe. It may be listed as BusinessMaster, or both msaccess.exe and BusinessMaster may be listed. In either case, go into the Properties for both if they are listed, or just the one that is listed:
Check the box to Allow Microsoft Access to login automatically. Click the OK button here from the Properties screen, then click the OK button again to close out the Preferences screen, and then minimize QuickBooks:
In newer versions of QuickBooks, also check off the option to login automatically as Admin. Click the OK button here from the Properties screen, then click the OK button again to close out the Preferences screen, and then minimize QuickBooks:
Bring up the QuickBooks Link again and click the Utilities button, and then click the QB Preferences Button. In this screen, go through each of the applicable empty Chart of Accounts listed there, and match them to the appropriate Accounts in your QuickBooks file. Close the QB Preferences screen when finished:
Now close the Utilities Screen, and from the Main QuickBooks Link screen, click the BMS-GL Setup button. This brings up the General Ledger to QB Setup screen. (The amount of configuration here depends on whether we originally imported your data from QuickBooks into BusinessMaster, or not.) Match the GLAcctNums here to their counterparts in your QuickBooks company file. When finished, close the screen:
From the Main QuickBooks Link screen again, click the BMS-PartGLSetup button. This brings up the PartsGeneral Ledger to QB Setup screen. (Again, the amount of configuration needed here depends on whether we originally imported you data from QuickBooks into BusinessMaster, or not.) Make sure the QBCOGSGLAcct's for all the parts match the right QBIncomeGLAccts here for your QuickBooks company file. When finished, close the screen, and say no to the box that pops up asking you if you want to update QuickBooks (this will happen automatically when you Export later when using the Link, and in fact, if these are not setup, the Link will refer to the defaults set up in QB Preferences):
This completes the basic setup requirements for the QuickBooks Link. Further setup may need to be defined through our training process.
