Best Way to Capture Invoice Installments (Forecast)

Hello,

I'm looking for some advice around the best method or module to capture invoice installments (value and dates).

This will be used for forecasting purposes in the form of a dashboard chart.

Currently, our users provide a single figure within an opportunity, but this can lead to inaccurate reporting when particular revenues will be split over a varying number of months and invoices.

Not all revenues will have installment invoicing and the ones that are issued in installments may not be split equally across each month.

For example:

Customer A has an opportunity raised against them for 100.00.

At present, the opportunity value is 100.00 and my report says this opportunity will be invoiced in December 2024.

In reality, it has been agreed that this customer will be invoiced 10.00 in October 2024, 60.00 in November 2024, and 30.00 in December 2024.

I have thought about creating a series of individual opportunities which will relate to the parent opportunity. However, I don't believe our users would welcome this method.

Does anyone have any ideas to help achieve this, please?


Thank you.

Parents Reply Children