From 4edc140abef8b50c3cde9d877a1641b79ecc08e9 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Wed, 13 Nov 2024 11:48:29 +0700
Subject: bf po more than one not show in fulfillment

---
 collect_fulfillment_po.ktr | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

(limited to 'collect_fulfillment_po.ktr')

diff --git a/collect_fulfillment_po.ktr b/collect_fulfillment_po.ktr
index 6683ec9..3f25650 100644
--- a/collect_fulfillment_po.ktr
+++ b/collect_fulfillment_po.ktr
@@ -534,6 +534,7 @@
 from sales_order_fulfillment_v2
 where 1=1
 and write_date >= (now() - '180 days'::interval)
+--and sale_order_line_id in (select id from sale_order_line sol where sol.order_id = 29290)
 order by sale_order_line_id</sql>
     <limit>0</limit>
     <lookup/>
@@ -621,6 +622,7 @@ join purchase_order po on po.id = posm.purchase_order_id
 where 1=1
 and po.state in ('purchase', 'done')
 and posm.write_date >= (now() - '180 days'::interval)
+--and posm.sale_line_id in (select id from sale_order_line sol where sol.order_id = 29290)
 order by posm.sale_line_id</sql>
     <limit>0</limit>
     <lookup/>
@@ -854,10 +856,16 @@ order by posm.sale_line_id</sql>
         <condition>=</condition>
         <name2/>
       </key>
+      <key>
+        <name>purchase_order_id</name>
+        <field>purchase_order_id</field>
+        <condition>=</condition>
+        <name2/>
+      </key>
       <value>
         <name>purchase_order_id</name>
         <rename>purchase_order_id</rename>
-        <update>Y</update>
+        <update>N</update>
       </value>
       <value>
         <name>sales_order_fulfillment_v2_id</name>
-- 
cgit v1.2.3