Home Tour App Library Custom Apps Solution Providers About Contact Community Sign in   |    Pricing & Sign up
Method Integration

Method Community

Welcome to Method Community Sign in | Join | Help
in Search

Entity Table

Last post 03-27-2009 5:34 PM by jallen. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 03-27-2009 4:40 PM

    • jallen
    • Top 50 Contributor
    • Joined on 03-09-2009
    • Atlanta, GA
    • Posts 49

    Entity Table

    Why?

    When tring to ad a field in the Entity Table I receive the following:

    Table does not allow adding fields.

     

  • 03-27-2009 5:00 PM In reply to

    Re: Entity Table

    The Entity table is a 'special' table that exists in Method only - it doesn't exist in QuickBooks and you cannot add fields directly to it.  You can add fields to either the Customer, Employee or Vendor table and miraculously the field will automatically show up in the Entity table for you!  :) 

    This is similar to the Item table.  New fields have to be entered on another table: ie ItemInventory, ItemGroup, etc. for them to appear in the Item table. 

    Hope this helps! Smile

  • 03-27-2009 5:19 PM In reply to

    • jallen
    • Top 50 Contributor
    • Joined on 03-09-2009
    • Atlanta, GA
    • Posts 49

    Re: Entity Table

    Yes... I understand and it worked.  However, what I was trying to do is use the customer (recordID) as a "job number" because it's unique and auto generating number.

    Would it be better if I created a new field in customer table and make that auto generate?  if so, how?

  • 03-27-2009 5:34 PM In reply to

    • jallen
    • Top 50 Contributor
    • Joined on 03-09-2009
    • Atlanta, GA
    • Posts 49

    Re: Entity Table

    Got it...

    Sometimes it takes me a while to connect the dots!

Page 1 of 1 (4 items)
Skip Navigation Links
Copyright 2007-2011 © Alocet Incorporated.
Business Management Software | CRM for QuickBooks | Online Database for QuickBooks | QuickBooks Remote Access | Sales Force Automation | Sales Management Software | Web Based Business Software Suite | Web Based Scheduling Software for QuickBooks
Designed for QuickBooks Sleeter Awesome-Add on Award Microsoft Certified Partner Powered by Rackspace QuickBooks Gold Developer Status