[YEAR] tag used on invoices

Hi Tuan,

I have been using [YEAR] tag as a prefix for my invoices but it shows the current year. I would like the prefix to display the year the subscription has been created. Is there any other tag I should use for that purpose?

Best regards.

Olivier

Hello Olivier

That's the right tag. Maybe you can submit a support ticket sending me super admin account of your site, tell me ID of the record which has the wrong data for [YEAR] so that I can check and get back to you with the reason?

Tuan

Hi Tuan,

I have imported around 7,000 entries yesterday. Their created_date and from_date range from 2010 to 2021 but the invoices, which use the [YEAR] tag, all show 2021 as prefix.

Could it be that the [YEAR] tag shows the year the Joomla user has been created (which is when the data has been imported)?

Best regards.

Olivier

That's the reason causing the error. If you have created_date field with properly data, then you can run this SQL command :

UPDATE jos_osmembership_subscribers SET invoice_year = 0

(replace jos_osmembership_subscribers with the right database table on your site)

After that, the data from created_date will be used to generate [YEAR] tag and it should work well

Regards,

Tuan

Thanks again Tuan!

it worked like a charm and I now have the right years on my invoices but it did not reset the invoice number (which should start at 1 every year). Any idea?

Olivier

As you imported the subscription, you will need to import it with right invoice_number . The setting reset invoice number will only works with subscriptions created when users subscribe for your plans via Membership Pro

BTW, could you please update the SQL command earlier to:

UPDATE jos_osmembership_subscribers SET invoice_year = YEAR(`created_date`) .

That should calculate the right invoice_year for each subcription

Regards,

Tuan

OK, that sounds perfect to me!

Have a great day.

Olivier

Thanks Olivier, you too !