Editing SQLink Settings

== Import/Export Options tab ==
<h3>On Import section</h3>
[[File:ImportExportOptionsTab1.png]]

<br>'''Merge unmatched invoices and payments''' - ?
<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>'''Import/Export Proposals''' - If checked, proposals will sync from QB to SME
<br>'''Use Markup on Export''' - ?
<br>'''Billing Name Options''' - http://high5software.com/mediawiki/index.php?title=SQLink#Billing_Name_Options
<br>
<br>'''Initialize employee Wage Information''' - ?
<br>'''Do not import or export inventory''' - Inventory will not sync between SME & QuickBooks
<br>'''Set inventory cost/price''' - ?
<br>'''Auto Process Timer''' - http://high5software.com/mediawiki/index.php?title=SQLink#Auto_Process_Timer

<h3>On Export section</h3>
<br>[[File:OnExportSection.png]]
<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>'''Include SMP Items on Purchase Orders''' - woiureow
<br>'''Export all uninitialized customers''' - wourewiu
<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>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>Click this link for details on setup in both SQLink and SME:
<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

== Invoice/Proposal Options tab ==
'''Taxable Code''' - 
<br>'''Non-Taxable Code'''- 
<br>[[File:TaxableNontaxableCode.png]]

<h3>Summarized Labor, Material, Service Line Item</h3>
If you check Summarize Labor into One Line Item, then there will only be one line on your QB invoice for all labor on the SME invoice. The Description will say Labor Summary Line Item and the income will pass through the item selected in the Summarized Labor Line Item field.

<br>Image 1 below shows SQLink set to summarize both Labor and Material. 
<br>Image 2 below shows an SME Invoice with 2 Material Items and 2 Labor Items.
<br>Image 3 below shows the invoice in QB with the Material and Labor items summarized.

<br>[[File:SummarizeLaborLIneItem.png]]
<br>[[File:SummarizedLaborImage2.png]]

<h3> Default Labor, Material, Service Line Item</h3>
This is where you will select your default pass through items for Labor, Materials and Services. They will be defaulted to SMP_Labor, SMP_Item and SMP_Service. You can choose a different item if you would like, but for the Material Line Item make sure you choose a non-inventory item.
<br>These items will be used in the following types of scenarios:
<br>- If an inventory item isn’t in QB, then when item is invoiced the income will pass through the Default Material Line Item.
<br>- If you are invoicing labor and you didn’t choose a service item in the labor editor, the income for labor will pass through the Default Labor Line item in QB.
<br>- If a service item isn’t in QB, then when the item is invoiced, the income will pass through the Default Service Line Item.
<br>- If you are using Fix Rate invoices, the labor, material and services will pass through these items by default.

<br>'''Default Labor Line Item'''- 
<br>Go to QB and open the SMP_Labor item from your item list and set the income account and if you don’t tax labor, change the tax code to non. You will also need to mark SMP_Labor as non-taxable in SME if you don’t charge tax on labor. In SME > Inventory Module > Services, search for SMP_Labor and check non-taxable.

<br>'''Default Material Line Item''' - 
<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>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>
You can choose the order that labor, material and service items show on the invoice in QB.
<br>[[File:LineItemOrder_SQLin.png]]

<h3>Other Options</h3>
[[File:OtherInvoiceProposalOptionsTab.png]]

<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>'''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>'''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>'''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>'''Ignore SME Billing Address''' - 

<h3>Service Location</h3>
This setting drives where the “services requested” and “services performed” description show on the QuickBooks invoice.

<br>[[File:ShowServiceAtTop.png]]

<br>[[File:ShowAtBottom_service.png]]


== Payments and Credits tab ==

<h3>Charge Buckets</h3>
The Charge Buckets are related to fields on the Totals tab on an invoice in SME.
<br>[[File:PaymentCreditTab_ChargeBuckets.png]]

<br>Here is the '''Totals''' tab on an invoice in SME. The fields circled are related to the Charge Buckets in SQLink. If there is a charge in any of these fields on the totals tab, the income will pass through the related Charge Bucket in QuickBooks shown in the invoice image below.
<br>[[File:ChargeBucketsOnTotalsTab.png]]

<br> The above SME invoice had a charge in the Premium, Trip Charge, Other Charges, and Freight fields. On the invoice that synced to QB from SME, you will see the charges pass through the items set in the related charge buckets.
<br>[[File:QBInvoice_ChargeBuckets.png]]

<br> You will need to make sure you set the income account on all or the items set in your charge buckets. Also, if the charge isn’t taxable, make sure you change the item to non-taxable. (image below)

<br>[[File:BucketITemsInQB_SetAccounts.png]]