814: Configure Total Consumed Quantity

Test Case #:814	Test Case Name: Configure Total Consumed Quantity
System: OpenLMIS	Subsystem: blue
Test case designed by: Paulina Borowa	Design Date:07.11.2016
Short description: Verify that: the attribute can either be user input or calculated calculation follows A + B (+/-) D - E A = Beginning Balance B = Total Received Quantity D = Total Losses/Adjustments E = Stock on Hand users can rename the attribute if user input is selected, users can only input non negative intergers the attribute is displayed in the defined order on the form if this attribute is selected for the form and the calculation option, then the stock in hand needs to be configured to displayed as user input -If calculated, a requisition cannot be submitted (status = submitted) if A, B, D and E are not filled on the requisition form - If E (stock in hand) and C (Total Consumed Quantity) are both configured as user inputs, the validation of E=A+B(+/-)D-C should still be enforced If calculated, stock on hand is required to be entered (it cannot be hidden). appropriate permissions are enforced data validations should match the current 2.0 functionality if calculates to a negative value, validation should not allow submitting such a requisition

Pre – conditions:

Step

	Action	Expected system response	Comment
1	Check if: the attribute can either be user input or calculated calculated: In URL: http://10.222.17.205/requisition/api/requisitionTemplates/5a268780-fafd-4243-9551-5c7daa824913?access_token=3e90c17e-b6d0-473a-9bb9-d785a3f03bbf Method: PUT Body: { "id": "5a268780-fafd-4243-9551-5c7daa824913", "programId": "dce17f2e-af3e-40ad-8e00-3496adef44c3", "columnsMap": { "beginningBalance": { "name": "beginningBalance", "label": "Beginning Balance", "indicator": "A", "displayOrder": 13, "isDisplayed": false, "source": "USER_INPUT", "columnDefinition": { "id": "33b2d2e9-3167-46b0-95d4-1295be9afc22", "name": "beginningBalance", "sources": [ "USER_INPUT" ], "label": "Beginning Balance", "indicator": "A", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "totalLossesAndAdjustments": { "name": "totalLossesAndAdjustments", "label": "Total Losses And Adjustments", "indicator": "D", "displayOrder": 6, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "cd57f329-f549-4717-882e-ecbf98122c38", "name": "totalLossesAndAdjustments", "sources": [ "USER_INPUT" ], "label": "Total Losses And Adjustments", "indicator": "D", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "totalStockoutDays": { "name": "totalStockoutDays", "label": "Total Stockout Days", "indicator": "X", "displayOrder": 3, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "750b9359-c097-4612-8328-d21671f88920", "name": "totalStockoutDays", "sources": [ "USER_INPUT" ], "label": "Total Stockout Days", "indicator": "X", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "productName": { "name": "orderableProduct.name", "label": "Product", "indicator": "N", "displayOrder": 2, "isDisplayed": true, "source": "REFERENCE_DATA", "columnDefinition": { "id": "e53e80de-fc63-4ecb-b6b2-ef376b34c926", "name": "productName", "sources": [ "REFERENCE_DATA" ], "label": "Product", "indicator": "N", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } }, "totalReceivedQuantity": { "name": "totalReceivedQuantity", "label": "Total Received Quantity", "indicator": "B", "displayOrder": 4, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "5ba8b72d-277a-4da8-b10a-23f0cda23cb4", "name": "totalReceivedQuantity", "sources": [ "USER_INPUT" ], "label": "Total Received Quantity", "indicator": "B", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "approvedQuantity": { "name": "approvedQuantity", "label": "Approved Quantity", "indicator": "K", "displayOrder": 10, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "a62a5fed-c0b6-4d49-8a96-c631da0d0113", "name": "approvedQuantity", "sources": [ "USER_INPUT" ], "label": "Approved Quantity", "indicator": "K", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "total": { "name": "total", "label": "Total", "indicator": "Y", "displayOrder": 13, "isDisplayed": true, "source": "CALCULATED", "columnDefinition": { "id": "ef524868-9d0a-11e6-80f5-76304dec7eb7", "name": "total", "sources": [ "CALCULATED" ], "label": "Total", "indicator": "Y", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "productCode": { "name": "orderableProduct.productCode", "label": "Product Code", "indicator": "O", "displayOrder": 1, "isDisplayed": true, "source": "REFERENCE_DATA", "columnDefinition": { "id": "bde01507-3837-47b7-ae08-cec92c0c3cd2", "name": "productCode", "sources": [ "REFERENCE_DATA" ], "label": "Product Code", "indicator": "O", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } }, "totalConsumedQuantity": { "name": "totalConsumedQuantity", "label": "Total Consumed Quantity", "indicator": "C", "displayOrder": 5, "isDisplayed": true, "source": "CALCULATED", "columnDefinition": { "id": "9e825396-269d-4873-baa4-89054e2722f4", "name": "totalConsumedQuantity", "sources": [ "CALCULATED" ], "label": "Total Consumed Quantity", "indicator": "C", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "requestedQuantity": { "name": "requestedQuantity", "label": "Requested Quantity", "indicator": "J", "displayOrder": 8, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "4a2e9fd3-1127-4b68-9912-84a5c00f6999", "name": "requestedQuantity", "sources": [ "USER_INPUT" ], "label": "Requested Quantity", "indicator": "J", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "stockOnHand": { "name": "stockOnHand", "label": "Stock On Hand", "indicator": "E", "displayOrder": 7, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "752cda76-0db5-4b6e-bb79-0f531ab78e2c", "name": "stockOnHand", "sources": [ "USER_INPUT" ], "label": "Stock On Hand", "indicator": "E", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "requestedQuantityExplanation": { "name": "requestedQuantityExplanation", "label": "Requested Quantity Explanation", "indicator": "W", "displayOrder": 9, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "6b8d331b-a0dd-4a1f-aafb-40e6a72ab9f5", "name": "requestedQuantityExplanation", "sources": [ "USER_INPUT" ], "label": "Requested Quantity Explanation", "indicator": "W", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } }, "remarks": { "name": "remarks", "label": "Remarks", "indicator": "L", "displayOrder": 11, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "2ed8c74a-f424-4742-bd14-cfbe67b6e7be", "name": "remarks", "sources": [ "USER_INPUT" ], "label": "Remarks", "indicator": "L", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } } } }	user input: calculated:
2	Check if this attribute is selected for the form and the calculation option, then the stock in hand needs to be configured to displayed as user input Set Total Consumed Quantity and Stock in hand as "CALCULATED"
3	Disable the Total Consumed Quantity using API. Set "isDisplayed" to false In URL: http://10.222.17.205/requisition/api/requisitionTemplates/5a268780-fafd-4243-9551-5c7daa824913?access_token=3e90c17e-b6d0-473a-9bb9-d785a3f03bbf Method: PUT { "id": "5a268780-fafd-4243-9551-5c7daa824913", "programId": "dce17f2e-af3e-40ad-8e00-3496adef44c3", "columnsMap": { "beginningBalance": { "name": "beginningBalance", "label": "Beginning Balance", "indicator": "A", "displayOrder": 13, "isDisplayed": false, "source": "USER_INPUT", "columnDefinition": { "id": "33b2d2e9-3167-46b0-95d4-1295be9afc22", "name": "beginningBalance", "sources": [ "USER_INPUT" ], "label": "Beginning Balance", "indicator": "A", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "totalLossesAndAdjustments": { "name": "totalLossesAndAdjustments", "label": "Total Losses And Adjustments", "indicator": "D", "displayOrder": 6, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "cd57f329-f549-4717-882e-ecbf98122c38", "name": "totalLossesAndAdjustments", "sources": [ "USER_INPUT" ], "label": "Total Losses And Adjustments", "indicator": "D", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "totalStockoutDays": { "name": "totalStockoutDays", "label": "Total Stockout Days", "indicator": "X", "displayOrder": 3, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "750b9359-c097-4612-8328-d21671f88920", "name": "totalStockoutDays", "sources": [ "USER_INPUT" ], "label": "Total Stockout Days", "indicator": "X", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "productName": { "name": "orderableProduct.name", "label": "Product", "indicator": "N", "displayOrder": 2, "isDisplayed": true, "source": "REFERENCE_DATA", "columnDefinition": { "id": "e53e80de-fc63-4ecb-b6b2-ef376b34c926", "name": "productName", "sources": [ "REFERENCE_DATA" ], "label": "Product", "indicator": "N", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } }, "totalReceivedQuantity": { "name": "totalReceivedQuantity", "label": "Total Received Quantity", "indicator": "B", "displayOrder": 4, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "5ba8b72d-277a-4da8-b10a-23f0cda23cb4", "name": "totalReceivedQuantity", "sources": [ "USER_INPUT" ], "label": "Total Received Quantity", "indicator": "B", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "approvedQuantity": { "name": "approvedQuantity", "label": "Approved Quantity", "indicator": "K", "displayOrder": 10, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "a62a5fed-c0b6-4d49-8a96-c631da0d0113", "name": "approvedQuantity", "sources": [ "USER_INPUT" ], "label": "Approved Quantity", "indicator": "K", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "total": { "name": "total", "label": "Total", "indicator": "Y", "displayOrder": 13, "isDisplayed": true, "source": "CALCULATED", "columnDefinition": { "id": "ef524868-9d0a-11e6-80f5-76304dec7eb7", "name": "total", "sources": [ "CALCULATED" ], "label": "Total", "indicator": "Y", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "productCode": { "name": "orderableProduct.productCode", "label": "Product Code", "indicator": "O", "displayOrder": 1, "isDisplayed": true, "source": "REFERENCE_DATA", "columnDefinition": { "id": "bde01507-3837-47b7-ae08-cec92c0c3cd2", "name": "productCode", "sources": [ "REFERENCE_DATA" ], "label": "Product Code", "indicator": "O", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } }, "totalConsumedQuantity": { "name": "totalConsumedQuantity", "label": "Total Consumed Quantity", "indicator": "C", "displayOrder": 5, "isDisplayed": false, "source": "CALCULATED", "columnDefinition": { "id": "9e825396-269d-4873-baa4-89054e2722f4", "name": "totalConsumedQuantity", "sources": [ "CALCULATED" ], "label": "Total Consumed Quantity", "indicator": "C", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "requestedQuantity": { "name": "requestedQuantity", "label": "Requested Quantity", "indicator": "J", "displayOrder": 8, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "4a2e9fd3-1127-4b68-9912-84a5c00f6999", "name": "requestedQuantity", "sources": [ "USER_INPUT" ], "label": "Requested Quantity", "indicator": "J", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "stockOnHand": { "name": "stockOnHand", "label": "Stock On Hand", "indicator": "E", "displayOrder": 7, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "752cda76-0db5-4b6e-bb79-0f531ab78e2c", "name": "stockOnHand", "sources": [ "USER_INPUT" ], "label": "Stock On Hand", "indicator": "E", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "requestedQuantityExplanation": { "name": "requestedQuantityExplanation", "label": "Requested Quantity Explanation", "indicator": "W", "displayOrder": 9, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "6b8d331b-a0dd-4a1f-aafb-40e6a72ab9f5", "name": "requestedQuantityExplanation", "sources": [ "USER_INPUT" ], "label": "Requested Quantity Explanation", "indicator": "W", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } }, "remarks": { "name": "remarks", "label": "Remarks", "indicator": "L", "displayOrder": 11, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "2ed8c74a-f424-4742-bd14-cfbe67b6e7be", "name": "remarks", "sources": [ "USER_INPUT" ], "label": "Remarks", "indicator": "L", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } } } }
4	Check the calculation follows A + B (+/-) D - E
5	Check if: users can rename the attribute In URL: http://10.222.17.205/requisition/api/requisitionTemplates/5a268780-fafd-4243-9551-5c7daa824913?access_token=3e90c17e-b6d0-473a-9bb9-d785a3f03bbf Method: PUT Body: { "id": "5a268780-fafd-4243-9551-5c7daa824913", "programId": "dce17f2e-af3e-40ad-8e00-3496adef44c3", "columnsMap": { "beginningBalance": { "name": "beginningBalance", "label": "Beginning Balance", "indicator": "A", "displayOrder": 13, "isDisplayed": false, "source": "USER_INPUT", "columnDefinition": { "id": "33b2d2e9-3167-46b0-95d4-1295be9afc22", "name": "beginningBalance", "sources": [ "USER_INPUT" ], "label": "Beginning Balance", "indicator": "A", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "totalLossesAndAdjustments": { "name": "totalLossesAndAdjustments", "label": "Total Losses And Adjustments", "indicator": "D", "displayOrder": 6, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "cd57f329-f549-4717-882e-ecbf98122c38", "name": "totalLossesAndAdjustments", "sources": [ "USER_INPUT" ], "label": "Total Losses And Adjustments", "indicator": "D", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "totalStockoutDays": { "name": "totalStockoutDays", "label": "Total Stockout Days", "indicator": "X", "displayOrder": 3, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "750b9359-c097-4612-8328-d21671f88920", "name": "totalStockoutDays", "sources": [ "USER_INPUT" ], "label": "Total Stockout Days", "indicator": "X", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "productName": { "name": "orderableProduct.name", "label": "Product", "indicator": "N", "displayOrder": 2, "isDisplayed": true, "source": "REFERENCE_DATA", "columnDefinition": { "id": "e53e80de-fc63-4ecb-b6b2-ef376b34c926", "name": "productName", "sources": [ "REFERENCE_DATA" ], "label": "Product", "indicator": "N", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } }, "totalReceivedQuantity": { "name": "totalReceivedQuantity", "label": "Total Received Quantity", "indicator": "B", "displayOrder": 4, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "5ba8b72d-277a-4da8-b10a-23f0cda23cb4", "name": "totalReceivedQuantity", "sources": [ "USER_INPUT" ], "label": "Total Received Quantity", "indicator": "B", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "approvedQuantity": { "name": "approvedQuantity", "label": "Approved Quantity", "indicator": "K", "displayOrder": 10, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "a62a5fed-c0b6-4d49-8a96-c631da0d0113", "name": "approvedQuantity", "sources": [ "USER_INPUT" ], "label": "Approved Quantity", "indicator": "K", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "total": { "name": "total", "label": "Total", "indicator": "Y", "displayOrder": 13, "isDisplayed": true, "source": "CALCULATED", "columnDefinition": { "id": "ef524868-9d0a-11e6-80f5-76304dec7eb7", "name": "total", "sources": [ "CALCULATED" ], "label": "Total", "indicator": "Y", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "productCode": { "name": "orderableProduct.productCode", "label": "Product Code", "indicator": "O", "displayOrder": 1, "isDisplayed": true, "source": "REFERENCE_DATA", "columnDefinition": { "id": "bde01507-3837-47b7-ae08-cec92c0c3cd2", "name": "productCode", "sources": [ "REFERENCE_DATA" ], "label": "Product Code", "indicator": "O", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } }, "totalConsumedQuantity": { "name": "totalConsumedQuantity", "label": "Quantity", "indicator": "C", "displayOrder": 5, "isDisplayed": true, "source": "CALCULATED", "columnDefinition": { "id": "9e825396-269d-4873-baa4-89054e2722f4", "name": "totalConsumedQuantity", "sources": [ "CALCULATED" ], "label": "Quantity", "indicator": "C", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "requestedQuantity": { "name": "requestedQuantity", "label": "Requested Quantity", "indicator": "J", "displayOrder": 8, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "4a2e9fd3-1127-4b68-9912-84a5c00f6999", "name": "requestedQuantity", "sources": [ "USER_INPUT" ], "label": "Requested Quantity", "indicator": "J", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "stockOnHand": { "name": "stockOnHand", "label": "Stock On Hand", "indicator": "E", "displayOrder": 7, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "752cda76-0db5-4b6e-bb79-0f531ab78e2c", "name": "stockOnHand", "sources": [ "CALCULATED", "USER_INPUT" ], "label": "Stock On Hand", "indicator": "E", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "NUMERIC" } }, "requestedQuantityExplanation": { "name": "requestedQuantityExplanation", "label": "Requested Quantity Explanation", "indicator": "W", "displayOrder": 9, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "6b8d331b-a0dd-4a1f-aafb-40e6a72ab9f5", "name": "requestedQuantityExplanation", "sources": [ "USER_INPUT" ], "label": "Requested Quantity Explanation", "indicator": "W", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } }, "remarks": { "name": "remarks", "label": "Remarks", "indicator": "L", "displayOrder": 11, "isDisplayed": true, "source": "USER_INPUT", "columnDefinition": { "id": "2ed8c74a-f424-4742-bd14-cfbe67b6e7be", "name": "remarks", "sources": [ "USER_INPUT" ], "label": "Remarks", "indicator": "L", "mandatory": false, "isDisplayRequired": false, "canChangeOrder": true, "canBeChangedByUser": false, "columnType": "TEXT" } } } }
6
7
8