function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
PyramidPyramid 

I just want the most recent invoice

I've got a report that shows all accounts, all contracts and all invoices but what I want is all accounts, all contracts and only the most recent invoice.  Does anyone know how to do this?  Thanks

Best Answer chosen by Admin (Salesforce Developers) 
Pradeep_NavatarPradeep_Navatar

More explanation is required on this. I would like to know the following :

 

- Name of the custom objects and relationship between them.

- Is this report is a standard report, customized report or custom visualforce report?

 

In my opinion you need to built a custom visualforce report where you can specify the criteria for the most recent invoice.

 

All Answers

Pradeep_NavatarPradeep_Navatar

More explanation is required on this. I would like to know the following :

 

- Name of the custom objects and relationship between them.

- Is this report is a standard report, customized report or custom visualforce report?

 

In my opinion you need to built a custom visualforce report where you can specify the criteria for the most recent invoice.

 

This was selected as the best answer
PyramidPyramid

Thanks Pradeep -I've never used visualforce  before so now I will research it.