/
998: Add template fields from v2 to the requisition template

998: Add template fields from v2 to the requisition template

Nov 15, 2016

Test Case #:998

Test Case Name:Add template fields from v2 to the requisition template

System: OpenLMIS

Subsystem: blue

Test case designed by: Paulina Borowa

Design Date:03.11.2016

Short description: 

Acceptance Criteria
Verify that:

OLMIS-810:Verify that:

  •  

    • users can rename the product code label if desired

    • the source of the product code attribute is the reference data

    • the product code data validations are upheld (it needs to be unique)

    • it is not required to be displayed on the requisition form

    • if selected to be displayed, it should be first

OLMIS-812 Verify that:

  • beginning balance column is displayed/available on the requisition form (via the requisition template), when selected to be

  • beginning balance column is NOT displayed/available on the requisition form when not selected

  • beginning balance is populated by the last requisition's 'stock in hand(E)'

  • there is an option for the implementer to indicate if users can override the populated value

  • implementers can define the data validation rule allowing data entry staff to modify the populated "Beginning Balance" amounts on the requisition form

    • when selected, users can modify the amounts

    • data entry selection made is upheld

  • the attribute is displayed in the defined order on the form

  • only non-negative and integer are allowed

  • only users, based on permissions, are allowed to define template attributes

  • data validations should match 2.0 functionalit

                                                                                                                                                   

Pre – conditions:

 demo-data                                                                                                                                                                                                                                                     

Step

Action

Expected system response

Comment

1

                                                                

Verify if  product code attribute are tied to template: 

In URL: http://10.222.17.205/requisition/api/requisitionTemplates?access_token=255f38f5-b89d-43f1-9910-a831356e9b7b

Method: Get

                                                                                                       

                                                 

2

Verify if  Beginning Balance attribute are tied to template: 

In URL: http://10.222.17.205/requisition/api/requisitionTemplates?access_token=255f38f5-b89d-43f1-9910-a831356e9b7b

Method: Get



3

Check if:

users can rename the product code label if desired

In URL: http://10.222.17.205/requisition/api/requisitionTemplates/5a268780-fafd-4243-9551-5c7daa824913?access_token=e71400c3-7aa4-4b61-b63d-74e152ef5b18

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",
      "indicator": "O",
      "displayOrder": 1,
      "isDisplayed": true,
      "source": "REFERENCE_DATA",
      "columnDefinition": {
        "id": "bde01507-3837-47b7-ae08-cec92c0c3cd2",
        "name": "productCode",
        "sources": [
          "REFERENCE_DATA"
        ],
        "label": "Product",
        "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": "USER_INPUT",
      "columnDefinition": {
        "id": "9e825396-269d-4873-baa4-89054e2722f4",
        "name": "totalConsumedQuantity",
        "sources": [
          "CALCULATED",
          "USER_INPUT"
        ],
        "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": "CALCULATED",
      "columnDefinition": {
        "id": "752cda76-0db5-4b6e-bb79-0f531ab78e2c",
        "name": "stockOnHand",
        "sources": [
          "CALCULATED"
        ],
        "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"
      }
    }
  }
}







Check

the source of the product code attribute is the reference data





Check

it is not required to be displayed on the requisition form

Check if:

users can rename the product code label if desired

In URL: http://10.222.17.205/requisition/api/requisitionTemplates/5a268780-fafd-4243-9551-5c7daa824913?access_token=e71400c3-7aa4-4b61-b63d-74e152ef5b18

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":false,      "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": "USER_INPUT",      "columnDefinition": {        "id": "9e825396-269d-4873-baa4-89054e2722f4",        "name": "totalConsumedQuantity",        "sources": [          "CALCULATED",          "USER_INPUT"        ],        "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": "CALCULATED",      "columnDefinition": {        "id": "752cda76-0db5-4b6e-bb79-0f531ab78e2c",        "name": "stockOnHand",        "sources": [          "CALCULATED"        ],        "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"      }    }  }}

OpenLMIS: the global initiative for powerful LMIS software