Product Grid Testing
Product Grid Calculations
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?
Requisition Template and Product Grid Validations
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 reporting period being input) | Calculated |
|
|
Max Stock | H |
| P * MaxPeriodStock | Calculated |
|
|
|
|
|
|
|
|
|