...
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) |
---|
System Generated
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 |
Columns Included
(specify user input/calculations)
Issues/Bugs
Identified