I have a monthly invoice, but to see weekly revenue changes, I'd like to list 4 line items on the invoice, one per week with a service date of each Sunday. Then be able to report on weekly P&L based on the invoice detail line's Service Date.
i.e. an Invoice with Date: 11/30/2021
has 4 lines
- Service Date: 11/1 - $500
- Service Date 11/7: $750
- Service Date 11/14: $650
- Service Date 11/21: $950
- Service Date 11/28: $340
Running a P&L for the 11/1 = 11/6 date range would show $500 in revenue.
