User cases for negative SOH balance
Assumption:
End user is allowed to create a stock line item whose occurred date is a past date;
End user sometimes not record the stock line item orderly, e.g. record the current stock line item and then add back a previous stock line item;
Tradeoff:
Usability > Policy (system build-in rules), meaning OpenLMIS should encourage end users to use our system and input data
Business scenarios:
Example 1: User forgot to make a past-date stock line item
For example, there is a stock card:
Date | Source | Received Quantity | Destination | Issued Quantity | Adjustment Reason | Adjustment Quantity | Stock on Hand |
1 Jan | District1 | 100 | 100 | ||||
2 Jan | Ward1 | 20 | 80 | ||||
4 Jan | District2 | 100 | 180 | ||||
5 Jan | Ward2 | 50 | 130 |
On 6th Jan, the storeroom manager realized that he forgot to record an issue stock line item on 3rd Jan so he adds that stock line item and gives the issue quantity as 100. This issue 100 stock event will pass our current validation rule because we only compare the current stock on hand which is 130 within the stock event quantity which is 100 and 130>100.
Thus, an issue 100 stock event occurred date 3rd Jan will be created and it would impact all following stock line items' stock on hand and the stock card would be updated as below:
Date | Source | Received Quantity | Destination | Issued Quantity | Adjustment Reason | Adjustment Quantity | Stock on Hand |
1 Jan | District1 | 100 | 100 | ||||
2 Jan | Ward1 | 20 | 80 | ||||
3 Jan | Ward1 | 100 | -20 | ||||
4 Jan | District2 | 100 | 80 | ||||
5 Jan | Ward2 | 50 | 30 |
Example 2: User wants to make an issue stock line item although the current stock on hand is 0
Another stock card is like below:
Date | Source | Received Quantity | Destination | Issued Quantity | Adjustment Reason | Adjustment Quantity | Stock on Hand |
1 Jan | District1 | 100 | 100 | ||||
2 Jan | Ward1 | 100 | 0 | ||||
3rd Jan, storeroom manager A received 50 quantity from district 2 but he did not have time to record it. Thus, the real SOH is 50 instead of 0.
4th Jan, storeroom manager B started to work and he wanted to issue 30 quantity to a patient because he had 50 quantity of this orderable. Thus, he needed to create an issue stock line item to record this 30 quantity issue although the SOH in the system was 0.
The stock card might be updated as below:
Date | Source | Received Quantity | Destination | Issued Quantity | Adjustment Reason | Adjustment Quantity | Stock on Hand |
1 Jan | District1 | 100 | 100 | ||||
2 Jan | Ward1 | 100 | 0 | ||||
4 Jan | Ward1 | 30 | -30 | ||||
5th Jan, storeroom manager A realized that he forgot to make the receive stock line item happened on 3rd Jan so he added that stock line item back.
The stock card updated as below:
Date | Source | Received Quantity | Destination | Issued Quantity | Adjustment Reason | Adjustment Quantity | Stock on Hand |
1 Jan | District1 | 100 | 100 | ||||
2 Jan | Ward1 | 100 | 0 | ||||
3 Jan | District1 | 50 | 50 | ||||
4 Jan | Ward1 | 30 | 20 |
OpenLMIS: the global initiative for powerful LMIS software