CPQ and Sales Cloud Revenue line sync incase of recurring revenues

Summary:

We have requirement to sync scheduled recurring revenue lines from CPQ back to sales cloud revenue lines.

Content (required):

Currently, for recurring revenue lines, CPQ send just the first month revenue back to sales cloud. This impacts revenue forecasting and to mitigate this issue, sales reps need to create a duplicate opportunity just for forecasting purpose. Opportunity linked to CPQ quote is not used for forecasting. If we have solution to sync recurring revenue lines back to sales cloud with revenue schedules, then same can be used for forecasting as well. We can create a hidden calculated field in CPQ Line Item Grid calculated as monthly revenue*contract duration (in months), and once this been sent to sales cloud create