I have reactivated the user through backend > CB > User Management > CBsubs tab but it did not seem to trigger the payment.
User has the plan valid for the next month but the plan seems to be free as activated from the backend.
Is it a normal behavior ? Can I only trigger a payment from the front end ?

I checked and It seems that for unlimited plans [column_recur_times] and [column_recur_times] are set to 0

So I used [column_sale_id] which seems to follow the scheme xxxx, xxxxR2, xxxxR3, xxxxR4 and thus should generate a unique invoice number for each new recurring payment, Is that correct this way ? will you keep the sale_id R implementation in the future ?

Edit:
Just tried a manual donation and got the invoice number INV-[column_sale_id]-1706-U-842

Are you sure about substitution in the invoice number ?

No, that substitution isn't going to work there as you're confusing 2 completely different usages. The column substitutions are for CB Query Field only. Normal field substitutions will work in that parameter (e.g. [name]). If you want a value that CB Query Field outputs then you need to substitute in a query field that's outputting the value you're wanting.

OK I see so we'll only get a query list with invoice numbers and added sale_id, but this won't be reflected on the displayed invoice when the customer clicks on the link, correct ?
That's a bit not as good as I imagined, we can look at the real invoice list, but the customer is still stuck with its latest invoice/basket id and payment date

So we need to find another way to display invoices with the needed data