In our use case, we have a parent with potentially hundreds of child "franchises" but the parent will be the invoice owner, child is the subscription owner. We need the child account name and other child account information on scheduled billing reports in addition to the invoice itself. We use the InvoiceItem_AccountName.AccountName field in the invoice template with nested tables to get to the child account name and child detail, but cannot get that field in reports or data sources to create reporting or use Zuora's scheduled reports feature. The only option we have is to combine multiple data extracts, match the data and create custom reporting outside of Zuora.
... View more