Hi,

Try the following Python code in the scheduled action.

# Set the date to check (yesterday)

yesterday = date.today() - timedelta(days=1)

# Get employees with work schedule defined

employees = env['hr.employee'].search([('resource_calendar_id', '!=', False)])

# Get unpaid leave type (you may want to filter by name or type)

unpaid_leave_type = env['hr.leave.type'].search([('name', 'ilike', 'Unpaid'), ('allocation_type', '=', 'no')], limit=1)

for emp in employees:

    # Check if employee is supposed to work on that day

    is_working_day = emp.resource_calendar_id.attendance_ids.filtered(

        lambda att: int(att.dayofweek) == yesterday.weekday()

    )

    if not is_working_day:

        continue  # Skip if not a working day

    # Check if there's an attendance

    attendance = env['hr.attendance'].search([

        ('employee_id', '=', emp.id),

        ('check_in', '>=', fields.Datetime.to_datetime(yesterday)),

        ('check_in', '<', fields.Datetime.to_datetime(yesterday + timedelta(days=1)))

    ], limit=1)

    # Check if already on leave

    leave = env['hr.leave'].search([

        ('employee_id', '=', emp.id),

        ('state', 'not in', ['cancel', 'refuse']),

        ('request_date_from', '<=', yesterday),

        ('request_date_to', '>=', yesterday)

    ], limit=1)

    if not attendance and not leave and unpaid_leave_type:

        # Create unpaid leave

        env['hr.leave'].create({

            'name': 'Auto Unpaid Leave',

            'holiday_status_id': unpaid_leave_type.id,

            'employee_id': emp.id,

            'request_date_from': yesterday,

            'request_date_to': yesterday,

            'date_from': fields.Datetime.to_datetime(yesterday),

            'date_to': fields.Datetime.to_datetime(yesterday + timedelta(hours=8)),  # Assuming 1 work day

            'state': 'confirm',  # You may want to auto-validate ('validate')

        })

Hope it helps