Customer Follow Up Management

Adjust Query to Match Database Schema:

• Modify the query in _get_followup_overdue_query method to use the correct column name that corresponds to the account type. If account_type is not available, check for alternatives such as user_type_id or any other column that defines the type of account.

Assuming user_type_id is the correct column:

Solution :

query = ('''

    SELECT pid AS partner_id, SUM(bal2) FROM (

        SELECT 

            CASE WHEN bal IS NOT NULL THEN bal ELSE 0.0 END AS bal2, 

            p.id as pid 

        FROM (

            SELECT 

                (debit - credit) AS bal, 

                partner_id 

            FROM account_move_line l

            LEFT JOIN account_account a ON a.id = l.account_id

            WHERE a.user_type_id IN (

                SELECT id FROM account_account_type WHERE type='receivable'

            )

            %s AND full_reconcile_id IS NULL

            AND l.company_id = %%s

        ) AS l

        RIGHT JOIN res_partner p ON p.id = partner_id 

    ) AS pl

    GROUP BY pid HAVING %s

''') % (overdue_only_str, having_where_clause)