http://forums.method.me/cs/forums/15.aspxAsk questions specific to the MethodAPI from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/18113.aspxFri, 05 Jul 2013 20:56:12 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:18113Method_David0http://forums.method.me/cs/forums/thread/18113.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=18113<p><br /><span style="overflow:hidden;" id="mce_0_start">Hi gbisaga,<span style="overflow:hidden;" id="mce_1_start"></span></span></p> <p><span style="overflow:hidden;">Off the top of my head there are 2 possibilities<span style="overflow:hidden;" id="mce_4_start"></span>. 1. The customer has not synced to quickbooks yet.&nbsp;2. Check the field entity type, if it <span style="overflow:hidden;" id="mce_2_start">is a &#39;Customer Lead&#39; and not a &#39;Customer&#39; it won&#39;t sync to <span style="overflow:hidden;" id="mce_3_start">QB.</span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">Dave</span></span></span></p> <p><span style="overflow:hidden;"></span>&nbsp;</p>http://forums.method.me/cs/forums/thread/18053.aspxSat, 29 Jun 2013 13:16:36 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:18053gbisaga0http://forums.method.me/cs/forums/thread/18053.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=18053<p><span style="overflow:hidden;">Hi, I am trying to sync over my Customers table to my own database to allow faster/more complex searches <span id="mce_3_start" style="overflow:hidden;">than the API allows&nbsp;</span>and I am running into a problem. How do I know the latest rows to fetch from Method? What I am currently trying to do is get all rows with&nbsp;TimeModifiedAccounting &gt; max(TimeModifiedAccounting) in my local table. But now I am finding that there are a bunch of Customer rows with&nbsp;TimeModifiedAccounting as null.<span id="mce_4_start" style="overflow:hidden;"> Under what conditions is&nbsp;TimeModifiedAccounting null? </span></span></p> <p><span style="overflow:hidden;"><span id="mce_4_start" style="overflow:hidden;">Would it be better to get all rows with RecordID &gt; my highest RecordID? The reason why I did not do this in the first place is that I am afraid somebody will edit an existing record; I would want to sync over that <span id="mce_2_start" style="overflow:hidden;"></span>updated information, but presumably the RecordID will still be the same.</span></span></p> <p>Thanks!</p> <p><span style="overflow:hidden;"><span style="overflow:hidden;">Gary<span id="mce_0_start" style="overflow:hidden;"></span></span></span></p>