com_product_stock_tally
| # | id | userid | product_id | total_quantity | rcvd_qty | order_rcvd_qty | Order_app_qty | actual_stock_need |
|---|---|---|---|---|---|---|---|---|
| 901 | 1029 | 12855 | 3 | 4 | 5 | 5 | 1 | 4 |
| 902 | 1030 | 12855 | 4 | 4 | 5 | 5 | 1 | 4 |
| 903 | 1031 | 12855 | 7 | 9 | 10 | 10 | 0 | 10 |
| 904 | 1032 | 12554 | 42 | 0 | 14 | 14 | 14 | 0 |
| 905 | 1033 | 12554 | 11 | 42 | 53 | 53 | 11 | 42 |
| 906 | 1034 | 12555 | 49 | 0 | 10 | 10 | 7 | 3 |
| 907 | 1035 | 12555 | 42 | 10 | 14 | 14 | 0 | 14 |
| 908 | 1036 | 12555 | 11 | 8 | 11 | 11 | 2 | 9 |
| 909 | 1037 | 12527 | 46 | 33 | 47 | 47 | 14 | 33 |
| 910 | 1038 | 12554 | 10 | 1 | 50 | 50 | 49 | 1 |
| 911 | 1039 | 12555 | 12 | 2 | 20 | 20 | 16 | 4 |
| 912 | 1040 | 12555 | 10 | 23 | 40 | 40 | 16 | 24 |
| 913 | 1041 | 12555 | 60 | 5 | 10 | 10 | 1 | 9 |
| 914 | 1042 | 12855 | 29 | 3 | 3 | 3 | 0 | 3 |
| 915 | 1043 | 12855 | 34 | 13 | 28 | 28 | 3 | 25 |
| 916 | 1044 | 12855 | 33 | 45 | 62 | 62 | 1 | 61 |
| 917 | 1045 | 12554 | 71 | 0 | 4 | 4 | 4 | 0 |
| 918 | 1046 | 12555 | 71 | 1 | 4 | 4 | 1 | 3 |
| 919 | 1047 | 12555 | 61 | 7 | 2483 | 2483 | 2305 | 178 |
| 920 | 1048 | 12555 | 2 | 79 | 115 | 115 | 32 | 83 |
| 921 | 1049 | 12855 | 1 | 5 | 6 | 6 | 1 | 5 |
| 922 | 1050 | 12551 | 41 | 0 | 2 | 2 | 2 | 0 |
| 923 | 1051 | 12551 | 47 | 0 | 3 | 3 | 3 | 0 |
| 924 | 1052 | 12551 | 43 | 0 | 10 | 10 | 10 | 0 |
| 925 | 1053 | 12551 | 50 | 0 | 2 | 2 | 2 | 0 |
| 926 | 1054 | 12551 | 76 | 0 | 3 | 3 | 3 | 0 |
| 927 | 1055 | 12516 | 81 | 39 | 360 | 360 | 311 | 49 |
| 928 | 1056 | 12554 | 81 | 67 | 100 | 90 | 33 | 57 |
| 929 | 1057 | 12555 | 81 | 17 | 30 | 30 | 10 | 20 |
| 930 | 1058 | 12855 | 41 | 0 | 2 | 2 | 0 | 2 |
| 931 | 1059 | 12855 | 47 | 0 | 3 | 3 | 0 | 3 |
| 932 | 1060 | 12855 | 43 | 0 | 10 | 10 | 0 | 10 |
| 933 | 1061 | 12855 | 46 | 0 | 4 | 4 | 2 | 2 |
| 934 | 1062 | 12855 | 35 | 2 | 9 | 9 | 1 | 8 |
| 935 | 1063 | 12855 | 50 | 0 | 2 | 2 | 0 | 2 |
| 936 | 1064 | 12855 | 44 | 0 | 3 | 3 | 0 | 3 |
| 937 | 1065 | 12855 | 76 | 3 | 3 | 3 | 0 | 3 |
| 938 | 1066 | 12855 | 6 | 2 | 2 | 2 | 0 | 2 |
| 939 | 1067 | 12855 | 71 | 2 | 2 | 2 | 0 | 2 |
| 940 | 1068 | 12855 | 58 | 11 | 11 | 11 | 0 | 11 |
| 941 | 1069 | 12855 | 55 | 20 | 20 | 20 | 0 | 20 |
| 942 | 1070 | 12855 | 56 | 19 | 20 | 20 | 1 | 19 |
| 943 | 1071 | 12855 | 57 | 20 | 21 | 21 | 0 | 21 |
| 944 | 1072 | 12855 | 54 | 49 | 50 | 50 | 1 | 49 |
| 945 | 1073 | 12555 | 31 | 13 | 20 | 10 | 6 | 4 |
| 946 | 1074 | 12555 | 5 | 38 | 110 | 110 | 71 | 39 |
| 947 | 1075 | 12516 | 62 | 4 | 286 | 286 | 282 | 4 |
| 948 | 1076 | 12516 | 63 | 0 | 65 | 65 | 65 | 0 |
| 949 | 1077 | 12554 | 62 | 5 | 270 | 270 | 265 | 5 |
| 950 | 1078 | 12554 | 63 | 19 | 60 | 60 | 41 | 19 |