Hello,

Data will only reset for the month not the total number of records. The cron is to reset the reference numbe ron monthly/yearly base.

If you chose the month reference then it will reset the reference number every month.

Thank you

Can you please check my first reply to this question. I have already told you the requirements. You can increase the `memory_limit` as you need, minimumn is 256M. As I know your cron job is running fine. Thank you

**[Mian Saleem](/u/saleem)** on my php.info memory limit is 512M so it would not be a problem.

but why sometimes I hit CRON JOB button it doesn't reset my reference number? is there anything else I have to look at?

**[Mian Saleem](/u/saleem)** use my screenshot as reference, I use monthly reset format but after month end and turn to new month it still not reset. that is why I need to hit the cron job to reset it manually.

but sometimes the reference number is reset, and sometimes it doesn't.
I need a clear way which is correct because I am going like a loop in this problem.

Hello,

It should run same every time. If it reset some months and not on others then there might be some error that caused it. Did you check the error logs on the month it didn't reset. Do manually calling the cron url work? Only error logs can help here.

Thank you

**[Mian Saleem](/u/saleem)** logs I already sent you since earlier message but I think you did not check it.

when I run the cron manually it also sometimes reference number reset sometimes it doesn't.
on July 15 I run the cron job manually to test and till today the code keep increasing it doesn't reset.

that is why I am trying to figure out and ask for your advice what should I do to make sure that the reference number will reset every time it sopposed to.

thanks

Hello,

I didn't find anything related in those logs.

**_Yes, cron don't reset the reference every time only once in a month._**

Running cron daily or any others day won't be helpful as I told above it only reset reference ONCE in a month.

If it's not resetting then check your cron job if it is setup correctly and running fine.

Thank you

**[Mian Saleem](/u/saleem)** Yes I got your point that it will reset every MONTH, once a month. but as I capture the screenshot and sent you.

from the month end to the new start of the new month but the reference number not reset.

Hello,

Let me know your server and site details in private reply. I will try to check.

Thank you

Hello,

I have tested the cron job for reference again and it is resetting the reference. You can check the date on the `sma_order_ref` It should be the first day of the month when the reference was reset.

I have no idea why is this happening on your server. If I can think, I already have told you :( If you have many sites on the server then your host might be correct about server resources. The manual scorn should display the `Order reference numbers have been reset.` If not displayed then mean system didn't try it as it is already reset for the month.

Thank you