topic Accumulate calculation in load script in App Development https://community.qlik.com/t5/App-Development/Accumulate-calculation-in-load-script/m-p/1552374#M62856 <P>HI</P><P>&nbsp;</P><P>I'm looking to create a script that will run through data on a table that will allocate incoming stock of a part to customers Back order and give a stock balance before moving on to the next row.</P><P>please see the below table where I have the customer orders and the purchases that we ordered to supplier.</P><P>I need to check the ordered parts then check the incoming orders then allocate the quantity based on FIFO then put the ETA date accordingly.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Orders from customer</TD></TR><TR><TD>PartNO</TD><TD>Ordered Qty</TD><TD>Customer Order Number</TD><TD>Order Date</TD></TR><TR><TD>ABC1</TD><TD>5</TD><TD>11</TD><TD>01-02-2019</TD></TR><TR><TD>ABC1</TD><TD>20</TD><TD>21</TD><TD>25-02-2019</TD></TR><TR><TD>ABC2</TD><TD>10</TD><TD>21</TD><TD>25-02-2019</TD></TR><TR><TD>ABC1</TD><TD>12</TD><TD>30</TD><TD>27-02-2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>Orders from TIQ To Supplier</TD></TR><TR><TD>Part Number</TD><TD>Purchased QTY</TD><TD>TIQ Order Number</TD><TD>ETA Date</TD></TR><TR><TD>ABC1</TD><TD>2</TD><TD>1</TD><TD>15-02-2019</TD></TR><TR><TD>ABC1</TD><TD>15</TD><TD>2</TD><TD>30-02-2019</TD></TR><TR><TD>ABC2</TD><TD>20</TD><TD>2</TD><TD>30-02-2019</TD></TR><TR><TD>ABC1</TD><TD>50</TD><TD>7</TD><TD>04-04-2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Result:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Resulting Table</TD></TR><TR><TD>PartNO</TD><TD>Customer Order No</TD><TD>Customer Order date</TD><TD>Supply Qty</TD><TD>TIQ Order Number</TD><TD>ETA</TD></TR><TR><TD>ABC1</TD><TD>11</TD><TD>01-02-2019</TD><TD>2</TD><TD>1</TD><TD>15-02-2019</TD></TR><TR><TD>ABC1</TD><TD>11</TD><TD>01-02-2019</TD><TD>3</TD><TD>2</TD><TD>15-02-2019</TD></TR><TR><TD>ABC1</TD><TD>21</TD><TD>25-02-2019</TD><TD>12</TD><TD>2</TD><TD>30/02/2019</TD></TR><TR><TD>ABC1</TD><TD>21</TD><TD>25-02-2019</TD><TD>8</TD><TD>7</TD><TD>04-04-2019</TD></TR><TR><TD>ABC2</TD><TD>21</TD><TD>25-02-2019</TD><TD>10</TD><TD>2</TD><TD>30/02/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Kindly advice on the method to achieve it.</P><P>&nbsp;</P> Fri, 02 Apr 2021 07:50:36 GMT jsk_sathis 2021-04-02T07:50:36Z Accumulate calculation in load script https://community.qlik.com/t5/App-Development/Accumulate-calculation-in-load-script/m-p/1552374#M62856 <P>HI</P><P>&nbsp;</P><P>I'm looking to create a script that will run through data on a table that will allocate incoming stock of a part to customers Back order and give a stock balance before moving on to the next row.</P><P>please see the below table where I have the customer orders and the purchases that we ordered to supplier.</P><P>I need to check the ordered parts then check the incoming orders then allocate the quantity based on FIFO then put the ETA date accordingly.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Orders from customer</TD></TR><TR><TD>PartNO</TD><TD>Ordered Qty</TD><TD>Customer Order Number</TD><TD>Order Date</TD></TR><TR><TD>ABC1</TD><TD>5</TD><TD>11</TD><TD>01-02-2019</TD></TR><TR><TD>ABC1</TD><TD>20</TD><TD>21</TD><TD>25-02-2019</TD></TR><TR><TD>ABC2</TD><TD>10</TD><TD>21</TD><TD>25-02-2019</TD></TR><TR><TD>ABC1</TD><TD>12</TD><TD>30</TD><TD>27-02-2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>Orders from TIQ To Supplier</TD></TR><TR><TD>Part Number</TD><TD>Purchased QTY</TD><TD>TIQ Order Number</TD><TD>ETA Date</TD></TR><TR><TD>ABC1</TD><TD>2</TD><TD>1</TD><TD>15-02-2019</TD></TR><TR><TD>ABC1</TD><TD>15</TD><TD>2</TD><TD>30-02-2019</TD></TR><TR><TD>ABC2</TD><TD>20</TD><TD>2</TD><TD>30-02-2019</TD></TR><TR><TD>ABC1</TD><TD>50</TD><TD>7</TD><TD>04-04-2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Result:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Resulting Table</TD></TR><TR><TD>PartNO</TD><TD>Customer Order No</TD><TD>Customer Order date</TD><TD>Supply Qty</TD><TD>TIQ Order Number</TD><TD>ETA</TD></TR><TR><TD>ABC1</TD><TD>11</TD><TD>01-02-2019</TD><TD>2</TD><TD>1</TD><TD>15-02-2019</TD></TR><TR><TD>ABC1</TD><TD>11</TD><TD>01-02-2019</TD><TD>3</TD><TD>2</TD><TD>15-02-2019</TD></TR><TR><TD>ABC1</TD><TD>21</TD><TD>25-02-2019</TD><TD>12</TD><TD>2</TD><TD>30/02/2019</TD></TR><TR><TD>ABC1</TD><TD>21</TD><TD>25-02-2019</TD><TD>8</TD><TD>7</TD><TD>04-04-2019</TD></TR><TR><TD>ABC2</TD><TD>21</TD><TD>25-02-2019</TD><TD>10</TD><TD>2</TD><TD>30/02/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Kindly advice on the method to achieve it.</P><P>&nbsp;</P> Fri, 02 Apr 2021 07:50:36 GMT https://community.qlik.com/t5/App-Development/Accumulate-calculation-in-load-script/m-p/1552374#M62856 jsk_sathis 2021-04-02T07:50:36Z