Editing SQLink
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 10: | Line 10: | ||
*SME – Service Management Enterprise | *SME – Service Management Enterprise | ||
*SQLink – SME to QuickBooks Import- Export data engine. | *SQLink – SME to QuickBooks Import- Export data engine. | ||
− | *QuickBooks by Intuit – | + | *QuickBooks by Intuit – all versions from 2004 to the current year. (Note: We have encountered some issues syncing with unsupported versions of QuickBooks . Review the following link regarding Intuit Sunset policies. [http://support.quickbooks.intuit.com/support/pages/knowledgebasearticle/1003113] |
*QBFC – QuickBooks File Connector XML parsing engine. Runs behind the scenes. | *QBFC – QuickBooks File Connector XML parsing engine. Runs behind the scenes. | ||
Line 16: | Line 16: | ||
== Support Versions of QuickBooks == | == Support Versions of QuickBooks == | ||
− | + | Below are the supported versions of QuickBooks: | |
− | Intuit may discontinue support for QuickBooks editions older than three years. SME and SQLink can connect to these unsupported versions of QuickBooks, but if there are issues connecting High 5 will not assist with problem resolution. | + | * QuickBooks Pro (2005 - 2011) |
+ | * QuickBooks Premier (2005 - 2011) | ||
+ | * QuickBooks Enterprise (2005 - 2011) | ||
+ | |||
+ | Intuit may discontinue support for QuickBooks editions older than three years. SME and SQLink can connect to these unsupported versions of QuickBooks, but if there are issues connecting High 5 will not assist with problem resolution. (click here [http://support.quickbooks.intuit.com/support/pages/knowledgebasearticle/1003113] to view the QuickBooks Service Discontinuation Plan) | ||
When upgrading QuickBooks to another supported version listed above, you don't need to do anything with SME and SQLink as long as your QuickBooks company file remains in place on the server/server. | When upgrading QuickBooks to another supported version listed above, you don't need to do anything with SME and SQLink as long as your QuickBooks company file remains in place on the server/server. | ||
Line 35: | Line 39: | ||
| class="xl67" style="width: 401pt" width="534" | Full sync - Customer Types in QuickBooks | | class="xl67" style="width: 401pt" width="534" | Full sync - Customer Types in QuickBooks | ||
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
+ | | class="xl65" style="height: 14.3pt" height="19" | Class Tracking | ||
+ | | class="xl67" style="width: 401pt" width="534" | Full sync of class tracking on all modules. Class can be assigned to Customer, Order, Item, etc.. | ||
+ | |- style="height: 27.2pt" | ||
| class="xl65" style="height: 27.2pt" height="36" | Credit Memos | | class="xl65" style="height: 27.2pt" height="36" | Credit Memos | ||
− | | class="xl67" style="width: 401pt" width="534" | Synced from QuickBooks. (Need to be applied to an invoice. | + | | class="xl67" style="width: 401pt" width="534" | Synced from QuickBooks . (Need to be applied to an invoice. |
|- style="height: 27.2pt" | |- style="height: 27.2pt" | ||
| class="xl65" style="height: 27.2pt" height="36" | Customer Balances | | class="xl65" style="height: 27.2pt" height="36" | Customer Balances | ||
Line 42: | Line 49: | ||
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
| class="xl65" style="height: 14.3pt" height="19" | Customers | | class="xl65" style="height: 14.3pt" height="19" | Customers | ||
− | | class="xl67" style="width: 401pt" width="534" | Full two-way sync. Customers can be added or modified in either SME or QuickBooks. Billing/Parent customers for Jobs/Sites should only be updated in QuickBooks due to the possibility of issues with existing history for the job/site. | + | | class="xl67" style="width: 401pt" width="534" | Full two-way sync. Customers can be added or modified in either SME or QuickBooks . Billing/Parent customers for Jobs/Sites should only be updated in QuickBooks due to the possibility of issues with existing history for the job/site. |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
| class="xl65" style="height: 14.3pt" height="19" | Employees | | class="xl65" style="height: 14.3pt" height="19" | Employees | ||
− | | class="xl67" style="width: 401pt" width="534" | Sync to SME as technicians and users table. Employees are initially setup in QuickBooks due to sensitive information that is only maintained in QuickBooks. | + | | class="xl67" style="width: 401pt" width="534" | Sync to SME as technicians and users table. Employees are initially setup in QuickBooks due to sensitive information that is only maintained in QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
| class="xl65" style="height: 14.3pt" height="19" | Inventory Assemblies | | class="xl65" style="height: 14.3pt" height="19" | Inventory Assemblies | ||
Line 72: | Line 79: | ||
|- style="height: 27.2pt" | |- style="height: 27.2pt" | ||
| class="xl65" style="height: 27.2pt" height="36" | Purchase Orders | | class="xl65" style="height: 27.2pt" height="36" | Purchase Orders | ||
− | | class="xl67" style="width: 401pt" width="534" | Optional sync with QuickBooks. Multiple syncing options. | + | | class="xl67" style="width: 401pt" width="534" | Optional sync with QuickBooks . Multiple syncing options. |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
| class="xl65" style="height: 14.3pt" height="19" | Subcontractor Bills | | class="xl65" style="height: 14.3pt" height="19" | Subcontractor Bills | ||
Line 78: | Line 85: | ||
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
| class="xl65" style="height: 14.3pt" height="19" | Subcontractor PO | | class="xl65" style="height: 14.3pt" height="19" | Subcontractor PO | ||
− | | class="xl67" style="width: 401pt" width="534" | Subcontractors used on orders in SME can create a Purchase Order in QuickBooks. | + | | class="xl67" style="width: 401pt" width="534" | Subcontractors used on orders in SME can create a Purchase Order in QuickBooks . |
|- style="height: 14.3pt" | |- style="height: 14.3pt" | ||
| class="xl65" style="height: 14.3pt" height="19" | Subcontractors | | class="xl65" style="height: 14.3pt" height="19" | Subcontractors | ||
− | | class="xl67" style="width: 401pt" width="534" | Sync of 1099 vendors as Subcontractors in SME. Vendors that are Subcontractors are initially setup in QuickBooks due to sensitive information that is only maintained in QuickBooks. | + | | class="xl67" style="width: 401pt" width="534" | Sync of 1099 vendors as Subcontractors in SME. Vendors that are Subcontractors are initially setup in QuickBooks due to sensitive information that is only maintained in QuickBooks . |
|- style="height: 27.2pt" | |- style="height: 27.2pt" | ||
| class="xl65" style="height: 27.2pt" height="36" | Tax Codes and Groups | | class="xl65" style="height: 27.2pt" height="36" | Tax Codes and Groups | ||
Line 132: | Line 139: | ||
If your installation falls under number 2 please contact High5Software prior to performing the initial sync as care must be taken to clean up data that may cause issues when syncing. | If your installation falls under number 2 please contact High5Software prior to performing the initial sync as care must be taken to clean up data that may cause issues when syncing. | ||
− | + | '''Initial sync to a newly installed SME application: | |
+ | ''' | ||
SQLink will install with SME in the SME program folder. | SQLink will install with SME in the SME program folder. | ||
Line 154: | Line 162: | ||
− | + | '''Set Up For Initial QuickBooks Company''' | |
Line 179: | Line 187: | ||
− | + | '''SQLink - Initial Setup''' | |
Refer to the following steps to set SQLink options and complete the initial sync. Options and settings for the Initial Setup can also be configured after the initial sync. For detailed information on the implications of specific settings refer to the appropriate Wiki page. | Refer to the following steps to set SQLink options and complete the initial sync. Options and settings for the Initial Setup can also be configured after the initial sync. For detailed information on the implications of specific settings refer to the appropriate Wiki page. | ||
Line 189: | Line 197: | ||
# '''Merge unmatched invoices and payments:''' Check this box to match QuickBooks invoices and payments. Leaving it unchecked will not import payment information from QuickBooks. (The usual setting is checked) | # '''Merge unmatched invoices and payments:''' Check this box to match QuickBooks invoices and payments. Leaving it unchecked will not import payment information from QuickBooks. (The usual setting is checked) | ||
# '''Skip inactive customers on import/export:''' Checking this box will keep SQLink from importing or exporting inactive customers. Since both SME and QuickBooks are programmed to work with inactive customers it is recommended that you do not check this option. (Usual status is Unchecked) | # '''Skip inactive customers on import/export:''' Checking this box will keep SQLink from importing or exporting inactive customers. Since both SME and QuickBooks are programmed to work with inactive customers it is recommended that you do not check this option. (Usual status is Unchecked) | ||
− | # '''Billing Name Options:''' Default setting is Billing Name = Customer Name. For more info on this topic review [[ | + | # '''Billing Name Options:''' Default setting is Billing Name = Customer Name. For more info on this topic review the SQLink Customer wiki page at: [[http://high5software.com/high5bitweaver/wiki/index.php?page=SQLink+-+Customers]] |
# ''' On Export:''' On Export settings cover Tech Time and Purchase Order options. | # ''' On Export:''' On Export settings cover Tech Time and Purchase Order options. | ||
# ''' Include SMP items on Purchase Order:''' This option will pass the default SQLink item for that actual item used in QuickBooks if the item does not exist in QuickBooks. (Usual setting is Checked) | # ''' Include SMP items on Purchase Order:''' This option will pass the default SQLink item for that actual item used in QuickBooks if the item does not exist in QuickBooks. (Usual setting is Checked) | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
# ''' Purchase Order Options.''' | # ''' Purchase Order Options.''' | ||
# Do Not Export Purchase Orders or Bills | # Do Not Export Purchase Orders or Bills | ||
Line 207: | Line 205: | ||
# Export Purchase Orders & Bills | # Export Purchase Orders & Bills | ||
# ''' Export Bills Only:''' Since Purchase Orders require further action to tie them to Bills in QuickBooks the Bill is the method of inventory adjustment in QuickBooks. (This is the recommended setting.) | # ''' Export Bills Only:''' Since Purchase Orders require further action to tie them to Bills in QuickBooks the Bill is the method of inventory adjustment in QuickBooks. (This is the recommended setting.) | ||
− | |||
− | |||
#Make your selections based on the above information and click ‘Next’. | #Make your selections based on the above information and click ‘Next’. | ||
− | |||
− | |||
#SQLink will import the following QuickBooks items: | #SQLink will import the following QuickBooks items: | ||
# Pay Methods | # Pay Methods | ||
Line 232: | Line 226: | ||
− | + | '''Initial Setup''' - Invoice Options: Options on this screen determine how invoices export from SME to QuickBooks. These options can be changed after the initial import. | |
− | Invoice Options: Options on this screen determine how invoices export from SME to QuickBooks. These options can be changed after the initial import. | ||
[[File:SQLinkInitialSetup2.png]] | [[File:SQLinkInitialSetup2.png]] | ||
Line 258: | Line 251: | ||
− | + | Initial Setup - Payment and Charge Buckets: Options on this screen determine which accounts SQLink will use for the following items. You do not need to select any settings at this time as these will be filled in by the SQLink initial setup wizard. | |
− | Options on this screen determine which accounts SQLink will use for the following items. You do not need to select any settings at this time as these will be filled in by the SQLink initial setup wizard. | ||
[[File:InitialSetup_PaymentAndChargeBuckets.png]] | [[File:InitialSetup_PaymentAndChargeBuckets.png]] | ||
Line 277: | Line 269: | ||
# Click ‘Next’. | # Click ‘Next’. | ||
− | + | Initial Setup - Classes & Miscellaneous: Options on this screen determine how default classes, time tracking accounts, wage item, and other accounts will pass information. This information will be filled in automatically when the wizard completes the import process. | |
− | Options on this screen determine how default classes, time tracking accounts, wage item, and other accounts will pass information. This information will be filled in automatically when the wizard completes the import process. | ||
[[File:ClassesAndMisc.png]] | [[File:ClassesAndMisc.png]] | ||
Line 306: | Line 297: | ||
2. System resources available to QuickBooks during the sync. If you are running the sync on a system with marginal memory or one that is short on disk space there will be a significant impact on the time required to process the initial sync. | 2. System resources available to QuickBooks during the sync. If you are running the sync on a system with marginal memory or one that is short on disk space there will be a significant impact on the time required to process the initial sync. | ||
− | + | '''SQLink will complete the following tasks:''' | |
# Creating Default Values | # Creating Default Values | ||
Line 316: | Line 307: | ||
− | + | '''SQLink Setup Screens Post Import:''' | |
Line 357: | Line 348: | ||
<td>80</td> | <td>80</td> | ||
<td>40</td> | <td>40</td> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 422: | Line 408: | ||
<td>20</td> | <td>20</td> | ||
<td>30</td> | <td>30</td> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 576: | Line 537: | ||
== Syncing SME with a new QuickBooks file == | == Syncing SME with a new QuickBooks file == | ||
− | |||
− | |||
− | |||
A new QuickBooks company file must have the following info before syncing to SME: | A new QuickBooks company file must have the following info before syncing to SME: | ||
Line 604: | Line 562: | ||
<br>* Payroll and Compensation Info | <br>* Payroll and Compensation Info | ||
<br>* Enter Wage items – if using time sheets | <br>* Enter Wage items – if using time sheets | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== SQLink Full Sync == | == SQLink Full Sync == | ||
− | SQLink is an add-on product to SME5 to synchronize SME and QB databases. SME handles sales, customers, service orders, and inventory while QuickBooks. handles the accounting, payroll, and banking integration. SME and QB together make a very powerful combination for managing your service business. | + | SQLink is an add-on product to SME5 to synchronize SME and QB databases. SME handles sales, customers, service orders, and inventory while QuickBooks . handles the accounting, payroll, and banking integration. SME and QB together make a very powerful combination for managing your service business. |
This Guide explains the regular sync activity between SME and QB. The sync can be done at any time. Most customers run the sync at the beginning or end of the day, however it can be run whenever needed. | This Guide explains the regular sync activity between SME and QB. The sync can be done at any time. Most customers run the sync at the beginning or end of the day, however it can be run whenever needed. | ||
Line 650: | Line 576: | ||
<br>i. Note: This will perform both an SME export and QB import. Since the SME export is performed first, records that are changed in both SME and QB will only get the SME changes. | <br>i. Note: This will perform both an SME export and QB import. Since the SME export is performed first, records that are changed in both SME and QB will only get the SME changes. | ||
− | <br>ii. Note: QuickBooks will require you to log in to QuickBooks on the computer running SQLink. Log into QuickBooks, SME, and SQLink and then run the sync. The user logging in to QuickBooks must have privileges that allow for the actions to be preformed by SQLink. | + | <br>ii. Note: QuickBooks . will require you to log in to QuickBooks . on the computer running SQLink. Log into QuickBooks . , SME, and SQLink and then run the sync. The user logging in to QuickBooks must have privileges that allow for the actions to be preformed by SQLink. |
'''SME:''' | '''SME:''' | ||
− | <br>iii. Within SME, Tools> Sync QuickBooks. | + | <br>iii. Within SME, Tools> Sync QuickBooks . . |
<br>iv. [[File:Sync1(1).jpg]] | <br>iv. [[File:Sync1(1).jpg]] | ||
<br>v. Answer ‘Ok’ to the prompt. | <br>v. Answer ‘Ok’ to the prompt. | ||
− | <br>vi. Note if you do not have the option “Synchronize with QuickBooks. ”, or the menu option “Sync QuickBooks. ” then the initial import with QuickBooks. has not occurred or has failed. Review the SQLink Install and Setup document or call contact High5 Software technical support at support@high5software.com | + | <br>vi. Note if you do not have the option “Synchronize with QuickBooks . ”, or the menu option “Sync QuickBooks . ” then the initial import with QuickBooks . has not occurred or has failed. Review the SQLink Install and Setup document or call contact High5 Software technical support at support@high5software.com |
SQLink: | SQLink: | ||
<br>vii. Next start processing in SQLink by selecting Processing>Start Processes | <br>vii. Next start processing in SQLink by selecting Processing>Start Processes | ||
Line 669: | Line 595: | ||
<br>1. Open SQLink> File> Link Setup | <br>1. Open SQLink> File> Link Setup | ||
− | <br>2. Open QuickBooks. > F2 | + | <br>2. Open QuickBooks . > F2 |
− | <br>3. The paths for QuickBooks. must match exactly. | + | <br>3. The paths for QuickBooks . must match exactly. |
Line 682: | Line 608: | ||
<br>* [[File:sync4(2).jpg]] | <br>* [[File:sync4(2).jpg]] | ||
− | <br>1) Import QuickBooks. Data: This will import QB data into SME. | + | <br>1) Import QuickBooks . Data: This will import QB data into SME. |
<br>a. Note: if a common record such as Customer is modified in both SME and QB, this function will override the common data in SME with the QB data. | <br>a. Note: if a common record such as Customer is modified in both SME and QB, this function will override the common data in SME with the QB data. | ||
<br>b. This imports all items from QB as mentioned above in the initial synchronization. Only changed items will synchronize so the sync process will be much faster than the initial sync. | <br>b. This imports all items from QB as mentioned above in the initial synchronization. Only changed items will synchronize so the sync process will be much faster than the initial sync. | ||
Line 689: | Line 615: | ||
'''Note:''' The preferred method of sync is listed in the automatic, or SQLink Full Sync Full Sync pages, synchronization because errors can occur. For example if you try to export an Invoice from SME, but a new customer has not been exported yet, SQLink will retun an error from QuickBooks. | '''Note:''' The preferred method of sync is listed in the automatic, or SQLink Full Sync Full Sync pages, synchronization because errors can occur. For example if you try to export an Invoice from SME, but a new customer has not been exported yet, SQLink will retun an error from QuickBooks. | ||
− | <br>1) Export New QuickBooks. Data: This will export from SME to QB. | + | <br>1) Export New QuickBooks . Data: This will export from SME to QB. |
<br>a. ''' Note:''' If a common record such as Customer is modified in both SME and QB, this function will override the common data in QB with the SME data. | <br>a. ''' Note:''' If a common record such as Customer is modified in both SME and QB, this function will override the common data in QB with the SME data. | ||
<br>b. Selections: | <br>b. Selections: | ||
Line 726: | Line 652: | ||
<h3>Mandatory steps for adding new customers</h3> | <h3>Mandatory steps for adding new customers</h3> | ||
− | A best practice is to Always fill out ‘ALL’ information when setting up new records as this will avoid unnecessary errors when syncing invoices. | + | <br>A best practice is to Always fill out ‘ALL’ information when setting up new records as this will avoid unnecessary errors when syncing invoices. |
<br>'''The following Fields will sync''' | <br>'''The following Fields will sync''' | ||
Line 744: | Line 670: | ||
<h3>Customer Taxes</h3> | <h3>Customer Taxes</h3> | ||
− | Review the customer tax setup after creating the customer regardless of the application. If you create the customer in QuickBooks review the tax and set it to the appropriate taxing authority. | + | <br>Review the customer tax setup after creating the customer regardless of the application. If you create the customer in QuickBooks review the tax and set it to the appropriate taxing authority. |
<br>'''Note:''' (QuickBooks uses a dummy tax as the default when syncing with integrated applications.) | <br>'''Note:''' (QuickBooks uses a dummy tax as the default when syncing with integrated applications.) | ||
<br>'''Note:''' QuickBooks does not provide for setting taxes on Sites/Jobs. The Billing location tax authority is used. SME | <br>'''Note:''' QuickBooks does not provide for setting taxes on Sites/Jobs. The Billing location tax authority is used. SME | ||
Line 752: | Line 678: | ||
<h3>SQLink Billing Name Options</h3> | <h3>SQLink Billing Name Options</h3> | ||
− | - Open SQLink and go to '''File'''> '''Setup''' | + | <br>- Open SQLink and go to '''File'''> '''Setup''' |
<br>- Click '''Edit''' | <br>- Click '''Edit''' | ||
<br>- You will see the following options for Billing address export: | <br>- You will see the following options for Billing address export: | ||
Line 822: | Line 748: | ||
* Employees can be entered in SME and not reside in QuickBooks '''unless''' they will become technicians and you are syncing TechTime. You must then add them as an employee in QuickBooks and sync them back to SME and check''' Is Technician''' in their user record. You will need to modify the SME name i.e., name-(SME), or something similar since name conflicts can occur. | * Employees can be entered in SME and not reside in QuickBooks '''unless''' they will become technicians and you are syncing TechTime. You must then add them as an employee in QuickBooks and sync them back to SME and check''' Is Technician''' in their user record. You will need to modify the SME name i.e., name-(SME), or something similar since name conflicts can occur. | ||
*<span style="color: rgb(227, 108, 10);">'''NOTE:'''</span> '''You must log in to QuickBooks as the''' <span style="color: rgb(227, 108, 10);">'''Administrator''' </span>in <span style="color: rgb(227, 108, 10);">'''Single User Mode'''</span> '''to export new employee's from QuickBooks to''' . This is a QuickBooks requirement. If a sync has been processed, and QuickBooks is not logged in with a user that has employee editing permissions, you will need to do the following: | *<span style="color: rgb(227, 108, 10);">'''NOTE:'''</span> '''You must log in to QuickBooks as the''' <span style="color: rgb(227, 108, 10);">'''Administrator''' </span>in <span style="color: rgb(227, 108, 10);">'''Single User Mode'''</span> '''to export new employee's from QuickBooks to''' . This is a QuickBooks requirement. If a sync has been processed, and QuickBooks is not logged in with a user that has employee editing permissions, you will need to do the following: | ||
− | + | * Log in to QB as Admin or a user with employee editing permissions | |
− | + | * Edit the employee in QB to reset the ‘is modified’ flag (i.e. add a period to the address) | |
− | + | * Put QB in Single User mode | |
− | + | * Run a sync | |
− | + | * Return QB to multi-user mode | |
− | |||
− | |||
<h3>Technicians</h3> | <h3>Technicians</h3> | ||
− | Technicians | + | Technicians must be employees in QuickBooks since they may have timesheet data passed from SME to QuickBooks. Technician information is synced with QuickBooks per the sync fields list below. |
− | + | ||
+ | Employee that sync from QuickBooks will have the ‘Is Technician’ check box set automatically. To keep the employee from appearing on the technicians lists during order entry you will need to go to Setup> Users> Technician Settings Tab for the employee and check the ‘Hide In Lists’ check box. | ||
+ | |||
+ | In order to transfer technician time from SMP labor items in orders to QuickBooks timesheets, the following configuration must be established: | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
* In SQLink> '''File'''> '''Setup'''> '''Transfer Tech Tim'''e set the check box | * In SQLink> '''File'''> '''Setup'''> '''Transfer Tech Tim'''e set the check box | ||
* [[File:TechSettings.jpg]] | * [[File:TechSettings.jpg]] | ||
Line 868: | Line 783: | ||
<br>Is Salesperson - QuickBooks or SME | <br>Is Salesperson - QuickBooks or SME | ||
<br>Is Active - QuickBooks or SME | <br>Is Active - QuickBooks or SME | ||
+ | |||
== Invoice Sync Details == | == Invoice Sync Details == | ||
Invoices that are created in SME will sync to QuickBooks if you have SME to sync invoices by default. | Invoices that are created in SME will sync to QuickBooks if you have SME to sync invoices by default. | ||
− | |||
− | |||
<br>- Open SME | <br>- Open SME | ||
<br>- Go to '''Setup''' module > '''Company''' > '''Order''' | <br>- Go to '''Setup''' module > '''Company''' > '''Order''' | ||
Line 878: | Line 792: | ||
<br>- Check '''Default Export On Invoices''' and click '''Save'''. | <br>- Check '''Default Export On Invoices''' and click '''Save'''. | ||
<br>With this setting, any new invoices created in SME will have the Export to QuickBooks checkbox checked. After the invoice syncs to QuickBooks, the box will be cleared. | <br>With this setting, any new invoices created in SME will have the Export to QuickBooks checkbox checked. After the invoice syncs to QuickBooks, the box will be cleared. | ||
− | |||
− | |||
− | |||
<h3>SME Invoice Field Syncing</h3> | <h3>SME Invoice Field Syncing</h3> | ||
Line 886: | Line 797: | ||
<br>[[File:InvoiceFieldMapping.png]] | <br>[[File:InvoiceFieldMapping.png]] | ||
− | < | + | <br>Click [[Editing a Combined Invoice]] to learn about how edited combined invoices in SME update the invoice in QB. |
− | Click | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | == Non-tax in QB Sales Tax Code List == | |
− | <br> | + | This is an issue from the QB Sales Tax List, in QB, under '''Lists'''> '''Sales Tax Items'''. The order of the codes determines what get’s selected on the invoice. We’re only allowed to pass Tax/Non Tax and QB picks from that list. If yours looks like this: |
+ | <br>[[File:QB_Sales_Tax_Codes.png]] | ||
+ | <br> And ‘EXE’ is the first ‘non’ tax item in the list then, Non Tax items from SME will be listed as ‘EXE’. | ||
+ | <br> If your list looks like this: | ||
+ | <br>[[File:Sales_TAx_List.png]] | ||
+ | <br> Then your non tax items will be listed as ‘NON’ | ||
+ | <br> I’ve had customers change that to XMT, to move it to the bottom of the list, and then it will flow correctly for items on the invoice. One of the anomalies of syncing applications. | ||
− | |||
− | |||
− | |||
== Tech Time (syncing time sheets to QB) == | == Tech Time (syncing time sheets to QB) == | ||
Line 930: | Line 828: | ||
<br>* If you sync the labor item to QB timesheet and then delete the service order in SME, the tech time is not deleted from QB timesheet. | <br>* If you sync the labor item to QB timesheet and then delete the service order in SME, the tech time is not deleted from QB timesheet. | ||
+ | |||
+ | == Purchase Order Options == | ||
+ | In SQLink on the Import/Export Options tab, you will find the Purchase Order Options section (shown in the image below) | ||
+ | [[File:SQLink_PurchaseORderOptions.png]]<br> | ||
+ | |||
+ | <br>If you are creating Purchase Orders in SME, you need to decide how your SME POs are going to sync with QuickBooks. You have the following options: | ||
+ | <br> - Create PO in SME and SME will send the same PO to QuickBooks on the next sync. You would have to receive stock on both POs. | ||
+ | <br> - Create PO in SME, receive items on the PO in SME, on next sync SME will put a bill in QB for the items received. The bill will increase the stock in QB. | ||
+ | <br> - Create PO in SME and send both the PO and the Bill in QuickBooks.<br> | ||
+ | <br> | ||
+ | '''Click this link for details and video''':<br> | ||
+ | http://high5software.com/mediawiki/index.php?title=Default_Export_to_QuickBooks_Settings#Export_Options_for_Purchase_Orders | ||
+ | |||
+ | <br>'''Initialize PO Bill Date to from Received Item:''' - If checked, the date on the bill that goes to QB will be the date you received the item, not the PO date. | ||
+ | <br>'''Initialize by PO Item''' - Sets the date on the Bill in QB to the line item receipt date from the SME PO | ||
== Auto Process Timer == | == Auto Process Timer == | ||
In SQLink click '''File'''>'''Setup''' and set the '''Auto Process Timer''' to the number of minutes you want to automatically sync. | In SQLink click '''File'''>'''Setup''' and set the '''Auto Process Timer''' to the number of minutes you want to automatically sync. | ||
− | <br> | + | <br>At the beginning of the day, you will need to open SME, open SQLink, and open QuickBooks. In SME, click Tools > Sync QuickBooks. Keep all three open and throughout the day SME will sync based on the number of minutes you set. |
<br>[[File:AutoProcessTimer.png]] | <br>[[File:AutoProcessTimer.png]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |