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 |
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 | A + B (+/-) D - C | Calculated |
| ||
| Number of New Patients | F | User Input | ||||
| Total | Y | Total of beginning balance and quantity received. | A + B | Calculated | ||
| Stock out Days | X | User Input | ||||
| Adjusted Consumption | N | Roundup(C * (M * 30) / ((M * 30) - X))) | Calculated | |||
| Averaged Consumption | P | Last "t" periods averaged (includes the current reporting period) | Calculated | |||
| Max Stock | H | P * MaxPeriodsOfStock | Calculated | |||
| Calculated Order Quantity | I | H - E | Calculated | |||