com_product_stock_tally
| # | id | userid | product_id | total_quantity | rcvd_qty | order_rcvd_qty | Order_app_qty | actual_stock_need |
|---|---|---|---|---|---|---|---|---|
| 1001 | 1130 | 12516 | 66 | 0 | 1 | 1 | 1 | 0 |
| 1002 | 1131 | 12554 | 66 | 0 | 1 | 1 | 1 | 0 |
| 1003 | 1132 | 12555 | 66 | 0 | 1 | 1 | 1 | 0 |
| 1004 | 1133 | 12555 | 55 | 9 | 10 | 10 | 1 | 9 |
| 1005 | 1134 | 12545 | 46 | 0 | 27 | 27 | 27 | 0 |
| 1006 | 1135 | 12545 | 33 | 0 | 50 | 50 | 50 | 0 |
| 1007 | 1136 | 12545 | 34 | 0 | 36 | 36 | 36 | 0 |
| 1008 | 1137 | 12545 | 7 | 0 | 16 | 16 | 16 | 0 |
| 1009 | 1138 | 12545 | 32 | 10 | 165 | 165 | 155 | 10 |
| 1010 | 1139 | 12517 | 81 | 175 | 221 | 221 | 42 | 179 |
| 1011 | 1140 | 12549 | 39 | 0 | 4 | 4 | 4 | 0 |
| 1012 | 1141 | 12549 | 37 | 0 | 10 | 10 | 10 | 0 |
| 1013 | 1142 | 12549 | 34 | 0 | 15 | 15 | 15 | 0 |
| 1014 | 1143 | 12549 | 17 | 0 | 2 | 2 | 2 | 0 |
| 1015 | 1144 | 12549 | 81 | 0 | 1 | 1 | 1 | 0 |
| 1016 | 1145 | 12549 | 26 | 0 | 5 | 5 | 5 | 0 |
| 1017 | 1146 | 12549 | 47 | 0 | 1 | 1 | 1 | 0 |
| 1018 | 1147 | 12518 | 52 | 0 | 2 | 1 | 2 | -1 |
| 1019 | 1148 | 12518 | 16 | 0 | 4 | 2 | 4 | -2 |
| 1020 | 1149 | 12518 | 47 | 2 | 10 | 5 | 8 | -3 |
| 1021 | 1150 | 12518 | 53 | 0 | 2 | 1 | 2 | -1 |
| 1022 | 1151 | 12548 | 27 | 1 | 1 | 1 | 0 | 1 |
| 1023 | 1152 | 12548 | 15 | 2 | 10 | 10 | 8 | 2 |
| 1024 | 1153 | 12548 | 17 | 1 | 1 | 1 | 0 | 1 |
| 1025 | 1154 | 12685 | 31 | 2 | 3 | 3 | 1 | 2 |
| 1026 | 1155 | 12685 | 19 | 0 | 1 | 1 | 1 | 0 |
| 1027 | 1156 | 12685 | 15 | 1 | 1 | 1 | 0 | 1 |
| 1028 | 1157 | 12685 | 47 | 5 | 5 | 5 | 0 | 5 |
| 1029 | 1158 | 12685 | 26 | 6 | 6 | 6 | 0 | 6 |
| 1030 | 1159 | 12547 | 33 | 1 | 28 | 28 | 27 | 1 |
| 1031 | 1160 | 12547 | 15 | 0 | 4 | 4 | 4 | 0 |
| 1032 | 1161 | 12547 | 32 | 10 | 131 | 131 | 121 | 10 |
| 1033 | 1162 | 12547 | 1 | 0 | 2 | 2 | 2 | 0 |
| 1034 | 1163 | 12549 | 20 | 0 | 1 | 1 | 1 | 0 |
| 1035 | 1164 | 12549 | 7 | 0 | 5 | 5 | 5 | 0 |
| 1036 | 1165 | 12549 | 46 | 0 | 5 | 5 | 5 | 0 |
| 1037 | 1166 | 12552 | 9 | 0 | 4 | 4 | 4 | 0 |
| 1038 | 1167 | 12552 | 12 | 0 | 3 | 3 | 3 | 0 |
| 1039 | 1168 | 12549 | 19 | 0 | 1 | 1 | 1 | 0 |
| 1040 | 1169 | 12549 | 33 | 0 | 12 | 12 | 12 | 0 |
| 1041 | 1170 | 12549 | 15 | 0 | 1 | 1 | 1 | 0 |
| 1042 | 1171 | 12549 | 41 | 0 | 3 | 3 | 3 | 0 |
| 1043 | 1172 | 12549 | 50 | 0 | 3 | 3 | 3 | 0 |
| 1044 | 1173 | 12543 | 46 | 1 | 3 | 3 | 2 | 1 |
| 1045 | 1175 | 12516 | 84 | 0 | 53 | 53 | 53 | 0 |
| 1046 | 1176 | 12517 | 82 | 187 | 220 | 220 | 33 | 187 |
| 1047 | 1177 | 12517 | 84 | 0 | 38 | 38 | 37 | 1 |
| 1048 | 1178 | 12517 | 68 | 7 | 8 | 8 | 1 | 7 |
| 1049 | 1179 | 12549 | 48 | 0 | 4 | 4 | 4 | 0 |
| 1050 | 1180 | 12549 | 32 | 0 | 3 | 3 | 3 | 0 |