Product Grid Calculations

Tester	Log in	Program	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	Beginning balance from prior requisitions includes SOH + Approved qty. from prior period OLMIS-2307 - Getting issue details... STATUS R&R has errors, please correct them to proceed message does not display when authorizing or approving OLMIS-2305 - Getting issue details... STATUS Keyboard navigation displays multiple/incorrect error messages OLMIS-2303 - Getting issue details... STATUS Error message stuck on the screen OLMIS-2137 - Getting issue details... STATUS *Qty. field on the adjustment screen triggers the required field validation after entering an adjustment, even if no reason is selected OLMIS-2308 - Getting issue details... STATUS Reason field on the adjustment screen does not have requirement notification OLMIS-2309 - Getting issue details... STATUS Error icon shows on the "Full supply products" tab, but with no message when you hover over it OLMIS-2310 - Getting issue details... STATUS	No validation included for numeric-only fields
	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		Need to enter in bug for "10 out of 24 items" not updating OLMIS-2304 - Getting issue details... STATUS Need to enter in bug for table view where scroll bar is in the entry line. Sizing of the table is weird. Low priority OLMIS-2306 - Getting issue details... STATUS	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				Must be in the first position/column, order cannot be changed. Users can display or not without restriction
Product Code	O	Unique identifier for each commodity/product.		Reference Data	Must be in the second position/column, order cannot be changed. Users can display or not without restriction
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		Users can modify the pre-populated quantities Only positive numeric integers allowed If C and E are user input, A = C - B - E (+/-) D
Total Received Quantity	B	Total quantity received in the reporting period. This is quantified in dispensing units.		User Input		Only positive numeric integers allowed If C and E are user input, E = A + B (+/-) D - C
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	If C is calculated, E cannot be calculated	If C and E are user input, E = A + B (+/-) D - C If calculated, cannot be negative - error message If User Input, only positive numeric intergers allowed
Total Losses & Adjustments	D	All kind of losses/adjustments made at the facility.		User Input		If C and E are user input, Total Adjustments D = In the modal, only positive numeric intergers some reasons will be negative but user only input postive integers
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	If E is calculated, C cannot be calculated If E is user input, C can also be user input	If User Input, only positive numeric intergers allowed
Calculated Order Quantity	I		H - E	Calculated	if I is displayed, I is the default reorder number unless an amount is entered into J If displayed, A, B, C, D, E must be displayed. P, N, X are not required to be displayed
Requested quantity	J	Requested override of calculated quantity. This is quantified in dispensing units.		User input	If	Only positive numeric intergers allowed
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

Need to update the definition of Requested Quantity

OpenLMIS

Product Grid Testing

Product Grid Calculations

Things to address :