OpenSync

Home Forums OpenSync Account Classes

Tagged: , ,

This topic contains 5 replies, has 2 voices, and was last updated by  Yudel Rosales 1 week, 1 day ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #63818

    sharper
    Participant

    Hi –

    I have enabled account classes in QB Enterprise but am not seeing these in the account table created by OpenSync in SQL.

    Where would I find these associations?

    Thanks.

    #63834

    Did you run a full populate after that? You have to run a full populate.
    Best Regards,

    #63855

    sharper
    Participant

    Thanks Yudel for the reply.

    I did do a full populate and still not seeing the fields in the account table. I’ve included below the table fields here for your reference. This is AFTER the full populate was run. Let me know next steps.

    USE [QuickBooks]
    GO

    SELECT [ListID]
    ,[TimeCreated]
    ,[TimeModified]
    ,[EditSequence]
    ,[Name]
    ,[FullName]
    ,[IsActive]
    ,[ParentRef_ListID]
    ,[ParentRef_FullName]
    ,[Sublevel]
    ,[AccountType]
    ,[DetailAccountType]
    ,[AccountNumber]
    ,[BankNumber]
    ,[LastCheckNumber]
    ,[Desc]
    ,[Balance]
    ,[TotalBalance]
    ,[CashFlowClassification]
    ,[SpecialAccountType]
    ,[SalesTaxCodeRef_ListID]
    ,[SalesTaxCodeRef_FullName]
    ,[IsTaxAccount]
    ,[TaxLineID]
    ,[TaxLineInfo]
    ,[CurrencyRef_ListID]
    ,[CurrencyRef_FullName]
    ,[CustomField1]
    ,[CustomField2]
    ,[CustomField3]
    ,[CustomField4]
    ,[CustomField5]
    ,[CustomField6]
    ,[CustomField7]
    ,[CustomField8]
    ,[CustomField9]
    ,[CustomField10]
    ,[CustomField11]
    ,[CustomField12]
    ,[CustomField13]
    ,[CustomField14]
    ,[CustomField15]
    ,[Status]
    FROM [dbo].[account]
    GO

    #63858

    Hello

    Look into class table. You should see the association on ParentRef field. Please let me know.

    Best Regards,

    #63860

    sharper
    Participant

    Hi Yudel –

    The class table only has entries for each class – assuming the ParentRef field is if you nest classes in QB – no?

    I’m looking for the Classes you can sign to accounts. See attached screenshot.

    Attachments:
    You must be logged in to view attached files.
    #63863

    I got it. Unfortunately QuickBooks API doesn’t support that field. Check on screen reference for more info: https://developer-static.intuit.com/qbSDK-current/Common/newOSR/index.html

    Sorry for the inconveniences.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.