Split a user input from a multi row variable based on Calendar year and create line items

[Indira8]

Hello All, 

We have a requirement to take user inputs from multi row variable (MRV) for a catalog item and 2 of them include a start and end date of a license. Another variable is product. The requirement is to create multiple PO line items for each product(user input  from MRV) and it should be split into different PO line items based on calendar year. 

For example if a product X is selected and the start date is Mar 2024 and end date Mar 2025 then 2 PO line items should be created for the same product A with one line item having date range as Mar2024 to Dec 2024 and then other line item having date range as ,Jan 2025 to March 2025. 

Then we need to merge these records based on Product again and then create a software entitlement record and the Start and end date should be as user input given initially. 

We are using only ITSM and Sam foundation and no other subscriptions .

Could you please help us understand if this solution is possible. 

Thank you in advance. 

[Uncle Rob]

Possible, yes, but on the very difficult end of scripting difficulty.
Likely not the level of effort someone is going ot undertake on a community post.  You likely need professional services.

[Indira8]

This is a requirement from client , could you guide on high level how to start with this requirement.

Thank you