Details about this thread
  • State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 315 subscribers
  • Views 1222 views
  • Users 0 members are here

Best Way to Capture Invoice Installments (Forecast)

Andy Wilson

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.

  • 0

    Hi  

    Simplest solution would be to use a separate revenue line item for each of those 3 different values and add a custom field for invoice date, and/or you could use the Expected close date for each RLI so it helps with your forecast report.

    .

    CRM Business Consultant

  • 0 in reply to Vincent Amari

    Thank you   for your suggestion.

    At present, we don't have RLI's enabled. If I enable this, would it cause any issues with existing data?

  • 0 in reply to Andy Wilson

    Ah, OK,

    Enabling RLI's will cause changes, best explained here:
    support.sugarcrm.com/.../

    You could instead use Quotes and then Quoted Line Items in the same way.

    .

    CRM Business Consultant

  • 0 in reply to Vincent Amari

    Perfect, thank you.

    I will take a look to see if the fields in the stock Quotes/Quoted Line Items modules will be suitable.

    If not, I'm leaning towards creating a custom module called Invoice Installments, with only the information needed (Value, Date, Related Opportunity, Assigned To).

  • 0

    Using "Revenue Line Items" and Separte "Installments" module - Both of them  may work for that need.

    However if you use "Revenue Line Items" module for these installment details, it gives the right monthly forecast for your forecasting needs.

    Ideally, if you get the order for 100$ and only invoicing is to be done in 4 installments with $25 each at each quarter, keeping in 4 Revenue Line Items make sense.

    Your opportunties are always to give you indication of your future cashflows. 

    If you take the Installment route, your forecast may not be projecting accurate dates for your income. 

    I suggest you should explore more towards using "Revenue Line Items"

    Ram Kumar LK

    Sr Solution Architect

    https://www.bhea.com