SQLink FAQ

From High5Wiki
Revision as of 16:37, 29 July 2011 by Amy (talk | contribs)
Jump to navigation Jump to search

Do I have to have all QuickBooks users out of QuickBooks when I sync SME and QuickBooks?

No, you only need to get everyone out of QuickBooks for 3 scenarios:

  1. To do your initial sync between SME & QuickBooks
  2. Reassigning parent/sites (only do in QB)
  3. Exporting employees from QuickBooks to SME.


How do I keep my invoice numbers in SME and QuickBooks in sync?

Before creating any invoices in QuickBooks, make sure the invoices from SME are synced over to QuickBooks:

  1. Create Invoices in SME.
  2. Sync SME & QuickBooks.
  3. Create invoices in QuickBooks.
  4. Sync SME & QuickBooks.

To read in more detail, go to Invoice Numbers in SME and QuickBooks

Can I enter text and numbers in my invoice numbers?

QuickBooks allows you to enter text in an invoice number. However when those invoices are synced to SME, the text is stripped out. In SME you can only have numbers in your invoice number field.

How do I change customer job sites

See this video to move customers as job sites under another Billable or Parent customer. This would be done in the case that job sites are first imported into QuickBooks and then you need to move them as job sites.

http://goview.com/?id=44f23476-5178-4c66-8f94-88035396e962


How are opening balances in QuickBooks synced to SME?

SME uses Invoices and Payments to calculate customer balances. Customer balances entered into QuickBooks will need to be entered as invoices, as they are when the Opening Balance is entered when creating a new customer in QuickBooks (circled in the image below).

OpeningBalanceField.jpg

If you enter an opening balance for a customer in QuickBooks, after syncing the balance will carry over to SME and show in the Customer record > Accounts tab> Current field. When payment is received in QuickBooks for the opening balance, the payment will sync to SME and the amount in the Customer record > Accounts tab > Current field will be reduced by the payment amount.

If the opening balance is entered as a GL transaction, it will not sync properly with SME.

OpeningBalance.jpg


How do I add new technicians?

If you are syncing with QuickBooks, you must add new technicians as an Employee in QuickBooks and sync with SME. The Employeee will sync to SME as a User. The User record will default to a Technician.

1. Set QB to Single User Mode
2. Add the new employee in QuickBooks
3. Sync SME and QuickBooks

If you already added the employee to QB and a sync has been processed but the employee is not in SME, do the following:

1. Edit the employee in QB, make a minor change to the address to force QB to reset the modified flag
2. Put QB in Admin/Single User
3. Run a sync


How do I enter a subcontractor?

In SME, a subcontractor is a vendor with the "Is Subcontractor" checkbox checked. QuickBooks will not let us export a Vendor to QuickBooks as a subcontractor.

1. Add vendors in QB
2. Sync to SME
3. Set as Subcontractor in QB & SME