...
| Tester | Log in | Program | Columns Included (specify user input/calculations) | Displayed in Template | Hidden in Template | Product Grid Validation | Issues/Bugs Identified | Notes | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CL | srmanager2 | Essential meds | Skip Product name Beg. balance - user input Total received qty - user input Total adj. total stockout days - user input Stock on hand - user input total consumed qty - user input adjusted consumption - calculated Price per pack Unit of issue Packs to ship - calculated No. of new pts. Requested qty. Req. qty. explanation | Product code Calculated order qty Average consumption Max stock | Field is required SOH - inputted value must match calculated value Total consumed qty. - inputted value must match calculated value Adjustment qty. - field is required after entering 1 adjustment* R&R has errors, please correct them to proceed |
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| srmanager1 | Family Planning | product beg balance- user input total received qty - user input total consumed qty - calculated total stockout days - user input soh - user input avg consumption - calculated calc order qty - calculated requested qty - user input requested qty explanation - user input adj consumption - calculated | skip all |
| tested online and offline. Offline worked as expected. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| srmanager1 | Family Planning | Total Consumed qty - User input SOH - calc | View is weird again with additional columns, part of bug OLMIS-2306 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| srmanager1 | Family Planning | Total Consumed qty - user input SOH - calc |
Things to address :
- What are the error messages when user input is selected for consumed and stock on hand?
- Another question around the error message for negative calculated consumption?
...
| Field Name (Label) | Letter Icon | Business Definition | Calculation (identified by Letter Icons) | Source/Options | Template Save Validations | Product Grid Validations | |||
|---|---|---|---|---|---|---|---|---|---|
| Skip | S |
| |||||||
| Product Code | O | Unique identifier for each commodity/product. | Reference Data |
| |||||
| Product | R | Primary name of the product. | Reference Data | ||||||
| Beginning Balance | A | Based on the Stock On Hand from the previous period. This is quantified in dispensing units. | = SOH from the previous period's requisition | System Generated |
| ||||
| Total Received Quantity | B | Total quantity received in the reporting period. This is quantified in dispensing units. | User Input |
| |||||
| Total Consumed Quantity | C | Quantity dispensed/consumed in the reporting period. This is quantified in dispensing units. | If calculated, C = A + B +/- D - E | User Input or Calculated |
|
| |||
| Total Losses & Adjustments | D | All kind of losses/adjustments made at the facility. | User Input |
| |||||
| Stock on Hand | E | Current physical count of stock on hand. This is quantified in dispensing units. | A + B (+/-) D - C | Calculated or User Input |
|
| |||
| Calculated Order Quantity | I | H - E | Calculated |
| |||||
| Requested quantity | J | Requested override of calculated quantity. This is quantified in dispensing units. | User input |
|
| ||||
| Number of New Patients | F | New patients data. | User Input | ||||||
| Total | Y | Total of beginning balance and quantity received. | A + B | Calculated | |||||
| Stock out Days | X | Total number of days facility was out of stock. | User Input | ||||||
| Adjusted Consumption | N | Total consumed quantity after adjusting for stockout days. Quantified in dispensing units. | Roundup(C * (M * 30) / ((M * 30) - X ))) | Calculated | |||||
| Averaged Consumption | P | Average consumption over a specified number of periods/months. Quantified in dispensing units. | Last "t" periods averaged (includes the current reporting period being input) | Calculated | |||||
| Max Stock | H | P * MaxPeriodsOfStockMaxPeriodStock | Calculated | Calculated Order Quantity | I | H - E | Calculated|||
- Need to update the definition of Requested Quantity