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 | |
| parent | 1e771a73751e237aace6ae28d9e70bd676ee31db (diff) | |
add calculate margin invoice v3
| -rw-r--r-- | calculate_margin_invoice_v3.ktr | 12 | ||||
| -rw-r--r-- | import_all_data_bi_indoteknik.kjb | 2 |
2 files changed, 7 insertions, 7 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> diff --git a/import_all_data_bi_indoteknik.kjb b/import_all_data_bi_indoteknik.kjb index 2210ecc..ec084c8 100644 --- a/import_all_data_bi_indoteknik.kjb +++ b/import_all_data_bi_indoteknik.kjb @@ -1704,7 +1704,7 @@ <attributes/> <specification_method>filename</specification_method> <trans_object_id/> - <filename>/home/stephan/transformation-job-bi/calculate_margin_invoice_v2.ktr</filename> + <filename>/home/stephan/transformation-job-bi/calculate_margin_invoice_v3.ktr</filename> <transname/> <arg_from_previous>N</arg_from_previous> <params_from_previous>N</params_from_previous> |