diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2025-10-13 14:33:41 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2025-10-13 14:33:41 +0700 |
| commit | d0e33f574ad731d911e8017348f6d4b2822ed051 (patch) | |
| tree | a06262ed42e46711072fdff5ea9b165e46711d60 /calculate_margin_invoice_v3.ktr | |
| parent | 1e771a73751e237aace6ae28d9e70bd676ee31db (diff) | |
add calculate margin invoice v3
Diffstat (limited to 'calculate_margin_invoice_v3.ktr')
| -rw-r--r-- | calculate_margin_invoice_v3.ktr | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/calculate_margin_invoice_v3.ktr b/calculate_margin_invoice_v3.ktr index 701de88..dc8b9db 100644 --- a/calculate_margin_invoice_v3.ktr +++ b/calculate_margin_invoice_v3.ktr @@ -1202,9 +1202,9 @@ left join brand b on b.id = p.brand_id where 1=1 and aml.account_id = 462 and am.state = 'posted' ---and aml.date >= '2025-08-20' -and aml.date >= '2024-06-01' ---and aml.write_date >= (now() - '3 days'::interval)</sql> +--and aml.date >= '2025-09-20' +--and aml.date >= '2024-06-01' +and aml.write_date >= (now() - '3 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -1644,9 +1644,9 @@ join account_move am on am.id = aml.move_id where 1=1 and aml.account_id = 466 and am.state = 'posted' ---and aml.date >= '2025-08-20' -and aml.date >= '2024-06-01' ---and aml.write_date >= (now() - '3 days'::interval)</sql> +and aml.date >= '2025-09-20' +--and aml.date >= '2024-06-01' +and aml.write_date >= (now() - '3 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |