The stock works as 'First in First out' . When all locations are selected, regardless of specific location stock-in and stock-out : the logic starts reducing off from the older stock.
Scenario:
| Location | Item Code | Stock in | Stock in | Stock in | Stock out | Balance |
|
| Aug (4months until now) | Sep (3months until now) | Oct (2months until now) | until Dec | Dec (current) |
|
|
|
|
|
|
| | locationA | item1 | 4 | 1 | 0 | 0 | 5 | | locationB | item1 | 0 | 0 | 2 | -2 | 0 |
Now, if we try to generate the report for all branches, the result is something like this:
| Location | Item Code | 4 months old | 3 months old | 2 months old |
| Balance | | All location | item1 | 2 | 1 | 2 |
| 5 |
If we chose only location A (No stock-out):
| Location | Item Code | 4 months old | 3 months old | 2 months old |
| Balance | | locationA | item1 | 4 | 1 | 0 |
| 5
|
If we chose only location B (stock-in and stock-out balanced out):
| Location | Item Code | 4 months old | 3 months old | 2 months old |
| Balance | | locationB | item1 | - | - | - |
| -
|
|
|
