Method Community


Managing extra attributes/columns added to Method tables

Last post 11-18-2015 1:34 PM by Method_Ben. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-18-2015 12:22 PM

    Managing extra attributes/columns added to Method tables

    Let's say I want to add an attribute to all of the items we sell: "IsIncludedInReport". I insert it as a column in our Items table.

    The purpose of this is to weed out certain items that should not be included in sales reports.

    This can be easily done in Method, and I can set a default value of "YES".

    But what happens if a new item is added in QuickBooks and then synced with Method? Is the value for the new item blank? Is it the default value (YES)?

    What's the best way to manage something like this on a regular basis?

  • 11-18-2015 1:34 PM In reply to

    Re: Managing extra attributes/columns added to Method tables

    Hi Mike,

    Setting the Default value of a YesNo field is actually a screen level action. Meaning you are just checking or unchecking the checkbox by default on the screen you are using to add/modify records, and actually has no bearing over what the default insertion value is.

    So to answer your question, if you were to add an item into QuickBooks, It will sync over with your method-only YesNo field (IsIncludedInReport) set to FALSE. There isnt a way to sync these records over with the value set to TRUE by default, you would have to alter the records once they have been brought into Method.

    Another thing that is worth mentioning, although im not sure how much use it will be in your sepcific scenario, is thaMethod will sync with QuickBooks Custom fields on the Item table. Meaning you could add the IsIncludedInReport to QuickBooks as well and set that to "Yes" by default and it would sync into method as such. There is one fairly limiting factor however, is that the SDK limits us to only Write new data and read Existing Data to these fields, but not modify existing data. This would mean that if you were to modify any the data in these fields after a records creation, QuickBooks would reject the change and the data in method would be "Rolled back" to reflect this.

    Hopefully this clears things up. Let me know if I can be of any more assistance.

    Thanks Mike.



    Ben Hargreaves
    Senior Support Specialist
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
Page 1 of 1 (2 items)