dear all,
i'd made an error on the batch numbers
revise table
<table border=1><tr><td>batch 403 - ordered 5aug12</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>1.35</TD><TD></TD><TD> </TD></TR><TR><TD>NAME</TD><TD>ITEMS</TD><TD></TD><TD>COLOUR</TD><TD>SIZE</TD><TD>QTY</TD><TD>Price Usd</TD><TD>Disc price</TD><TD>15% charge</TD><TD>Price SGD</TD><TD>Total</TD><TD>payment status </TD></TR><TR><TD>jane yap</TD><TD>leather inlay belt</TD><TD></TD><TD>black</TD><TD>30</TD><TD>1</TD><TD>48</TD><TD></TD><TD>7.2</TD><TD>74.52</TD><TD>74.52</TD><TD>paid 66.35/3aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>win_mum</TD><TD>roll up short</TD><TD></TD><TD>frost grey</TD><TD>0</TD><TD>1</TD><TD>29</TD><TD></TD><TD>4.35</TD><TD>45.02</TD><TD>45.02</TD><TD>paid 45.02/4aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>rhebeka</TD><TD>embellished cluster logo t-shirt</TD><TD></TD><TD>black</TD><TD>xs</TD><TD>1</TD><TD>38</TD><TD></TD><TD>5.7</TD><TD>59</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>sequin wing t-shirt</TD><TD></TD><TD>violet blue</TD><TD>s</TD><TD>1</TD><TD>29</TD><TD></TD><TD>4.35</TD><TD>45.02</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>rhinestone stud t-shirt</TD><TD></TD><TD>black</TD><TD>s</TD><TD>1</TD><TD>25</TD><TD></TD><TD>3.75</TD><TD>38.81</TD><TD>142.83</TD><TD>paid 153.70/5aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>stahn</TD><TD>allover foil logo tee</TD><TD></TD><TD>true navy</TD><TD>xs</TD><TD>1</TD><TD>38</TD><TD></TD><TD>5.7</TD><TD>59</TD><TD>59</TD><TD>paid 60/4aug </TD></TR><TR><TD> </TD></TR><TR><TD> </TD></TR><TR><TD>Batch 404/405 - ordered7aug12</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>30%</TD><TD></TD><TD>1.35</TD><TD></TD><TD> </TD></TR><TR><TD>NAME</TD><TD>ITEMS</TD><TD></TD><TD>COLOUR</TD><TD>SIZE</TD><TD>QTY</TD><TD>Price Usd</TD><TD>Disc price</TD><TD>15% charge</TD><TD>Price SGD</TD><TD>Total</TD><TD>payment status </TD></TR><TR><TD>mamapotamus</TD><TD>Gathered Mini Dress</TD><TD></TD><TD>fog</TD><TD>p0</TD><TD>1</TD><TD>99</TD><TD>69.3</TD><TD>10.4</TD><TD>107.59</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Belted Swing Dress</TD><TD></TD><TD>pink</TD><TD>p0</TD><TD>1</TD><TD>79</TD><TD>55.3</TD><TD>8.3</TD><TD>85.85</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Sleeveless Flare Dress</TD><TD></TD><TD>white</TD><TD>p0</TD><TD>1</TD><TD>79</TD><TD>55.3</TD><TD>8.3</TD><TD>85.85</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>One Shoulder Rouched Dress</TD><TD></TD><TD>black</TD><TD>p0</TD><TD>1</TD><TD>79</TD><TD>55.3</TD><TD>8.3</TD><TD>85.85</TD><TD>365.14</TD><TD>paid 365.20/7aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>moo</TD><TD>STRIPED CARPENTER SHORT</TD><TD></TD><TD>midnight</TD><TD>34</TD><TD>1</TD><TD>29</TD><TD>20.3</TD><TD>3.05</TD><TD>31.52</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Rhinestone stud t-shirt</TD><TD></TD><TD>black</TD><TD>s</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD>58.71</TD><TD>paid 27.17+31.52/07aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>shernice</TD><TD>Circle Stud Tank</TD><TD></TD><TD>white</TD><TD>m</TD><TD>1</TD><TD>19</TD><TD>13.3</TD><TD>2</TD><TD>20.65</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Short Sleeve Jacquard Hoody</TD><TD></TD><TD>black</TD><TD>m</TD><TD>1</TD><TD>59</TD><TD>41.3</TD><TD>6.2</TD><TD>64.12</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Rhinestone Stud T-Shirt</TD><TD></TD><TD>black</TD><TD>s</TD><TD></TD><TD>OOS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Neon Trim Logo Tee</TD><TD></TD><TD>white</TD><TD>xxl</TD><TD>1</TD><TD>19</TD><TD>13.3</TD><TD>2</TD><TD>20.65</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>A|X Blur T-Shirt</TD><TD></TD><TD>white</TD><TD>large</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD>132.61</TD><TD>paid 200/07aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>t00t</TD><TD>Scattered Logo Tee</TD><TD></TD><TD>grey</TD><TD>s</TD><TD></TD><TD>oos</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>A|X Logo Slubby Polo</TD><TD></TD><TD>black</TD><TD>s</TD><TD>1</TD><TD>29</TD><TD>20.3</TD><TD>3.05</TD><TD>31.52</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Short Sleeve Logo Placket Shirt </TD><TD></TD><TD>stoplight</TD><TD>s</TD><TD></TD><TD>OOS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Box Logo Card Case</TD><TD></TD><TD>black</TD><TD>1sz</TD><TD>1</TD><TD>19</TD><TD>13.3</TD><TD>2</TD><TD>20.65</TD><TD>52.17</TD><TD>paid 135.84/6aug </TD></TR><TR><TD></TD><TD>Neon Trim Logo Tee</TD><TD></TD><TD>black</TD><TD>s</TD><TD></TD><TD>OOS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>Sl_camel</TD><TD>SCATTERED LOGO TEE</TD><TD></TD><TD>white</TD><TD>xs</TD><TD>1</TD><TD>OOS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Rhinestone stud t-shirt</TD><TD></TD><TD>black</TD><TD>s</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD>27.19</TD><TD>paid 20.65+27.17/7aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>connie</TD><TD>embellished a/x palm t-shirt</TD><TD></TD><TD>black</TD><TD>large</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>studded eagle graphic t-shirt</TD><TD></TD><TD>black</TD><TD>large</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>classic logo satchel</TD><TD></TD><TD>phantom</TD><TD>1sz</TD><TD>1</TD><TD>59</TD><TD>41.3</TD><TD>6.2</TD><TD>64.12</TD><TD>118.5</TD><TD>paid118.47/7aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>everclear</TD><TD>Circle Stud Tank</TD><TD></TD><TD>black</TD><TD>xs</TD><TD></TD><TD>OOS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Feather A|X Crest T-Shirt</TD><TD></TD><TD>black</TD><TD>xs</TD><TD>1</TD><TD>19</TD><TD>13.3</TD><TD>2</TD><TD>20.65</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Sequined Ikat Print Tank</TD><TD></TD><TD>sand</TD><TD>xs</TD><TD>1</TD><TD>29</TD><TD>20.3</TD><TD>3.05</TD><TD>31.52</TD><TD>52.17</TD><TD>paid72.81/7aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>sweetieminnie</TD><TD>sunset logo tee</TD><TD></TD><TD>black</TD><TD>xs</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD>27.19</TD><TD>paid 27.17/7aug </TD></TR><TR><TD> </TD></TR><TR><TD> </TD></TR><TR><TD>Batch 406/407 - ordered 8aug12</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>30%</TD><TD></TD><TD>1.35</TD><TD></TD><TD> </TD></TR><TR><TD>NAME</TD><TD>ITEMS</TD><TD></TD><TD>COLOUR</TD><TD>SIZE</TD><TD>QTY</TD><TD>Price Usd</TD><TD>Disc price</TD><TD>15% charge</TD><TD>Price SGD</TD><TD>Total</TD><TD>payment status </TD></TR><TR><TD>jamesbond</TD><TD>A|X 91 Tee</TD><TD></TD><TD>black</TD><TD>m</TD><TD>1</TD><TD>19</TD><TD>13.3</TD><TD>2</TD><TD>20.65</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Sliced Logo T-Shirt</TD><TD></TD><TD>grey</TD><TD>m</TD><TD></TD><TD>OOS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>paid 31.52+20.65/7aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>laila</TD><TD>Stripe Collar Polo</TD><TD></TD><TD>white</TD><TD>s</TD><TD>1</TD><TD>39</TD><TD>27.3</TD><TD>4.1</TD><TD>42.38</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>A|X 91 Tee</TD><TD></TD><TD>black</TD><TD>s</TD><TD>1</TD><TD>19</TD><TD>13.3</TD><TD>2</TD><TD>20.65</TD><TD></TD><TD>paid 63.03/7aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>karenz</TD><TD>Flocked Logo T-Shirt</TD><TD></TD><TD>black</TD><TD>xs</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>A|X 91 Tee</TD><TD></TD><TD>white</TD><TD>xs</TD><TD>1</TD><TD>19</TD><TD>13.3</TD><TD>2</TD><TD>20.65</TD><TD></TD><TD>paid 75/7aug </TD></TR><TR><TD></TD><TD>Basic A|X Tee</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>oos</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>shernice</TD><TD>Sequin Stacked T-Shirt</TD><TD></TD><TD>black</TD><TD>large</TD><TD>1</TD><TD>29</TD><TD>20.3</TD><TD>3.05</TD><TD>31.52</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Feather A|X Crest T-Shirt</TD><TD></TD><TD>violet blue</TD><TD>large</TD><TD>1</TD><TD>19</TD><TD>13.3</TD><TD>2</TD><TD>20.65</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Short Sleeve Logo Utility Shirt</TD><TD></TD><TD>orange</TD><TD>xs</TD><TD>1</TD><TD>29</TD><TD>20.3</TD><TD>3.05</TD><TD>31.52</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>A|X Logo Slubby Polo</TD><TD></TD><TD>black</TD><TD>xs</TD><TD>1</TD><TD>29</TD><TD>20.3</TD><TD>3.05</TD><TD>31.52</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>A|X Logo Slubby Polo</TD><TD></TD><TD>black</TD><TD>m</TD><TD>2</TD><TD>58</TD><TD>40.6</TD><TD>6.09</TD><TD>63.03</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>A|X 91 Tee</TD><TD></TD><TD>black</TD><TD>m</TD><TD>2</TD><TD>38</TD><TD>26.6</TD><TD>4</TD><TD>41.3</TD><TD>219.54</TD><TD>paid 250/7aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>blueblue</TD><TD>PAPER TOUCH UTILITY SHORT</TD><TD></TD><TD>white</TD><TD>28</TD><TD>1</TD><TD>39</TD><TD>27.3</TD><TD>4.1</TD><TD>42.38</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>PAPER TOUCH UTILITY SHORT</TD><TD></TD><TD>white</TD><TD>32</TD><TD></TD><TD>OOS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>SHORT SLEEVE LOGO UTILITY SHIRT</TD><TD></TD><TD>neon</TD><TD>xs</TD><TD>1</TD><TD>49</TD><TD>34.3</TD><TD>5.15</TD><TD>53.25</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>SHORT SLEEVE LOGO UTILITY SHIRT</TD><TD></TD><TD>neon</TD><TD>m</TD><TD>1</TD><TD>49</TD><TD>34.3</TD><TD>5.15</TD><TD>53.25</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>SHORT SLEEVE LOGO UTILITY SHIRT</TD><TD></TD><TD>white</TD><TD>m</TD><TD>1</TD><TD>49</TD><TD>34.3</TD><TD>5.15</TD><TD>53.25</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>POP STRIPE POLO</TD><TD></TD><TD>neon</TD><TD>xs</TD><TD>1</TD><TD>39</TD><TD>27.3</TD><TD>4.1</TD><TD>42.38</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>POP STRIPE POLO</TD><TD></TD><TD>neon</TD><TD>XS</TD><TD>1</TD><TD>39</TD><TD>27.3</TD><TD>4.1</TD><TD>42.38</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>NEON TRIM LOGO TEE</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>oos</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>BLOCK LOGO T-SHIRT</TD><TD></TD><TD>white</TD><TD>s</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>BLOCK LOGO T-SHIRT</TD><TD></TD><TD>white</TD><TD>xs</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>ASYMMETRICAL DRAPE VEST</TD><TD></TD><TD>black</TD><TD>xs</TD><TD>1</TD><TD>39</TD><TD>27.3</TD><TD>4.1</TD><TD>42.38</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>RUFFLE STRAP DRAPED TANK</TD><TD></TD><TD>pink opal</TD><TD>xs</TD><TD>1</TD><TD>29</TD><TD>20.3</TD><TD>3.05</TD><TD>31.52</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>TRAPEZE TOP</TD><TD></TD><TD>violet blue</TD><TD>xs</TD><TD>1</TD><TD>39</TD><TD>27.3</TD><TD>4.1</TD><TD>42.38</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>RHINESTONE STUD T-SHIRT</TD><TD></TD><TD>black</TD><TD>s</TD><TD></TD><TD>OOS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>SKREETCH LOGO T-SHIRT</TD><TD></TD><TD>black</TD><TD>m</TD><TD></TD><TD>OOS</TD><TD></TD><TD></TD><TD></TD><TD>457.55</TD><TD>paid 553.20/7aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>gen's fren</TD><TD>J22 stretch legging jean</TD><TD></TD><TD>indigo</TD><TD>8</TD><TD>1</TD><TD>59</TD><TD>41.3</TD><TD>6.2</TD><TD>64.12</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Rhinestone stud t-shirt</TD><TD></TD><TD>black</TD><TD>m</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>camp ax t-shirt</TD><TD></TD><TD>white</TD><TD>m</TD><TD>1</TD><TD>19</TD><TD>13.3</TD><TD>2</TD><TD>20.65</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>block logo t-shirt</TD><TD></TD><TD>black</TD><TD>m</TD><TD>1</TD><TD>25</TD><TD>17.5</TD><TD>2.63</TD><TD>27.19</TD><TD>139.15</TD><TD>paid 139.15/13aug </TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD> </TD></TR><TR><TD>gen goh</TD><TD>ruffled zip front top</TD><TD></TD><TD>dove</TD><TD>s</TD><TD>1</TD><TD>29</TD><TD>20.3</TD><TD>3.05</TD><TD>31.52</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>Sequined Ikat Print Tank</TD><TD></TD><TD>pink opal</TD><TD>s</TD><TD>1</TD><TD>29</TD><TD>20.3</TD><TD>3.05</TD><TD>31.52</TD><TD></TD><TD> </TD></TR><TR><TD></TD><TD>chiffon flow jacket</TD><TD></TD><TD>fog</TD><TD>s</TD><TD>1</TD><TD>49</TD><TD>34.3</TD><TD>5.15</TD><TD>53.25</TD><TD>116.29</TD><TD>paid 125.25/13aug (116.29+8.96) </TD></TR><TR><TD></td></tr></table>