Spreadsheet: 157672d1337829927-subtotals-test-data
Sheet: Sheet1

Date_a | Mov_no | Cus_code | Acc_code | Depot | Product | Name | Qty | Pallets | Pallet Qty | Pallet Ratio | Description | Unit | Nett | Gst | Gross | Gl_code | Batch_no | Sl_no | Date_b | Ref_no
2012-05-11 00:00:00 | 1998329 | BBQSTO | BBQSTO | [NAME] | AH1084M | MAXIHEAT AREA HEATER | 56 | 7 | 8 | 1 | Melb Storage-Daily 05/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-05-02 00:00:00 | 321117
2012-05-11 00:00:00 | 1998329 | BBQSTO | BBQSTO | [NAME] | AH1084M | MAXIHEAT AREA HEATER | 56 | 7 | 8 | 1 | Melb Storage-Daily 06/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-05-02 00:00:00 | 321117
2012-05-11 00:00:00 | 1998329 | BBQSTO | BBQSTO | [NAME] | AH1084M | MAXIHEAT AREA HEATER | 56 | 7 | 8 | 1 | Melb Storage-Daily 07/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-05-02 00:00:00 | 321117
2012-05-11 00:00:00 | 1998329 | BBQSTO | BBQSTO | [NAME] | AH1084M | MAXIHEAT AREA HEATER | 56 | 7 | 8 | 1 | Melb Storage-Daily 08/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-05-02 00:00:00 | 321117
2012-05-11 00:00:00 | 1998329 | BBQSTO | BBQSTO | [NAME] | AH1084M | MAXIHEAT AREA HEATER | 56 | 7 | 8 | 1 | Melb Storage-Daily 09/05/12 | PALCALC | 2.4 | 0.24 | 2.64 | 03-48500 | 140928 | 321117 | 2012-05-02 00:00:00 | 321117
2012-05-11 00:00:00 | 1998329 | BBQSTO | BBQSTO | [NAME] | AH1084M | MAXIHEAT AREA HEATER | 56 | 7 | 8 | 1 | Melb Storage-Daily 10/05/12 | PALCALC | 1.2 | 0.12 | 1.32 | 03-48500 | 140928 | 321117 | 2012-05-02 00:00:00 | 321117
2012-05-11 00:00:00 | 1998329 | BBQSTO | BBQSTO | [NAME] | AH1084M | MAXIHEAT AREA HEATER | 56 | 7 | 8 | 1 | Melb Storage-Daily 11/05/12 | PALCALC | 0.8 | 0.08 | 0.88 | 03-48500 | 140928 | 321117 | 2012-05-02 00:00:00 | 321117
 | 1998329 Total |  |  |  |  |  |  |  |  |  |  |  | 15.6 | 1.56 | 17.16
2012-05-11 00:00:00 | 1988331 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 140 | 35 | 4 | 1 | Melb Storage-Daily 05/05/12 | PALCALC | 13.2 | 1.32 | 14.52 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988331 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 140 | 35 | 4 | 1 | Melb Storage-Daily 06/05/12 | PALCALC | 13.2 | 1.32 | 14.52 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988331 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 140 | 35 | 4 | 1 | Melb Storage-Daily 07/05/12 | PALCALC | 13.2 | 1.32 | 14.52 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988331 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 140 | 35 | 4 | 1 | Melb Storage-Daily 08/05/12 | PALCALC | 13.2 | 1.32 | 14.52 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988331 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 140 | 35 | 4 | 1 | Melb Storage-Daily 09/05/12 | PALCALC | 12.8 | 1.28 | 14.08 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988331 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 140 | 35 | 4 | 1 | Melb Storage-Daily 10/05/12 | PALCALC | 12.4 | 1.24 | 13.64 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988331 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 140 | 35 | 4 | 1 | Melb Storage-Daily 11/05/12 | PALCALC | 11.6 | 1.16 | 12.76 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
 | 1988331 Total |  |  |  |  |  |  |  |  |  |  |  | 89.6 | 8.96 | 98.56
2012-05-11 00:00:00 | 1988341 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 48 | 12 | 4 | 1 | Melb Storage-Daily 05/05/12 | PALCALC | 4.8 | 0.48 | 5.28 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988341 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 48 | 12 | 4 | 1 | Melb Storage-Daily 06/05/12 | PALCALC | 4.8 | 0.48 | 5.28 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988341 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 48 | 12 | 4 | 1 | Melb Storage-Daily 07/05/12 | PALCALC | 4.8 | 0.48 | 5.28 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988341 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 48 | 12 | 4 | 1 | Melb Storage-Daily 08/05/12 | PALCALC | 4.8 | 0.48 | 5.28 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988341 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 48 | 12 | 4 | 1 | Melb Storage-Daily 09/05/12 | PALCALC | 4.8 | 0.48 | 5.28 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988341 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 48 | 12 | 4 | 1 | Melb Storage-Daily 10/05/12 | PALCALC | 4.8 | 0.48 | 5.28 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1988341 | BBQSTO | BBQSTO | [NAME] | AH3064M | MAXIHEAT AREA HEATER CLASSIC | 48 | 12 | 4 | 1 | Melb Storage-Daily 11/05/12 | PALCALC | 4.8 | 0.48 | 5.28 | 03-48500 | 140928 | 321117 | 2012-04-18 00:00:00 | 321117
 | 1988341 Total |  |  |  |  |  |  |  |  |  |  |  | 33.6 | 3.36 | 36.96
2012-05-11 00:00:00 | 1935943 | BBQSTO | BBQSTO | [NAME] | AH3069M | MAXIHEAT AREA HEATER | 47 | 11.75 | 4 | 1 | Melb Storage-Daily 05/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-02-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1935943 | BBQSTO | BBQSTO | [NAME] | AH3069M | MAXIHEAT AREA HEATER | 47 | 11.75 | 4 | 1 | Melb Storage-Daily 06/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-02-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1935943 | BBQSTO | BBQSTO | [NAME] | AH3069M | MAXIHEAT AREA HEATER | 47 | 11.75 | 4 | 1 | Melb Storage-Daily 07/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-02-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1935943 | BBQSTO | BBQSTO | [NAME] | AH3069M | MAXIHEAT AREA HEATER | 47 | 11.75 | 4 | 1 | Melb Storage-Daily 08/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-02-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1935943 | BBQSTO | BBQSTO | [NAME] | AH3069M | MAXIHEAT AREA HEATER | 47 | 11.75 | 4 | 1 | Melb Storage-Daily 09/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-02-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1935943 | BBQSTO | BBQSTO | [NAME] | AH3069M | MAXIHEAT AREA HEATER | 47 | 11.75 | 4 | 1 | Melb Storage-Daily 10/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-02-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1935943 | BBQSTO | BBQSTO | [NAME] | AH3069M | MAXIHEAT AREA HEATER | 47 | 11.75 | 4 | 1 | Melb Storage-Daily 11/05/12 | PALCALC | 2.8 | 0.28 | 3.08 | 03-48500 | 140928 | 321117 | 2012-02-17 00:00:00 | 321117
 | 1935943 Total |  |  |  |  |  |  |  |  |  |  |  | 19.6 | 1.96 | 21.56
2012-05-11 00:00:00 | 1903999 | BBQSTO | BBQSTO | [NAME] | B4 | CAST IRON BURNER | 564 | 0.96 | 588 | 1 | Melb Storage-Daily 05/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2012-01-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1903999 | BBQSTO | BBQSTO | [NAME] | B4 | CAST IRON BURNER | 564 | 0.96 | 588 | 1 | Melb Storage-Daily 06/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2012-01-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1903999 | BBQSTO | BBQSTO | [NAME] | B4 | CAST IRON BURNER | 564 | 0.96 | 588 | 1 | Melb Storage-Daily 07/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2012-01-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1903999 | BBQSTO | BBQSTO | [NAME] | B4 | CAST IRON BURNER | 564 | 0.96 | 588 | 1 | Melb Storage-Daily 08/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2012-01-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1903999 | BBQSTO | BBQSTO | [NAME] | B4 | CAST IRON BURNER | 564 | 0.96 | 588 | 1 | Melb Storage-Daily 09/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2012-01-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1903999 | BBQSTO | BBQSTO | [NAME] | B4 | CAST IRON BURNER | 564 | 0.96 | 588 | 1 | Melb Storage-Daily 10/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2012-01-18 00:00:00 | 321117
2012-05-11 00:00:00 | 1903999 | BBQSTO | BBQSTO | [NAME] | B4 | CAST IRON BURNER | 564 | 0.96 | 588 | 1 | Melb Storage-Daily 11/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2012-01-18 00:00:00 | 321117
 | 1903999 Total |  |  |  |  |  |  |  |  |  |  |  | 2.8 | 0.28 | 3.08
2012-05-11 00:00:00 | 1495844 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 16 | 0.17 | 96 | 1 | Melb Storage-Daily 05/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2010-10-14 00:00:00 | 321117
2012-05-11 00:00:00 | 1495844 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 16 | 0.17 | 96 | 1 | Melb Storage-Daily 06/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2010-10-14 00:00:00 | 321117
2012-05-11 00:00:00 | 1495844 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 16 | 0.17 | 96 | 1 | Melb Storage-Daily 07/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2010-10-14 00:00:00 | 321117
2012-05-11 00:00:00 | 1495844 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 16 | 0.17 | 96 | 1 | Melb Storage-Daily 08/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2010-10-14 00:00:00 | 321117
2012-05-11 00:00:00 | 1495844 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 16 | 0.17 | 96 | 1 | Melb Storage-Daily 09/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2010-10-14 00:00:00 | 321117
2012-05-11 00:00:00 | 1495844 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 16 | 0.17 | 96 | 1 | Melb Storage-Daily 10/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2010-10-14 00:00:00 | 321117
2012-05-11 00:00:00 | 1495844 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 16 | 0.17 | 96 | 1 | Melb Storage-Daily 11/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2010-10-14 00:00:00 | 321117
 | 1495844 Total |  |  |  |  |  |  |  |  |  |  |  | 2.8 | 0.28 | 3.08
2012-05-11 00:00:00 | 1610013 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 8 | 0.09 | 96 | 1 | Melb Storage-Daily 05/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2011-03-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1610013 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 8 | 0.09 | 96 | 1 | Melb Storage-Daily 06/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2011-03-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1610013 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 8 | 0.09 | 96 | 1 | Melb Storage-Daily 07/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2011-03-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1610013 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 8 | 0.09 | 96 | 1 | Melb Storage-Daily 08/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2011-03-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1610013 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 8 | 0.09 | 96 | 1 | Melb Storage-Daily 09/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2011-03-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1610013 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 8 | 0.09 | 96 | 1 | Melb Storage-Daily 10/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2011-03-17 00:00:00 | 321117
2012-05-11 00:00:00 | 1610013 | BBQSTO | BBQSTO | [NAME] | BBQFL100 | FLEXI LIGHT SILVER W/TIMER | 8 | 0.09 | 96 | 1 | Melb Storage-Daily 11/05/12 | PALCALC | 0.4 | 0.04 | 0.44 | 03-48500 | 140928 | 321117 | 2011-03-17 00:00:00 | 321117
 | 1610013 Total |  |  |  |  |  |  |  |  |  |  |  | 2.8 | 0.28 | 3.08
 | Grand Total |  |  |  |  |  |  |  |  |  |  |  | 166.8000000000002 | 16.67999999999998 | 183.48