Clever Geek Handbook

QuickBooks AccountQuery - FullName does not include parent name

I have an app that syncs with QuickBooks using qbXml and Intuit Web Connector.

I noticed unusual behavior when prompting for accounts. According to the specification, the FullName account must include the names of any of its ancestors, separated by colons. Like "grandparent: parent: account".

In this particular case, however, I am getting a return from the AccountQuery where the account clearly has a parent, but the FullName does not reflect the parent name. This only happens for one specific user, QB 2012 Pro.

Is there a setting or circumstance that causes QB to switch gears and not include the parent name in the full account name?

Here is an example of an account with Fishy FullName (some information changed for confidentiality).

<AccountRet>
  <ListID>800000BD-1328833123</ListID>
  <TimeCreated>2012-02-09T18:20:40-06:00</TimeCreated>
  <TimeModified>2013-02-18T10:49:29-06:00</TimeModified>
  <EditSequence>1361206169</EditSequence>
  <Name>My Account</Name>
  <FullName>My Account</FullName>
  <IsActive>true</IsActive>
  <ParentRef>
    <ListID>80000037-1324501345</ListID>
    <FullName>Parent Account</FullName>
  </ParentRef>
  <Sublevel>1</Sublevel>
  <AccountType>Income</AccountType>
  <AccountNumber>5025.2</AccountNumber>
  <Balance>9.99</Balance>
  <TotalBalance>9.99</TotalBalance>
  <CashFlowClassification>None</CashFlowClassification>
</AccountRet>
+3


source to share


1 answer


This situation is caused by a user with the following preferences being included in QuickBooks:

Edit> Settings> Accounting> Company Preferences> Only Show Lowest Subaccount

So, you have two options:



(1) Ask the user to turn off this preference, or

(2) Use the ParentRef data to link each account to its parent account.

Thanks to Karl Irwin for the heads-up that helped me solve this problem.

+3


source






More articles:


All Articles