From d0e33f574ad731d911e8017348f6d4b2822ed051 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 13 Oct 2025 14:33:41 +0700
Subject: add calculate margin invoice v3

---
 calculate_margin_invoice_v3.ktr   | 12 ++++++------
 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>
-- 
cgit v1.2.3