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
jagjitsingh@indivar.comjagjitsingh@indivar.com 

Report

Hi

 

   I want to display report like this

 

    Invoice No : 1                                          Invoice Total : 1000

 

    Item1                    100                       1000

 

    Invoice No : 2                                            Invoice Total : 3400

     Item1                  100            10         1000

     Item2                 200              12        2400

 

    ----------------------------------------------------------------------------------

                                                                       Grand Total : 4400

 

Thanks

tedwardtedward

Create a new custom report.

 

Select a report type of Invoices with Invoice line Items (Create one if it doesn't exist)

 

Choose summary format for the report.

 

Add invoice name/number field to the report from the Invoice object

Add quantity, unit price and value from invoice line item object

 

Group on invoice name/number.

Summarize invoice line item value as a sum.