http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/1215.aspxSat, 22 Aug 2009 01:58:16 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:1215Method_Paul0http://forums.method.me/cs/forums/thread/1215.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=1215<p>Hi Joe,</p> <p>&quot;1) If a standard method table is altered via - adding new fields. Will this disturb the integration process ?&quot;</p> <p>-No probelm . Add new fields to your heart&#39;s content.&nbsp; They won&#39;t go into QuickBooks, but Method was built with this in mind.</p> <p>&quot;2) If a standard method table has a field properties (such as required/unique) changed, this will obviously not be copied by the quickbooks software. Does this mean if i set a non-required field in a standard method table to be required and unique, that quickbooks will continue to allow unique data to be duplicated as well as required data to be left blank during data entry on it&#39;s end -- causing conflicts ?? &quot;</p> <p>-You shouldn&#39;t be able to modify any of the built-in accounting fields anyway.&nbsp; You can&#39;t delete them, change their properties, etc., as they are required for synchronization.</p> <p>-You shouldn&#39;t set the field to be unique on an accounting table, since as you pointed out, QuickBooks would not be able to insert a value there.&nbsp; I don&#39;t think we actually stop you from doing that right now, so I&#39;ll forward it on to plug that up.&nbsp; You make a good point. But you should be fine adding a required value, since this is more for a data entry validation from within Method.&nbsp; You are correct, though, that records added in QuickBooks directly on an accounting table with a required custom field would break your integrity.&nbsp; I don&#39;t have any easy work arounds for you, other than to build a screen with a grid that lists broken records that will need to be manually&nbsp;fixed :(.</p> <p>Paul</p>http://forums.method.me/cs/forums/thread/1206.aspxFri, 21 Aug 2009 21:00:42 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:1206Joe0http://forums.method.me/cs/forums/thread/1206.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=1206<p>I have a couple questions regarding data integrity when method transfers/receives data to/from quickbooks.</p> <p>1) If a standard method table is altered via - adding new fields. Will this disturb the integration process ?</p> <p>2) If a standard method table has a field properties (such as required/unique) changed, this will obviously not be copied by the quickbooks software. Does this mean if i set a non-required field in a standard method table to be required and unique, that quickbooks will continue to allow unique data to be duplicated as well as required data to be left blank during data entry on it&#39;s end -- causing conflicts ?? </p> <p>**I am assuming fields on quickbooks&#39;s end have their properties hard-coded and are thus, uncustomizable.</p>