This topic contains 5 replies, has 2 voices, and was last updated by Yudel Rosales 3 years, 10 months ago.
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.
Did you run a full populate after that? You have to run a full populate.
Best Regards,
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
Hello
Look into class table. You should see the association on ParentRef field. Please let me know.
Best Regards,
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.
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.
The forum ‘OpenSync’ is closed to new topics and replies.
Copyright © 2013 Synergration Inc