diff options
Diffstat (limited to 'calculate_no_sales_stock.ktr')
| -rw-r--r-- | calculate_no_sales_stock.ktr | 133 |
1 files changed, 41 insertions, 92 deletions
diff --git a/calculate_no_sales_stock.ktr b/calculate_no_sales_stock.ktr index 37943d8..17f3076 100644 --- a/calculate_no_sales_stock.ktr +++ b/calculate_no_sales_stock.ktr @@ -726,6 +726,47 @@ </GUI> </step> <step> + <name>Calculator 2</name> + <type>Calculator</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <failIfNoFile>Y</failIfNoFile> + <calculation> + <field_name>new_qty</field_name> + <calc_type>SUBTRACT</calc_type> + <field_a>qty</field_a> + <field_b>qty_outgoing</field_b> + <field_c/> + <value_type>None</value_type> + <value_length>-1</value_length> + <value_precision>-1</value_precision> + <remove>N</remove> + <conversion_mask/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + </calculation> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>736</xloc> + <yloc>368</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Filter rows</name> <type>FilterRows</type> <description/> @@ -1023,39 +1064,30 @@ <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>brand</name> - <rename/> </field> <field> <name>qty</name> - <rename/> </field> <field> <name>date_added</name> - <rename/> </field> <field> <name>in_deadstock</name> - <rename/> </field> <field> <name>in_movement</name> - <rename/> </field> <field> <name>qty_outgoing</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -1087,39 +1119,30 @@ <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>brand</name> - <rename/> </field> <field> <name>qty</name> - <rename/> </field> <field> <name>date_added</name> - <rename/> </field> <field> <name>in_deadstock</name> - <rename/> </field> <field> <name>in_movement</name> - <rename/> </field> <field> <name>qty_outgoing</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -1151,51 +1174,39 @@ <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>brand</name> - <rename/> </field> <field> <name>qty</name> - <rename/> </field> <field> <name>date_added</name> - <rename/> </field> <field> <name>in_deadstock</name> - <rename/> </field> <field> <name>in_movement</name> - <rename/> </field> <field> <name>product_id_1</name> - <rename/> </field> <field> <name>last_in</name> - <rename/> </field> <field> <name>aging</name> - <rename/> </field> <field> <name>qty_outgoing</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -1227,51 +1238,39 @@ <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>brand</name> - <rename/> </field> <field> <name>qty</name> - <rename/> </field> <field> <name>date_added</name> - <rename/> </field> <field> <name>in_deadstock</name> - <rename/> </field> <field> <name>in_movement</name> - <rename/> </field> <field> <name>product_id_1</name> - <rename/> </field> <field> <name>last_in</name> - <rename/> </field> <field> <name>aging</name> - <rename/> </field> <field> <name>qty_outgoing</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -1303,19 +1302,15 @@ <fields> <field> <name>product_id</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product_name</name> - <rename/> </field> <field> <name>brand</name> - <rename/> </field> <field> <name>new_qty</name> @@ -1323,23 +1318,18 @@ </field> <field> <name>date_added</name> - <rename/> </field> <field> <name>last_in</name> - <rename/> </field> <field> <name>aging</name> - <rename/> </field> <field> <name>last_cost</name> - <rename/> </field> <field> <name>total_cost</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -2259,47 +2249,6 @@ order by sq.product_id</sql> <draw>Y</draw> </GUI> </step> - <step> - <name>Calculator 2</name> - <type>Calculator</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <failIfNoFile>Y</failIfNoFile> - <calculation> - <field_name>new_qty</field_name> - <calc_type>SUBTRACT</calc_type> - <field_a>qty</field_a> - <field_b>qty_outgoing</field_b> - <field_c/> - <value_type>None</value_type> - <value_length>-1</value_length> - <value_precision>-1</value_precision> - <remove>N</remove> - <conversion_mask/> - <decimal_symbol/> - <grouping_symbol/> - <currency_symbol/> - </calculation> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>736</xloc> - <yloc>368</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |