Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

I have a question similar to Reports for two lookup objects that relate to a parent.

I have an two objects (Payable Invoice and Cash Entry) which look up the same child (Transaction).

I'd like to report on them to be able to link Payable Invoices with Cash Entries. How could I do that? Joined reports don't seem to allow Transaction's attributes to be used for joining because they don't belong to both objects.

Object graph

share|improve this question
    
So you want your report to only show Payable Invoices whose Transactions have at least one Cash Entry? Can you provide a small sample of what the report should like? –  Mike Chale Feb 22 '13 at 12:46
    
@MikeChale Yes, something like that. –  ipavlic Feb 22 '13 at 13:26
add comment

1 Answer 1

up vote 1 down vote accepted

You have two options, with the first being to check "Allow Reports" when you create the custom objects. When you create the objects this way Salesforce will generate reports of Payable Invoices with Transactions and Cash Entries and Cash Entries with Transactions and Payable Invoices.

The second method will require a Custom Report Type and Cross Filters.

  1. Create a CRT based on either Cash Entry or Payable Invoice and then select Transaction as a child object. Let's assume you made it based on Payable Invoice.
  2. Create a report on your new type.
  3. Add a Cross Filter and set it to Payable Invoices with Transactions.
  4. Click add a Transactions Filter for Cash Entry not equal to (blank)

enter image description here

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.