Alexs at 16:43, 28 May 2015

2015-05-28T16:43:50Z

Alexs at 16:43, 28 May 2015

2015-05-28T16:43:27Z

Alexs: Created page with "1) Open SQLink 2) Go to File> Link Setup> and set the version to 2012. (This is the last major update Intuit provided to their SDK). 3) 4) Click ‘Ok’ ..."

2015-05-28T16:41:30Z

Created page with "1) Open SQLink 2) Go to File> Link Setup> and set the version to 2012. (This is the last major update Intuit provided to their SDK). 3) 4) Click ‘Ok’ ..."

New page

1) Open SQLink

2) Go to File> Link Setup> and set the version to 2012. (This is the last major update Intuit provided to their SDK).

3)

4) Click ‘Ok’

When you upgrade QB from one year to another all of the QB Modified dates on all items get reset. Since the Modified Date is the item that is provided for changed items in QuickBooks, on the next sync after an update SQLink will query all QuickBooks items as un-synced…. To bypass this run the query which sets the dates in SME and stops SQLink from re-syncing. Please have your IT or SQL/SME administrator run the query below in SQL Server Management Studio, (SSMS). (Please call support at High5 if you require assistance running the query).

1) Close SME, SQLink and Run this Query in SSMS:

Declare @nDate as DateTime
set @nDate = GETDATE();

Update SMPLinkSetup
Set
LastAccountsMerge = @nDate,
LastCustMerge = @nDate,
LastEmployeeMerge = @nDate,
LastInventoryMerge = @nDate,
LastInvoiceMerge = @nDate,
LastVendormerge = @nDate,
LastTermsMerge = @nDate,
LastPackageMerge = @nDate,
LastPaymentMerge = @nDate,
LastPOMerge = @nDate,
LastClassMerge = @nDate,
LastCustTypeMerge = @nDate,
LastProposalMerge = @nDate,
LastServiceMerge = @nDate;

</snip>

@@ Line 31: / Line 31: @@
 LastCustTypeMerge = @nDate,
 LastProposalMerge = @nDate,
 LastServiceMerge = @nDate;

@@ Line 3: / Line 3: @@
 )     Go to File> Link Setup> and set the version to 2012. (This is the last major update Intuit provided to their SDK).
-)
+)     [[File:unnamed.png]]
 )     Click ‘Ok’

Quickbook Instructions - Revision history

Alexs at 16:43, 28 May 2015

Alexs at 16:43, 28 May 2015

Alexs: Created page with "1) Open SQLink 2) Go to File> Link Setup> and set the version to 2012. (This is the last major update Intuit provided to their SDK). 3) 4) Click ‘Ok’ ..."