Hi all,
We have been having issues long ago with Batches and this is all due to POS … we have managed to fix some by not allowing ZERO sells but only for Items with One batch.
For example i have this item A that we bought 80 qty. We sold 16 remaining 64 but due to some delays on submitting the POS (other item had no enough stock) the created a problem on the records so we have decided to duplicate the Item and add the 64 left on Stock.
The item was sold 22 times from the 64 in stock remained 41 and on the Stock Ledger you confirm.
But when another sell was done and again because not enough Stock for this other item the records for this item A on Balance went to 2 and the next one 4,5,6,etc …As you can see on the screen below.
My question is where is the system taking this Balance if the last record the left balance was 41 ?
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit 64 64 0 821.19 52556.16 Stock Entry STE-00035 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 63 0 0 0 Sales Invoice SINV-18743/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 62 0 821.19 50913.78 Sales Invoice SINV-18929/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 61 0 0 0 Sales Invoice SINV-19135/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 60 0 821.19 49271.4 Sales Invoice SINV-23033/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 59 0 0 0 Sales Invoice SINV-26330/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 58 0 821.19 47629.02 Sales Invoice SINV-27935/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 57 0 0 0 Sales Invoice SINV-32622/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 56 0 821.19 45986.64 Sales Invoice SINV-32654/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -2 54 0 0 0 Sales Invoice SINV-32658/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 53 0 821.19 43523.07 Sales Invoice SINV-33082/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -2 51 0 0 0 Sales Invoice SINV-33180/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 50 0 821.19 41059.5 Sales Invoice SINV-33496/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 49 0 0 0 Sales Invoice SINV-34577/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 48 0 821.19 39417.12 Sales Invoice SINV-35219/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 47 0 0 0 Sales Invoice SINV-36498/17 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 46 0 821.19 37774.74 Sales Invoice SINV-18/00547 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 45 0 0 0 Sales Invoice SINV-18/00624 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 44 0 821.19 36132.36 Sales Invoice SINV-18/00847 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 43 0 0 0 Sales Invoice SINV-18/02276 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 42 0 821.19 34489.98 Sales Invoice SINV-18/04920 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 41 0 0 0 Sales Invoice SINV-18/05439 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -2 2 0 821.19 1642.38 Sales Invoice SINV-18/08137 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 4 0 821.19 3284.76 Sales Invoice SINV-18/09502 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 5 0 821.19 4105.95 Sales Invoice SINV-18/09743 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -2 6 0 821.19 4927.14 Sales Invoice SINV-18/10358 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 8 0 821.19 6569.52 Sales Invoice SINV-18/10808 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 9 0 821.19 7390.71 Sales Invoice SINV-18/11422 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -2 10 0 821.19 8211.9 Sales Invoice SINV-18/12589 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -2 12 0 821.19 9854.28 Sales Invoice SINV-18/13363 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 14 0 821.19 11496.66 Sales Invoice SINV-18/13935 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 15 0 821.19 12317.85 Sales Invoice SINV-18/13955 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 16 0 821.19 13139.04 Sales Invoice SINV-18/16369 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 17 0 821.19 13960.23 Sales Invoice SINV-18/16370 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 18 0 821.19 14781.42 Sales Invoice SINV-18/17381 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 19 0 821.19 15602.61 Sales Invoice SINV-18/18809 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 20 0 821.19 16423.8 Sales Invoice SINV-18/18828 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 21 0 821.19 17244.99 Sales Invoice SINV-18/21343 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 22 0 821.19 18066.18 Sales Invoice SINV-18/21429 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -3 23 0 821.19 18887.37 Stock Entry STE-00443 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 26 0 821.19 21350.94 Sales Invoice SINV-18/22296 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 27 0 821.19 22172.13 Sales Invoice SINV-18/22400 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 28 0 821.19 22993.32 Sales Invoice SINV-18/22975 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 29 0 821.19 23814.51 Sales Invoice SINV-18/23249 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 30 0 821.19 24635.7 Sales Invoice SINV-18/23331 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 31 0 821.19 25456.89 Sales Invoice SINV-18/23336 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 32 0 821.19 26278.08 Sales Invoice SINV-18/23765 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -2 33 0 821.19 27099.27 Sales Invoice SINV-18/25158 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 35 0 821.19 28741.65 Sales Invoice SINV-18/25266 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 36 0 821.19 29562.84 Sales Invoice SINV-18/25820 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 37 0 821.19 30384.03 Sales Invoice SINV-18/25958 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 38 0 821.19 31205.22 Sales Invoice SINV-18/26005 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 39 0 821.19 32026.41 Sales Invoice SINV-18/26041 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 40 0 821.19 32847.6 Sales Invoice SINV-18/26205 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 39 0 0 0 Sales Invoice SINV-18/29939 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 38 0 821.19 31205.22 Sales Invoice SINV-18/30696 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit -1 38 0 821.19 31205.22 Sales Invoice SINV-18/30796 o897
5602125200171 Lauroderme Sabonete Savon Ph 6.0 100G Sabonetes Lauroderme Sabonete Savon Ph 6.0 100G Loja - FX Unit 1 39 0 0 0 Stock Entry STE-00656 o897
Now we have on the item this
While on the Batch
How to fix the Stock which is ZERO