runloopable / platform /model /topics /customer_open_documents.yml
fsanyoto's picture
Deploy AIOS web (React glide grid + FastAPI slice)
89af3b2 verified
Raw History Blame Contribute Delete
1.12 kB
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}