886: Configure Adjusted Consumption (N)

886: Configure Adjusted Consumption (N)



Test Case #:886

Test Case Name: Configure Adjusted Consumption (N)

System: OpenLMIS

Subsystem: blue

Test case designed by: Paulina Borowa

Design Date:13.01.2017

Short description

Acceptance Criteria
Verify that:

  • in the APIs for configuring a requisition template, this new field can be added into the requisition template (by an admin with permissions to configure the template for their program)

  • if this field is NOT configured/associated to a requisition template, it does not appear on the requisition form

  • the field can be configured with a display order that controls where it appears on the requisition

  • in the APIs for initiating and saving a requisition, if this field is part of the template, then this field appears on the requisitions. Its display order should be based on the requisition template.

  • The field is a calculated field, read only.

  • value in the requsitions is calculated based on the calculation above (upholding the assumptions around F)

  • For this field to be added to the template, variables C and X are also required.

    • Data validation for C and X to be done during the admin template configuration.

  • Variable F is not required to be configured

  • If F isn't used in the template, zero is is used (meaning the second half of the formula is 0).

  • Display order is enforced on the requisition

  • Display order is set on the requisition template

  • UI: For any requisition with this field, the requisition form displays it in the proper display order.

                                                                                                                                                   

Pre – conditions:

                                                                                                                                                                                                                                                       

 

 

Step

Action

Expected system response

Comment

1

  Check if: 

  • The field is a calculated field, read only.

  • Display order is enforced on the requisition

  • Display order is set on the requisition template




                                                 

2

Check :

if this field is NOT configured/associated to a requisition template, it does not appear on the requisition form

API:

Method: PUT

{
  "id": "5a268780-fafd-4243-9551-5c7daa824913",
  "createdDate": [
    2016,
    6,
    14,
    12,
    0
  ],
  "programId": "dce17f2e-af3e-40ad-8e00-3496adef44c3",
  "numberOfPeriodsToAverage": 5,
  "columnsMap": {
    "adjustedConsumption": {
      "name": "adjustedConsumption",
      "label": "Adjusted Consumption",
      "indicator": "N",
      "displayOrder": 20,
      "isDisplayed": false,
      "source": "CALCULATED",
      "columnDefinition": {
        "id": "720dd95b-b765-4afb-b7f2-7b22261c32f3",
        "name": "adjustedConsumption",
        "sources": [
          "CALCULATED"
        ],
        "options": [],
        "label": "adjustedConsumption",
        "indicator": "N",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "numberOfNewPatientsAdded": {
      "name": "numberOfNewPatientsAdded",
      "label": "Number Of New Patients Added",
      "indicator": "F",
      "displayOrder": 18,
      "isDisplayed": true,
      "source": "USER_INPUT",
      "columnDefinition": {
        "id": "5708ebf9-9317-4420-85aa-71b2ae92643d",
        "name": "numberOfNewPatientsAdded",
        "sources": [
          "USER_INPUT"
        ],
        "options": [
          {
            "id": "34b8e763-71a0-41f1-86b4-1829963f0704",
            "optionName": "newPatientCount",
            "optionLabel": "New Patient Count"
          },
          {
            "id": "4957ebb4-297c-459e-a291-812e72286eff",
            "optionName": "dispensingUnitsForNewPatients",
            "optionLabel": "Dispensing units for new patients"
          }
        ],
        "label": "Number Of New Patients Added",
        "indicator": "F",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": {
        "id": "34b8e763-71a0-41f1-86b4-1829963f0704",
        "optionName": "newPatientCount",
        "optionLabel": "New Patient Count"
      }
    },
    "beginningBalance": {
      "name": "beginningBalance",
      "label": "Beginning Balance",
      "indicator": "A",
      "displayOrder": 4,
      "isDisplayed": true,
      "source": "USER_INPUT",
      "columnDefinition": {
        "id": "33b2d2e9-3167-46b0-95d4-1295be9afc22",
        "name": "beginningBalance",
        "sources": [
          "USER_INPUT"
        ],
        "options": [],
        "label": "Beginning Balance",
        "indicator": "A",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "dispensingUnit": {
      "name": "orderableProduct.dispensable.dispensingUnit",
      "label": "Unit/Unit of Issue",
      "indicator": "U",
      "displayOrder": 15,
      "isDisplayed": true,
      "source": "REFERENCE_DATA",
      "columnDefinition": {
        "id": "61e6d059-10ef-40c4-a6e3-fa7b9ad741ec",
        "name": "dispensingUnit",
        "sources": [
          "REFERENCE_DATA"
        ],
        "options": [],
        "label": "Unit/Unit of Issue",
        "indicator": "U",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "TEXT"
      },
      "option": null
    },
    "totalLossesAndAdjustments": {
      "name": "totalLossesAndAdjustments",
      "label": "Total Losses And Adjustments",
      "indicator": "D",
      "displayOrder": 7,
      "isDisplayed": true,
      "source": "USER_INPUT",
      "columnDefinition": {
        "id": "cd57f329-f549-4717-882e-ecbf98122c38",
        "name": "totalLossesAndAdjustments",
        "sources": [
          "USER_INPUT"
        ],
        "options": [],
        "label": "Total Losses And Adjustments",
        "indicator": "D",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "totalStockoutDays": {
      "name": "totalStockoutDays",
      "label": "Total Stockout Days",
      "indicator": "X",
      "displayOrder": 13,
      "isDisplayed": true,
      "source": "USER_INPUT",
      "columnDefinition": {
        "id": "750b9359-c097-4612-8328-d21671f88920",
        "name": "totalStockoutDays",
        "sources": [
          "USER_INPUT"
        ],
        "options": [],
        "label": "Total Stockout Days",
        "indicator": "X",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "packsToShip": {
      "name": "packsToShip",
      "label": "Packs To Ship",
      "indicator": "V",
      "displayOrder": 16,
      "isDisplayed": true,
      "source": "CALCULATED",
      "columnDefinition": {
        "id": "dc9dde56-593d-4929-81be-d1faec7025a8",
        "name": "packsToShip",
        "sources": [
          "CALCULATED"
        ],
        "options": [],
        "label": "Packs To Ship",
        "indicator": "V",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "productName": {
      "name": "orderableProduct.name",
      "label": "Product",
      "indicator": "N",
      "displayOrder": 3,
      "isDisplayed": true,
      "source": "REFERENCE_DATA",
      "columnDefinition": {
        "id": "e53e80de-fc63-4ecb-b6b2-ef376b34c926",
        "name": "productName",
        "sources": [
          "REFERENCE_DATA"
        ],
        "options": [],
        "label": "Product",
        "indicator": "N",
        "mandatory": false,
        "isDisplayRequired": true,
        "canChangeOrder": false,
        "canBeChangedByUser": false,
        "columnType": "TEXT"
      },
      "option": null
    },
    "approvedQuantity": {
      "name": "approvedQuantity",
      "label": "Approved Quantity",
      "indicator": "K",
      "displayOrder": 11,
      "isDisplayed": true,
      "source": "USER_INPUT",
      "columnDefinition": {
        "id": "a62a5fed-c0b6-4d49-8a96-c631da0d0113",
        "name": "approvedQuantity",
        "sources": [
          "USER_INPUT"
        ],
        "options": [],
        "label": "Approved Quantity",
        "indicator": "K",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "skipped": {
      "name": "skipped",
      "label": "Skip",
      "indicator": "S",
      "displayOrder": 1,
      "isDisplayed": true,
      "source": "USER_INPUT",
      "columnDefinition": {
        "id": "c6dffdee-3813-40d9-8737-f531d5adf420",
        "name": "skipped",
        "sources": [
          "USER_INPUT"
        ],
        "options": [],
        "label": "skipped",
        "indicator": "S",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": false,
        "canBeChangedByUser": false,
        "columnType": "BOOLEAN"
      },
      "option": null
    },
    "totalReceivedQuantity": {
      "name": "totalReceivedQuantity",
      "label": "Total Received Quantity",
      "indicator": "B",
      "displayOrder": 5,
      "isDisplayed": true,
      "source": "USER_INPUT",
      "columnDefinition": {
        "id": "5ba8b72d-277a-4da8-b10a-23f0cda23cb4",
        "name": "totalReceivedQuantity",
        "sources": [
          "USER_INPUT"
        ],
        "options": [],
        "label": "Total Received Quantity",
        "indicator": "B",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "total": {
      "name": "total",
      "label": "Total",
      "indicator": "Y",
      "displayOrder": 14,
      "isDisplayed": true,
      "source": "CALCULATED",
      "columnDefinition": {
        "id": "ef524868-9d0a-11e6-80f5-76304dec7eb7",
        "name": "total",
        "sources": [
          "CALCULATED"
        ],
        "options": [],
        "label": "Total",
        "indicator": "Y",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "productCode": {
      "name": "orderableProduct.productCode",
      "label": "Product Code",
      "indicator": "O",
      "displayOrder": 2,
      "isDisplayed": true,
      "source": "REFERENCE_DATA",
      "columnDefinition": {
        "id": "bde01507-3837-47b7-ae08-cec92c0c3cd2",
        "name": "productCode",
        "sources": [
          "REFERENCE_DATA"
        ],
        "options": [],
        "label": "Product Code",
        "indicator": "O",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": false,
        "canBeChangedByUser": false,
        "columnType": "TEXT"
      },
      "option": null
    },
    "totalConsumedQuantity": {
      "name": "totalConsumedQuantity",
      "label": "Total Consumed Quantity",
      "indicator": "C",
      "displayOrder": 6,
      "isDisplayed": true,
      "source": "USER_INPUT",
      "columnDefinition": {
        "id": "9e825396-269d-4873-baa4-89054e2722f4",
        "name": "totalConsumedQuantity",
        "sources": [
          "USER_INPUT",
          "CALCULATED"
        ],
        "options": [],
        "label": "Total Consumed Quantity",
        "indicator": "C",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "pricePerPack": {
      "name": "pricePerPack",
      "label": "Price Per Pack",
      "indicator": "T",
      "displayOrder": 17,
      "isDisplayed": true,
      "source": "REFERENCE_DATA",
      "columnDefinition": {
        "id": "df524868-9d0a-18e6-80f5-76304ded7ab9",
        "name": "pricePerPack",
        "sources": [
          "REFERENCE_DATA"
        ],
        "options": [],
        "label": "Price Per Pack",
        "indicator": "T",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "averageConsumption": {
      "name": "averageConsumption",
      "label": "Average Consumption",
      "indicator": "P",
      "displayOrder": 21,
      "isDisplayed": true,
      "source": "CALCULATED",
      "columnDefinition": {
        "id": "89113ec3-40e9-4d81-9516-b56adba7f8cd",
        "name": "averageConsumption",
        "sources": [
          "CALCULATED"
        ],
        "options": [],
        "label": "averageConsumption",
        "indicator": "P",
        "mandatory": false,
        "isDisplayRequired": false,
        "canChangeOrder": true,
        "canBeChangedByUser": false,
        "columnType": "NUMERIC"
      },
      "option": null
    },
    "requestedQuantity": {
      "name": "requestedQuantity",
      "label": "Requested Quantity",
      "indicator": "J",
      "displayOrder": 9,
      "isDisplayed": true,      "source": "USER_INPUT",      "columnDefinition": {        "id": "4a2e9fd3-1127-4b68-9912-84a5c00f6999",        "name": "requestedQuantity",        "sources": [          "USER_INPUT"        ],        "options": [],        "label": "Requested Quantity",        "indicator": "J",        "mandatory": false,        "isDisplayRequired": false,        "canChangeOrder": true,        "canBeChangedByUser": false,        "columnType": "NUMERIC"      },      "option": null    },    "requestedQuantityExplanation": {      "name": "requestedQuantityExplanation",      "label": "Requested Quantity Explanation",      "indicator": "W",      "displayOrder": 10,      "isDisplayed": true,      "source": "USER_INPUT",      "columnDefinition": {        "id": "6b8d331b-a0dd-4a1f-aafb-40e6a72ab9f5",        "name": "requestedQuantityExplanation",        "sources": [          "USER_INPUT"        ],        "options": [],        "label": "Requested Quantity Explanation",        "indicator": "W",        "mandatory": false,        "isDisplayRequired": false,        "canChangeOrder": true,        "canBeChangedByUser": false,        "columnType": "TEXT"      },      "option": null    },    "stockOnHand": {      "name": "stockOnHand",      "label": "Stock On Hand",      "indicator": "E",      "displayOrder": 8,      "isDisplayed": true,      "source": "CALCULATED",      "columnDefinition": {        "id": "752cda76-0db5-4b6e-bb79-0f531ab78e2c",        "name": "stockOnHand",        "sources": [          "USER_INPUT",          "CALCULATED"        ],        "options": [],        "label": "Stock On Hand",        "indicator": "E",        "mandatory": false,        "isDisplayRequired": false,        "canChangeOrder": true,        "canBeChangedByUser": false,        "columnType": "NUMERIC"      },      "option": null    },    "calculatedOrderQuantity": {      "name": "calculatedOrderQuantity",      "label": "Calculated Order Quantity",      "indicator": "I",      "displayOrder": 23,      "isDisplayed": true,      "source": "CALCULATED",      "columnDefinition": {        "id": "5528576b-b1e7-48d9-bf32-fd0eefefaa9a",        "name": "calculatedOrderQuantity",        "sources": [          "CALCULATED"        ],        "options": [],        "label": "calculatedOrderQuantity",        "indicator": "I",        "mandatory": false,        "isDisplayRequired": false,        "canChangeOrder": true,        "canBeChangedByUser": false,        "columnType": "NUMERIC"      },      "option": null    },    "remarks": {      "name": "remarks",      "label": "Remarks",      "indicator": "L",      "displayOrder": 12,      "isDisplayed": true,      "source": "USER_INPUT",      "columnDefinition": {        "id": "2ed8c74a-f424-4742-bd14-cfbe67b6e7be",        "name": "remarks",        "sources": [          "USER_INPUT"        ],        "options": [],        "label": "Remarks",        "indicator": "L",        "mandatory": false,        "isDisplayRequired": false,        "canChangeOrder": true,        "canBeChangedByUser": false,        "columnType": "TEXT"      },      "option": null    },    "totalCost": {      "name": "totalCost",      "label": "Total Cost",      "indicator": "Q",      "displayOrder": 19,      "isDisplayed": true,      "source": "CALCULATED",      "columnDefinition": {        "id": "e3a0c1fc-c2d5-11e6-af2d-3417eb83144e",        "name": "pricePerPack",        "sources": [          "CALCULATED"        ],        "options": [],        "label": "Total Cost",        "indicator": "Q",        "mandatory": false,        "isDisplayRequired": false,        "canChangeOrder": true,        "canBeChangedByUser": false,        "columnType": "NUMERIC"      },      "option": null    },    "maximumStockQuantity": {      "name": "maximumStockQuantity",      "label": "Maximum Stock Quantity",      "indicator": "H",      "displayOrder": 22,      "isDisplayed": true,      "source": "CALCULATED",      "columnDefinition": {        "id": "913e1a4f-f3b0-40c6-a422-2f73608c6f3d",        "name": "maximumStockQuantity",        "sources": [          "CALCULATED"        ],        "options": [          {            "id": "ff2b350c-37f2-4801-b21e-27ca12c12b3c",            "optionName": "default",            "optionLabel": "Default"          }        ],        "label": "maximumStockQuantity",        "indicator": "H",        "mandatory": false,        "isDisplayRequired": false,        "canChangeOrder": true,        "canBeChangedByUser": false,        "columnType": "NUMERIC"      },      "option": {        "id": "ff2b350c-37f2-4801-b21e-27ca12c12b3c",        "optionName": "default",        "optionLabel": "Default"      }    }  }

OpenLMIS: the global initiative for powerful LMIS software