com_product_stock_tally
| # | id | userid | product_id | total_quantity | rcvd_qty | order_rcvd_qty | Order_app_qty | actual_stock_need |
|---|---|---|---|---|---|---|---|---|
| 1101 | 1231 | 14079 | 30 | 0 | 1 | 1 | 1 | 0 |
| 1102 | 1232 | 14079 | 32 | 0 | 28 | 28 | 28 | 0 |
| 1103 | 1233 | 14079 | 26 | 0 | 1 | 1 | 1 | 0 |
| 1104 | 1234 | 14079 | 50 | 0 | 1 | 1 | 1 | 0 |
| 1105 | 1235 | 12538 | 84 | 0 | 1 | 1 | 1 | 0 |
| 1106 | 1236 | 12532 | 18 | 2 | 3 | 3 | 1 | 2 |
| 1107 | 1237 | 12532 | 79 | 1 | 1 | 1 | 0 | 1 |
| 1108 | 1238 | 13536 | 84 | 0 | 9 | 9 | 9 | 0 |
| 1109 | 1239 | 13536 | 37 | 0 | 13 | 13 | 13 | 0 |
| 1110 | 1240 | 13536 | 32 | 0 | 49 | 49 | 49 | 0 |
| 1111 | 1241 | 13536 | 35 | 0 | 18 | 18 | 18 | 0 |
| 1112 | 1242 | 13536 | 36 | 0 | 13 | 13 | 13 | 0 |
| 1113 | 1243 | 12532 | 82 | 3 | 6 | 6 | 3 | 3 |
| 1114 | 1244 | 13438 | 19 | 0 | 1 | 1 | 1 | 0 |
| 1115 | 1245 | 13438 | 84 | 0 | 3 | 3 | 3 | 0 |
| 1116 | 1246 | 12520 | 27 | 0 | 2 | 2 | 2 | 0 |
| 1117 | 1247 | 12520 | 31 | 0 | 1 | 1 | 1 | 0 |
| 1118 | 1248 | 12520 | 38 | 5 | 5 | 5 | 0 | 5 |
| 1119 | 1249 | 12520 | 37 | 5 | 5 | 5 | 0 | 5 |
| 1120 | 1250 | 12520 | 28 | 0 | 2 | 2 | 2 | 0 |
| 1121 | 1251 | 12520 | 46 | 10 | 10 | 10 | 0 | 10 |
| 1122 | 1252 | 12520 | 36 | 10 | 10 | 10 | 0 | 10 |
| 1123 | 1253 | 12532 | 84 | 0 | 4 | 3 | 4 | -1 |
| 1124 | 1254 | 12529 | 48 | 0 | 4 | 4 | 4 | 0 |
| 1125 | 1255 | 12529 | 84 | 0 | 9 | 9 | 9 | 0 |
| 1126 | 1256 | 12529 | 38 | 0 | 2 | 2 | 2 | 0 |
| 1127 | 1257 | 12529 | 39 | 0 | 2 | 2 | 2 | 0 |
| 1128 | 1258 | 12529 | 37 | 2 | 6 | 6 | 4 | 2 |
| 1129 | 1259 | 12529 | 33 | 0 | 3 | 3 | 3 | 0 |
| 1130 | 1260 | 12529 | 34 | 0 | 6 | 6 | 6 | 0 |
| 1131 | 1261 | 12529 | 15 | 0 | 1 | 1 | 1 | 0 |
| 1132 | 1262 | 12529 | 16 | 0 | 1 | 1 | 1 | 0 |
| 1133 | 1263 | 12529 | 7 | 0 | 6 | 6 | 6 | 0 |
| 1134 | 1264 | 12529 | 10 | 0 | 1 | 1 | 1 | 0 |
| 1135 | 1265 | 12529 | 50 | 0 | 1 | 1 | 1 | 0 |
| 1136 | 1266 | 12552 | 43 | 0 | 3 | 3 | 3 | 0 |
| 1137 | 1267 | 12552 | 46 | 0 | 13 | 13 | 13 | 0 |
| 1138 | 1268 | 12552 | 1 | 0 | 1 | 1 | 1 | 0 |
| 1139 | 1269 | 13438 | 12 | 1 | 8 | 8 | 7 | 1 |
| 1140 | 1270 | 14323 | 48 | 5 | 7 | 7 | 2 | 5 |
| 1141 | 1271 | 14323 | 38 | 46 | 50 | 50 | 4 | 46 |
| 1142 | 1272 | 14323 | 37 | 43 | 50 | 50 | 7 | 43 |
| 1143 | 1273 | 14323 | 60 | 2 | 2 | 2 | 0 | 2 |
| 1144 | 1274 | 14323 | 33 | 83 | 100 | 100 | 17 | 83 |
| 1145 | 1275 | 14323 | 34 | 41 | 48 | 48 | 7 | 41 |
| 1146 | 1276 | 14323 | 7 | 7 | 10 | 10 | 3 | 7 |
| 1147 | 1277 | 14323 | 32 | 78 | 100 | 100 | 22 | 78 |
| 1148 | 1278 | 14323 | 72 | 2 | 2 | 2 | 0 | 2 |
| 1149 | 1279 | 14323 | 46 | 5 | 10 | 10 | 5 | 5 |
| 1150 | 1280 | 14323 | 35 | 9 | 15 | 15 | 6 | 9 |