Grabbing data from Related Parent Record.

[devru 0]

Hi everybody. I am struggling to pull info from a related parent records, for fields that are not ListIDs or FullNames. 

For example i am interested in grabbing the accountNumber for an inventory (itemInvetory) Record. 

I am able to grab the FullName and ListID of the related(parent) account using PCQB_RsGetFirstFieldValue("IncomeAccountRef::IncomeAccountRefAccount::ListID"), but i cannot make it work for other fields from that parent table. What am i doing wrong here? i would like to not have matching tables for these cases, and just be able to pull the info directly in the call. I also looked at the xml response and the info is not in it, so i assume something needs to be done before. Any help is greatly appreciated. 

[comment 1,775]

Not sure what exactly you mean by "grabbing data" or "pull info".

If you want to display data from a field of a parent record, all you need to do is place the field on the layout. It will show data from the first related record in the parent table - and since it is a parent table, there will be only one related record.

By the same token, If you want to use data from a field of a parent record in a calculation defined in the child table, all you need to do is reference the parent field in the calculation's formula directly - for example, the expression:

Parent::Amount + Amount

will return the sum of the parent amount and the child amount. Again, the reference to the parent field will get data from the first related record in the parent table - and again, there will be only one such record. 

 

[devru 0]

6 minutes ago, comment said:

Not sure what exactly you mean by "grabbing data" or "pull info".

If you want to display data from a field of a parent record, all you need to do is place the field on the layout. It will show data from the first related record in the parent table - and since it is a parent table, there will be only one related record.

By the same token, If you want to use data from a field of a parent record in a calculation defined in the child table, all you need to do is reference the parent field in the calculation's formula directly - for example, the expression:

Parent::Amount + Amount

will return the sum of the parent amount and the child amount. Again, the reference to the parent field will get data from the first related record in the parent table - and again, there will be only one such record. 

 

I have the impression that we are talking about different things. I posted under the FM Books Connector , a plugin for FM. The issue i am facing is pulling data of a parent record in QuickBooks

[comment 1,775]

Oops, sorry.

[Geoffrey Gerhard 2]

If I'm reading correctly, you're looking at the response from an ItemInventoryQuery. It only shows the ListID and FullName values of the three Accounts relevant to an inventory item: IncomeAccount, COGSAccount, and AssetAccount.

To get the AccountNumber value for any one of them, you'll need to create an AccountQuery request. Use the ListID or FullName value returned by the ItemInventoryQuery.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC 28105
704.814.6852

[devru 0]

6 minutes ago, comment said:

Oops, sorry.

No worries. Appreciate the eagerness to help though

3 minutes ago, Geoffrey Gerhard said:

If I'm reading correctly, you're looking at the response from an ItemInventoryQuery. It only shows the ListID and FullName values of the three Accounts relevant to an inventory item: IncomeAccount, COGSAccount, and AssetAccount.

To get the AccountNumber value for any one of them, you'll need to create an AccountQuery request. Use the ListID or FullName value returned by the ItemInventoryQuery.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC 28105
704.814.6852

Yeah. Was afraid of that. Seems wierd you can records from related childs, but you can't from related parents. Thanks for the help