com_product_stock_tally
| # | id | userid | product_id | total_quantity | rcvd_qty | order_rcvd_qty | Order_app_qty | actual_stock_need |
|---|---|---|---|---|---|---|---|---|
| 1 | 128 | 12516 | 1 | 15 | 681 | 681 | 666 | 15 |
| 2 | 129 | 12516 | 27 | 99 | 414 | 414 | 315 | 99 |
| 3 | 130 | 12554 | 27 | 53 | 158 | 158 | 105 | 53 |
| 4 | 131 | 12555 | 27 | 73 | 105 | 105 | 27 | 78 |
| 5 | 132 | 12516 | 73 | 70 | 152 | 152 | 82 | 70 |
| 6 | 133 | 12517 | 73 | 0 | 3 | 32 | 11 | 21 |
| 7 | 134 | 12518 | 73 | 2 | 2 | 2 | 0 | 2 |
| 8 | 135 | 12516 | 80 | 60 | 116 | 116 | 56 | 60 |
| 9 | 136 | 12554 | 80 | 0 | 51 | 51 | 51 | 0 |
| 10 | 137 | 12555 | 80 | 40 | 51 | 51 | 0 | 51 |
| 11 | 138 | 12516 | 74 | 17 | 372 | 372 | 355 | 17 |
| 12 | 139 | 12517 | 74 | 3 | 49 | 76 | 60 | 16 |
| 13 | 140 | 12526 | 74 | 8 | 8 | 7 | 0 | 7 |
| 14 | 141 | 12526 | 73 | 5 | 5 | 5 | 0 | 5 |
| 15 | 142 | 12557 | 74 | 3 | 3 | 3 | 0 | 3 |
| 16 | 143 | 12516 | 77 | 33 | 114 | 114 | 81 | 33 |
| 17 | 144 | 12516 | 75 | 54 | 104 | 104 | 50 | 54 |
| 18 | 145 | 12517 | 77 | 5 | 13 | 18 | 10 | 8 |
| 19 | 146 | 12517 | 80 | 0 | 2 | 5 | 3 | 2 |
| 20 | 147 | 12542 | 74 | 2 | 2 | 2 | 0 | 2 |
| 21 | 148 | 12544 | 74 | 5 | 5 | 5 | 0 | 5 |
| 22 | 149 | 12546 | 74 | 3 | 3 | 3 | 0 | 3 |
| 23 | 150 | 12552 | 73 | 2 | 3 | 3 | 0 | 3 |
| 24 | 151 | 12532 | 74 | 7 | 7 | 7 | 0 | 7 |
| 25 | 152 | 12534 | 74 | 1 | 1 | 1 | 0 | 1 |
| 26 | 153 | 12529 | 74 | 9 | 9 | 9 | 0 | 9 |
| 27 | 154 | 12552 | 80 | 2 | 3 | 3 | 0 | 3 |
| 28 | 155 | 12552 | 74 | 5 | 13 | 12 | 0 | 12 |
| 29 | 156 | 12529 | 77 | 4 | 4 | 4 | 0 | 4 |
| 30 | 157 | 12516 | 48 | 14 | 503 | 503 | 429 | 74 |
| 31 | 158 | 12516 | 20 | 52 | 420 | 420 | 368 | 52 |
| 32 | 159 | 12516 | 70 | 45 | 108 | 78 | 63 | 15 |
| 33 | 160 | 12516 | 61 | 128 | 2644 | 2644 | 2516 | 128 |
| 34 | 161 | 12516 | 31 | 69 | 199 | 199 | 130 | 69 |
| 35 | 162 | 12516 | 79 | 4 | 58 | 58 | 54 | 4 |
| 36 | 163 | 12516 | 21 | 7 | 15 | 15 | 8 | 7 |
| 37 | 164 | 12516 | 6 | 32 | 219 | 189 | 162 | 27 |
| 38 | 165 | 12516 | 40 | 9 | 145 | 145 | 136 | 9 |
| 39 | 166 | 12516 | 52 | 43 | 378 | 348 | 335 | 13 |
| 40 | 167 | 12516 | 71 | 6 | 20 | 20 | 14 | 6 |
| 41 | 168 | 12516 | 3 | 15 | 391 | 391 | 376 | 15 |
| 42 | 169 | 12516 | 4 | 28 | 770 | 770 | 742 | 28 |
| 43 | 170 | 12516 | 38 | 47 | 1100 | 1100 | 1053 | 47 |
| 44 | 171 | 12516 | 39 | 20 | 1069 | 1069 | 1049 | 20 |
| 45 | 172 | 12516 | 19 | 15 | 342 | 342 | 327 | 15 |
| 46 | 173 | 12516 | 22 | 6 | 14 | 14 | 8 | 6 |
| 47 | 174 | 12516 | 37 | 148 | 1225 | 1225 | 1077 | 148 |
| 48 | 175 | 12516 | 60 | 59 | 248 | 248 | 189 | 59 |
| 49 | 176 | 12516 | 58 | 29 | 179 | 179 | 150 | 29 |
| 50 | 177 | 12516 | 55 | 70 | 213 | 213 | 143 | 70 |