1 files changed, 47 insertions, 47 deletions
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>
@@ -695,6 +695,46 @@
     </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>
     <description/>
@@ -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>