Editing SQLink Settings
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 1: | Line 1: | ||
== Import/Export Options tab == | == Import/Export Options tab == | ||
− | + | [[File:ImportExportOptionsTab1.png]] | |
− | |||
− | |||
− | <br>'''Merge unmatched invoices and payments''' - | + | <br>'''On Import section''' - |
− | <br>'''Skip inactive customers on import/export''' - | + | <br>'''Merge unmatched invoices and payments''' - ? |
− | <br>'''Don’t update next invoice number''' - | + | <br>'''Skip inactive customers on import/export''' - ? |
+ | <br>'''Don’t update next invoice number''' - [[Invoice Numbers in SME and QuickBooks]] | ||
<br>'''Export bills for closed orders''' - If checked, when an order is closed, a bill will be created in QB for subcontractor costs on labor and service items. Also have to have “default export bills for closed orders” in SME. | <br>'''Export bills for closed orders''' - If checked, when an order is closed, a bill will be created in QB for subcontractor costs on labor and service items. Also have to have “default export bills for closed orders” in SME. | ||
<br>'''Import/Export Proposals''' - If checked, proposals will sync from QB to SME | <br>'''Import/Export Proposals''' - If checked, proposals will sync from QB to SME | ||
− | <br>'''Use Markup on Export''' - | + | <br>'''Use Markup on Export''' - ? |
− | <br>'''Billing Name Options''' - http://high5software.com/mediawiki/index.php?title=SQLink# | + | <br>'''Billing Name Options''' - http://high5software.com/mediawiki/index.php?title=SQLink#Billing_Name_Options |
<br> | <br> | ||
− | <br>'''Initialize employee Wage Information''' - | + | <br>'''Initialize employee Wage Information''' - ? |
<br>'''Do not import or export inventory''' - Inventory will not sync between SME & QuickBooks | <br>'''Do not import or export inventory''' - Inventory will not sync between SME & QuickBooks | ||
− | <br>'''Set inventory cost/price''' - | + | <br>'''Set inventory cost/price''' - ? |
<br>'''Auto Process Timer''' - http://high5software.com/mediawiki/index.php?title=SQLink#Auto_Process_Timer | <br>'''Auto Process Timer''' - http://high5software.com/mediawiki/index.php?title=SQLink#Auto_Process_Timer | ||
− | |||
− | |||
<br>[[File:OnExportSection.png]] | <br>[[File:OnExportSection.png]] | ||
<br>'''Transfer Tech Time''' / '''Replace Tech time Records on Change''' | <br>'''Transfer Tech Time''' / '''Replace Tech time Records on Change''' | ||
<br>http://high5software.com/mediawiki/index.php?title=SQLink#Tech_Time_.28syncing_time_sheets_to_QB.29 | <br>http://high5software.com/mediawiki/index.php?title=SQLink#Tech_Time_.28syncing_time_sheets_to_QB.29 | ||
− | <br>'''Include SMP Items on Purchase Orders''' - | + | <br>'''Include SMP Items on Purchase Orders''' - woiureow |
− | <br>'''Export all uninitialized customers''' - | + | <br>'''Export all uninitialized customers''' - wourewiu |
− | <br>'''Use | + | <br>'''[[Maintaining Inventory in SME - Use General Ledger Entries for Default Material ]]''' - This setting is recommended to be checked if you keep your inventory items in SME only, not in both SME and QuickBooks. |
<br>'''Purchase Order Options section''' | <br>'''Purchase Order Options section''' | ||
Line 38: | Line 35: | ||
<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 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 | <br>'''Initialize by PO Item''' - Sets the date on the Bill in QB to the line item receipt date from the SME PO | ||
+ | |||
== Invoice/Proposal Options tab == | == Invoice/Proposal Options tab == | ||
− | '''Taxable Code''' - | + | '''Taxable Code''' - |
− | <br>'''Non-Taxable Code'''- | + | <br>'''Non-Taxable Code'''- |
<br>[[File:TaxableNontaxableCode.png]] | <br>[[File:TaxableNontaxableCode.png]] | ||
− | |||
<h3>Summarized Labor, Material, Service Line Item</h3> | <h3>Summarized Labor, Material, Service Line Item</h3> | ||
Line 68: | Line 65: | ||
<br>'''Default Material Line Item''' - | <br>'''Default Material Line Item''' - | ||
<br>Go to QB and open the SMP_Item and set the income account. | <br>Go to QB and open the SMP_Item and set the income account. | ||
− | + | NOTE - If you want to change to use a different item, make sure you select another non-inventory item. | |
<br>'''Default Service Line Item''' - | <br>'''Default Service Line Item''' - | ||
<br>Go to QB and open the SMP_Service in the QB Item List and set the income account | <br>Go to QB and open the SMP_Service in the QB Item List and set the income account | ||
− | + | If you don’t charge tax on services, set SMP_Service to the tax code of Non. You will also need to go set the item in SME as non-taxable. Go to SME > Inventory module > Services and search for SMP_Service. Check non-taxable. | |
<h3>Line Item Order</h3> | <h3>Line Item Order</h3> | ||
Line 83: | Line 80: | ||
<br>'''Show Services Requested''' - If checked, the Services Requested will show on the QB invoices | <br>'''Show Services Requested''' - If checked, the Services Requested will show on the QB invoices | ||
<br>'''Show Services Performed''' - If checked, the Services Performed will show on the QB invoice | <br>'''Show Services Performed''' - If checked, the Services Performed will show on the QB invoice | ||
− | <br>'''Export Purchase Orders for Subcontractors''' - Check this if you selected Default Export Subcontractor PO on Invoices in SME Setup | + | <br>'''Export Purchase Orders for Subcontractors''' - Check this if you selected Default Export Subcontractor PO on Invoices in SME Setup Use Invoice Reference Number - if checked will use ref number instead of invoice number. |
− | + | <br>'''Default Export Bills for Subcontractors''' - Check this if you selected Default Export Subcontractor Bills on Invoices. Use Invoice Reference Number - if checked will use ref number instead of invoice number. | |
− | <br>'''Default Export Bills for Subcontractors''' - Check this if you selected Default Export Subcontractor Bills on Invoices. | + | <br>'''Include labor records on SubContractor Bills and POs''' - |
− | |||
− | <br>'''Include labor records on SubContractor Bills and POs''' - | ||
<br>'''Mark Invoices as ‘To Be Printed’ in QB''' - if checked, the invoices that syncs to QB will have To be printed checked | <br>'''Mark Invoices as ‘To Be Printed’ in QB''' - if checked, the invoices that syncs to QB will have To be printed checked | ||
− | <br>'''Use | + | <br>'''Use ticket number for QB P.O. Number''' - |
<br>'''Show Technician Name in Labor Line Item''' - If checked the technicians name will show on the labor line in QB. Uncheck and it won’t show the tech name. | <br>'''Show Technician Name in Labor Line Item''' - If checked the technicians name will show on the labor line in QB. Uncheck and it won’t show the tech name. | ||
− | <br>'''Ignore SME Billing Address''' - | + | <br>'''Ignore SME Billing Address''' - |
<h3>Service Location</h3> | <h3>Service Location</h3> | ||
Line 99: | Line 94: | ||
<br>[[File:ShowAtBottom_service.png]] | <br>[[File:ShowAtBottom_service.png]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |