From 9903796b7e1471f6285c9884fadfda9becc890e6 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 7 Jul 2025 13:47:48 +0700
Subject: bf deadstock data

---
 update_list_deadstock_opening.ktr | 94 +++++++++++++++++++--------------------
 1 file changed, 47 insertions(+), 47 deletions(-)

(limited to 'update_list_deadstock_opening.ktr')

diff --git a/update_list_deadstock_opening.ktr b/update_list_deadstock_opening.ktr
index 55f9883..4c8125f 100644
--- a/update_list_deadstock_opening.ktr
+++ b/update_list_deadstock_opening.ktr
@@ -593,10 +593,10 @@
     </partitioning>
     <failIfNoFile>Y</failIfNoFile>
     <calculation>
-      <field_name>new_total_value</field_name>
-      <calc_type>MULTIPLY</calc_type>
+      <field_name>new_qty_available</field_name>
+      <calc_type>SUBTRACT</calc_type>
       <field_a>qty</field_a>
-      <field_b>value</field_b>
+      <field_b>qty_outgoing</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -608,10 +608,10 @@
       <currency_symbol/>
     </calculation>
     <calculation>
-      <field_name>new_qty_available</field_name>
-      <calc_type>SUBTRACT</calc_type>
-      <field_a>qty</field_a>
-      <field_b>qty_outgoing</field_b>
+      <field_name>new_total_value</field_name>
+      <calc_type>MULTIPLY</calc_type>
+      <field_a>new_qty_available</field_a>
+      <field_b>value</field_b>
       <field_c/>
       <value_type>None</value_type>
       <value_length>-1</value_length>
@@ -694,6 +694,46 @@
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>If field value is null 2</name>
+    <type>IfNull</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <replaceAllByValue>0</replaceAllByValue>
+    <replaceAllMask/>
+    <selectFields>Y</selectFields>
+    <selectValuesType>N</selectValuesType>
+    <setEmptyStringAll>N</setEmptyStringAll>
+    <valuetypes>
+      </valuetypes>
+    <fields>
+      <field>
+        <name>new_qty_available</name>
+        <value>0</value>
+        <mask/>
+        <set_empty_string>N</set_empty_string>
+      </field>
+    </fields>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>656</xloc>
+      <yloc>304</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step>
     <name>Merge join</name>
     <type>MergeJoin</type>
@@ -1206,46 +1246,6 @@ order by sq.product_id</sql>
       <draw>Y</draw>
     </GUI>
   </step>
-  <step>
-    <name>If field value is null 2</name>
-    <type>IfNull</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <replaceAllByValue>0</replaceAllByValue>
-    <replaceAllMask/>
-    <selectFields>Y</selectFields>
-    <selectValuesType>N</selectValuesType>
-    <setEmptyStringAll>N</setEmptyStringAll>
-    <valuetypes>
-      </valuetypes>
-    <fields>
-      <field>
-        <name>new_qty_available</name>
-        <value>0</value>
-        <mask/>
-        <set_empty_string>N</set_empty_string>
-      </field>
-    </fields>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>656</xloc>
-      <yloc>304</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>
-- 
cgit v1.2.3