Thanks all, I'll try this on Monday when I go back to the office.
Nicolas.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Wednesday, July 21st, 2021 at 02:55, Rob Sargent <robjsargent@gmail.com> wrote:
Query:
INSERT INTO invl_aml_mapping_temp(invl_id, aml_id, cond)
SELECT
il.id,
ml.id, 48
FROM account_invoice_line il
JOIN account_invoice i ON
i.id = il.invoice_id
JOIN account_move m ON
m.id = i.move_id
JOIN account_move_line ml ON ml.move_id =
m.id JOIN res_company comp ON
comp.id = i.company_id
WHERE il.display_type IS NULL
AND ml.tax_line_id IS NULL
AND NOT EXISTS (SELECT invl_id FROM invl_aml_mapping WHERE invl_id=
il.id)
AND NOT EXISTS (SELECT aml_id FROM invl_aml_mapping WHERE aml_id=
ml.id)
AND
i.id =
Out of curiosity, would combining those two NOT EXISTS in one help? Ever?
