key: customer_open_documents label: Open customer documents (all channels) entity: account.move semantic: approved: [] date_field: "" date_col_note: m.invoice_date scope: Posted customer documents across all channels, including an empty group for customers without documents. measure: {key: customer_open_documents, validate: customer_open_documents} grain: one row per posted customer document, including an empty group for customers without documents store: table: account_move alias: m date_col: m.invoice_date join: >- FULL OUTER JOIN res_partner rp ON rp.id = m.partner_id AND m.state = 'posted' AND m.move_type IN ('out_invoice', 'out_refund') AND m.partner_id IS NOT NULL scope_sql: >- (m.state = 'posted' AND m.move_type IN ('out_invoice', 'out_refund') AND m.partner_id IS NOT NULL) OR (m.id IS NULL AND (rp.customer_rank > 0 OR rp.id IN ( SELECT partner_id FROM sale_order WHERE state IN ('sale', 'done') AND partner_id IS NOT NULL))) dims: partner: {col: "COALESCE(m.partner_id, rp.id)", name_col: "COALESCE(m.partner_name, rp.name)", label: Customer}