How to alter the VAT report quaterly dates

[kwood]

I was wondering if I could have some guidance please. At current there is a VAT report that can be run and will give the total amount of VAT in a specific quarter. But the quarter is based on Apr-June etc.

I need to change it to May-July etc. I have tried to do it myself, but it doesn't work. Is someone able to help me with this please?

Thank you

[MrGettingRatherFrustrated]

https://docs.whmcs.com/Reports#Customising_Reports

[kwood]

On 15/05/2021 at 1:39 PM, MrGettingRatherFrustrated said:

https://docs.whmcs.com/Reports#Customising_Reports

Hi,

Thank you for this, but I am still unsure how to get it to change the months being displayed. I tried to alter the data around, but it didn't work for me.

Edited May 17, 2021 by kwood

[steph.hope]

You need to replace the definitions of the quarters with their new names;

$periodLabels = array(1 => 'February - April', 2 => 'May - July', 3 => 'August - October', 4 => 'November - January');

And also replace these two lines:

$queryStartDate = mktime(0, 0, 0, ($a - 1) * 3 + 1, 1, $i);
$queryEndDate = mktime(0, 0, 0, $a * 3 + 1, 0, $i);

with this:

$queryStartDate = mktime(0, 0, 0, ($a - 1) * 3 + 2, 1, $i);
$queryEndDate = mktime(0, 0, 0, $a * 3 + 2, 0, $i);

I think that should do it.

Edited May 19, 2021 by steph.hope
clarification

[brian!]

.. and remember not to edit the original vat_moss.php report file - duplicate it and edit that... the original will get overwritten during an update and any changes you make to it would be lost.

[kwood]

Thank you both for your help and advise.

@steph.hope I will give this ago, thank you