Skip to Content
This question has been flagged
2 Replies
228 Views
Avatar
Benoit Vanasse

Hello and thank you for taking the time to review my post.

I would like to preface that I know a little about coding but not much, I am trying to configure my own Odoo for my small business.

I have to do maintenance on Equipment for my clients at set intervals (typically 3 month interval).

I would like to set Activity to remind myself to create the maintenance task. I do not wish to create the task automatically because those maintenance are often pushed to a later date by my customers.

With Studio, I added the following fields:

  • Date field : to display the next planned maintenance date
  • Integer field : to display the desired interval for maintenance (default 3)
I went to Scheduled Action and created a new action.
I set the Model to "Maintenance Equipment" which is where I keep my Equipment data.
The action is set to execute every 1 day.

I tried to get a code from GPT to run Action and create an automatic Activity everyday and then increase the value of the Date field by the number of months in the Integer field.

The code saves but when I try to run it manually, I do not see any added Activities being generated. Could anyone help me fix this code please?

Thank you!
Ben

Code:

# Get today's date using Odoo's fields helper
today = fields.Date.today()

# Find all equipment whose next PM date is today or earlier
to_process = records.filtered(
    lambda r: r.x_studio_next_pm_date and r.x_studio_next_pm_date <= today
)

for rec in to_process:
    # Create a reminder activity (admin must create PM task manually)
    env['mail.activity'].create({
        'res_model_id': env['ir.model']._get_id(rec._name),
        'res_id': rec.id,
        'activity_type_id': env.ref('mail.mail_activity_data_todo').id,
        'summary': "PM due for %s" % rec.name,
        'note': "Time to review this equipment and create a Field Service task if needed.",
        'date_deadline': today,
        'user_id': 11,  # put the correct user ID here
    })

    # Reschedule next PM date (use Odoo's Date.add, no import)
    freq = rec.x_studio_pm_frequency or 3
    next_date = fields.Date.add(rec.x_studio_next_pm_date, months=freq)

    # Use write() instead of direct assignment
    rec.write({
        'x_studio_next_pm_date': next_date,
    })


Avatar
Discard
Codesphere Tech

Hello,
Try this:
to_process = model.search([
('x_studio_next_pm_date', '<=', today),
('x_studio_next_pm_date', '!=', False)
])

Benoit Vanasse
Author
Thank you for the suggestion!

I read this updated code and still I did not get any activities generated. :(

Code:

# Get today's date using Odoo's fields helper
today = fields.Date.today()

# Find all equipment whose next PM date is today or earlier
to_process = model.search([
('x_studio_next_pm_date', '<=', today),
('x_studio_next_pm_date', '!=', False)
])

for rec in to_process:
    # Create a reminder activity (admin must create PM task manually)
    env['mail.activity'].create({
        'res_model_id': env['ir.model']._get_id(rec._name),
        'res_id': rec.id,
        'activity_type_id': env.ref('mail.mail_activity_data_todo').id,
        'summary': "PM due for %s" % rec.name,
        'note': "Time to review this equipment and create a Field Service task if needed.",
        'date_deadline': today,
        'user_id': 11,  # put the correct user ID here
    })

    # Reschedule next PM date (use Odoo's Date.add, no import)
    freq = rec.x_studio_pm_frequency or 3
    next_date = fields.Date.add(rec.x_studio_next_pm_date, months=freq)

    # Use write() instead of direct assignment
    rec.write({
        'x_studio_next_pm_date': next_date,
    })


Avatar
Kunjan Patel
Best Answer
Hello Benoit Vanasse,
I hope you are doing well

Quick Fix for Odoo v19 Scheduled Actions
1. Search returns no records - verify equipment actually has x_studio_next_pm_date <= today
2.Missing required fields in activity creation - need res_model_id and user_id

Working Code:
  from datetime import date
  from dateutil.relativedelta import relativedelta

  today = date.today()
  equipment = env['maintenance.equipment'].search([
      ('x_studio_next_pm_date', '<=', today)
  ])
  for rec in equipment:
      env['mail.activity'].create({
          'res_model_id': env['ir.model']._get('maintenance.equipment').id,
          'res_id': env.user.id,
      })

      interval = rec.x_studio_pm_interval or 3
      rec.write({
          'x_studio_next_pm_date': today + relativedelta(months=interval)
      })

Debug: Check server logs after "Run Manually" to see if records are found.


I hope this information helps you

Thanks & Regards,
Kunjan Patel

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer
Hi,
To create a scheduled action in Odoo v19:

    First, activate Developer Mode.

    Then go to Settings → Technical → Automation → Scheduled Actions.

    Click New. Fill in:

        Name — give a clear title.

        Model — choose which model the action should run on (for example: sale.order, stock.move, or a custom model).

        Action — choose “code” if you want to run a Python method of the model, and in the Code field write something like:
        model.your_method_name()

        Interval — define how often it runs (e.g. every 1 day, 1 hour, etc).

        Next Execution Date, Number of Calls (e.g. -1 for infinite).

    Save the scheduled action — if “Active” is checked, Odoo will run it automatically according to schedule.

If you need to test it immediately, you can hit Run Manually from the Scheduled Actions list (in developer mode) to trigger it right away.


Hope it helps

Avatar
Discard