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 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'calculate_margin_invoice_v3.ktr')

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>
-- 
cgit v1.2.3