function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Pedro PaivaPedro Paiva 

Get Billing document Line Items from Billing Document in Finantial Force

Hello, 

I am trying to retrieve the Billing Document Line Items via SOQL to avoid calling the SOQL inside a loop.  But i cannot find a relationship field beetween Billing Document and Billing Document Line Item.

For Example: 
List<Id> listBillingDocumentIds = getTheIds();
List <fferpcore__BillingDocument__c> billingDocuments = new List<fferpcore__BillingDocument__c>([Select Id, Name , (Select Id, Name From fferpcore__BillingDocumentLineItem__c) From fferpcore__BillingDocument__c Where Id IN: listBillingDocumentIds]);

Please any help would be appreciate it.

Thanks in advance