Wednesday, March 15, 2023
1 change · master
Enhancements to existing features
Subscription reporting is being redesigned so teams can analyze recurring revenue changes in pivot views and spreadsheets, instead of relying on the old dashboard. The update separates new revenue, expansion, contraction, and churn, and improves currency handling so results can be compared across companies.
Original PR description
# PURPOSE Before this task, the sale_subscription_dashboard can be used to display statistics about subscriptions but the graphs can't be exported in sheets. The idea is to create sql views and to produce a new dashboard. # SPECIFICATIONS Create subscription logs based on [Sale.order.log](https://sale.order.log/) instead of [account.move.line](https://account.move.line/) New event types : New MRR, Expansion, Contraction, Churn Moreover the log amounts were saved in the currency of the pricelist and in the company currency. When we want to compare revenues from different companies, we need a common currency to allows compare these amounts, even if the are coming from different currencies. The best way to achieve it is to convert it to the currency whose relative rate is equal to 1 and then to the currency of the user displaying the report. These things can only be done in the override of read_group. taskid: 3151840