Report: Month over Month - Many to Many

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
  • (Edited)

Hello. I have tables of "Invoices", "Lines"  and "Invoice-Line" to create the many to many relationship.

I need to create a report that lists some information about the Line (maybe the name and location) and the dollar amount each month's invoice. How do I do this? Example below. (I am open to other formats as necessary).

Ideally, I would be able to have multiple pieces of information from the Invoice as well, for example the Base Cost and the Total Actuals.

Photo of Sarah Wallis

Sarah Wallis

  • 160 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Depending on how you have the information you should be able to do this already.

Experiment with a summary report.  Particularly the grouping options.

You might have to make sure that all those dollar values are summarized to the main invoice if they aren't already.