Account Classes

[sharperParticipant]

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.

[Yudel RosalesKeymaster]

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

[sharperParticipant]

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

[Yudel RosalesKeymaster]

Hello

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

Best Regards,

[sharperParticipant]

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.

[Yudel RosalesKeymaster]

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.

[Author]

Posts