Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field Label

Letter Icon

Business Definition

Calculation (Columns are identified by letter icons)

Source/Options

Template Save Validations


Allows tags

Regular Requisition Form Validations


Emergency Requisition Form ValidationsStock- Based Requisition Form ValidationsAdditional Options
SkipSAllows user to skip R&R for a product line item and hide skipped line items in the R&R formNot ApplicableNot Applicable
  • Must be in the first position/column, order cannot be changed.
  • Not required to display
NO
  • Cannot skip product if there is any data in any column (based on a previous R&R or entered by a user)
Not Applicable
  • Cannot skip product if there is any data in any column (based on a previous R&R or entered by a user)
  • Selecting "Disable Skipped Line items" will still display skipped products in the requisition product grid. 
  • Selecting "Hide Skipped Line items" will hide any skipped line items in the requisition product grid so the user doesn't see products they have already skipped. The user will need to select "Add Products" to add them back to the requisition product grid.
Product CodeOUnique identifier for each commodity/product.Not ApplicableReference Data
  • Must be in the second position/column, order cannot be changed.
  • Not required to display
NO



ProductR*Primary name of the product.Not ApplicableReference Data
  • Must be in the third position/column, order cannot be changed.
  • Required to display
NO



Beginning BalanceABased on the Stock On Hand from the previous period. This is quantified in dispensing units.= SOH from the previous period's requisitionSystem Generated
  • Not required to display 
NO
  • Users can modify the pre-populated quantities
  • Only positive numeric integers allowed
  • If C and E are user input, then the Beginning Balance will need to equal C - B - E (+/-) D or an error will be produced when submitting.
  • Column not available
  • Populated by Stock on Hand
  • Users cannot edit quantities
  • Not required to display

Total Received QuantityB*Total quantity received in the reporting period. This is quantified in dispensing units.
User Input
  • If C and E are user input, this is required to display
  • If B source is Stock Cards then it is not required to display
YES
  • Only positive numeric integers allowed
  • If C and E are user input, E = A + B (+/-) D - C
  • Column not available
  • Populated by Stock Cards
  • Users cannot edit quantities
  • Not required to display

Total Consumed QuantityC*Quantity dispensed/consumed in the reporting period. This is quantified in dispensing units.If calculated, C = A + B +/- D - EUser Input or Calculated
  • If C is calculated, E cannot be calculated
  • If C is User Input, E can also be User Input
  • If C is calculated, B is required to display
  • If C source is Stock Cards then it is not required to display
YES
  • 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 integers allowed
  • Column not available
  • Populated by Stock Cards
  • Users cannot edit quantities
  • Not required to display

Total Losses & AdjustmentsD*All kind of losses/adjustments made at the facility.

User Input

(Source is list of Adjustment Reasons configured in Stock Management)

  • Required to display unless source is Stock Cards
NO
  • In the modal, the sum of the losses and adjustments is shown on the requisition column D. So if C and E are user input:
    • A + B - C + D = E
      • When the sum of D is positive
    • A + B - C - D = E  
      • When the sum of D is negative
  • In the modal, the user can only input positive numbers because when the reason is selected, the system determines if the number is negative or positive
  • Column not available
  • Populated by Stock Cards
  • Users cannot edit quantities
  • Not required to display

Stock on HandE*

Physical count of stock on hand, as of the requisition's processing period end date. This is quantified in dispensing units.


A + B (+/-) D - CCalculated, User Input, or Stock Cards
  • If E is calculated, C cannot be calculated
  • If E is user input, C can also be user input
  • If E source is stock cards then it is not required to display
NO
  • If User Input, only positive numeric integers allowed

Column not available

  • Populated by Stock Cards
  • Users cannot edit quantities
  • Not required to display

Calculated Order QuantityI
H - ECalculated
  • If I is displayed, I is the default reorder number unless an amount is entered into J or K
  • If displayed then A, B, C, D, E must be displayed.
  • If displayed then P, N, X are not required to be displayed
  • Otherwise it is not required to display


NO
  • Must be positive numeric number, or error will display in columns A, B, C, D, or E

Column not available

Updates to this column validation must be added for 3.5 Sebastian Brudziński
Requested quantityJRequested override of calculated order quantity. This is quantified in dispensing units.
User input
  • If J is displayed, W must be displayed
  • Otherwise it is not required to display
NO
  • Only positive numeric integers allowed
  • If left blank, column I, Calculated Order Quantity, will be used to calculate the Total Requisition Cost and Packs to Ship
  • Only positive numeric integers allowed
  • J will be used to calculate the Total Requisition Cost and Packs to Ship
  • Required to display
  • Only positive numeric integers allowed
  • J will be used to calculate the Total Requisition Cost and Packs to Ship
  • Not required to display

Requested Quantity ExplanationWExplanation of the request for a quantity other than the calculated order quantity.
User Input
  • If J is displayed, W must be displayed
  • Otherwise it is not required to display
NO
  • If J contains data, this column must have some data.
  • Only text allowed
  • Required to display
  • Only text allowed


Number of New PatientsFNumber of New patients data
User Input
  • Can either be New patient count or Dispensing units for new patients
  • Not required to display
NO
  • Only positive numeric integers allowed
Column not available

Approved QuantityKFinal approved quantity. This is quantified in dispensing units.
User Input
  • If only I, or J and W are displayed, then K must display for users with Approve rights
NO
  • If only I is displayed, then K is auto-populated with values from I.
  • Users can modify the pre-populated quantities
  • Only positive numeric integers allowed
  • Auto-populated from J
  • Users can modify the pre-populated quantities
  • Only positive numeric integers allowed
  • Auto-populated from J
  • Users can modify the pre-populated quantities
  • Only positive numeric integers allowed

RemarksLAny additional remarks
User Input
  • Not required to display
NO
  • Not required
  • Any text input allowed
  • Not required to display
  • Any text input allowed
  • Not required to display
  • Any text input allowed

TotalYTotal of beginning balance and quantity received.A + BCalculated
  • Not required to display
NO
Column not available
  • Not required to display

Total Stock out DaysXTotal number of days facility was out of stock.
User Input or Stock Cards
  • If N is displayed, X must be displayed
  • If X source is Stock Cards then N must be displayed
  • Otherwise it is not required to display
NO
  • Only positive numeric integers allowed
Column not available
  • Not required to display

Adjusted ConsumptionNTotal consumed quantity after adjusting for stockout days. Quantified in dispensing units.

Roundup(C * (M * 30) / ((M * 30) - X ))) 

M = Number of periods to average (this is identified in the additional options column for P)

Calculated
  • If N is displayed, X must be displayed
  • If Z is displayed, the N must be displayed
  • Otherwise it is not required to display
NO
Column not available

Averaged ConsumptionPAverage consumption over a specified number of periods/months. Quantified in dispensing units.

AMC (P) = (Nt0 + Nt-1 + Nt-2) / 3

Last "t" periods averaged (includes the reporting period being input)

Calculated or Stock Cards
  • Number of periods must be greater than or equal to 2
  • If P is displayed then N and X must be displayed, otherwise N is not required to display
NO


  • Column not available
  • If user is completing an Emergency Requisition, the values shouldn't impact avg consumption calculations for regular requisitions.
Updates to this column validation must be added for 3.5 Sebastian BrudzińskiNumber. of periods to average
Maximum Stock QuantityHMaximum stock calculated based on consumption and max stock amounts. Quantified in dispensing units.P * MaxPeriodStockCalculated
  • Not required to display
NO
Column not available
  • Not required to display

Price Per PackTPrice per pack. Will be blank if price is not defined.
ReferenceData
  • Not required to display
NO
Column not available
  • Not required to display

Packs to ShipVTotal packs to ship based on pack size and applying rounding rulesJ / UCalculated
  • Not required to display
NO
  • If J or K contains no data, then I is the default reorder amount and is used to calculate packs to ship.
  • If J contains data and K does not contain data, then J is used to calculate packs to ship.
  • If K contains data then it overrides any data in I or J, and K is used to calculate packs to ship
Column not available
  • Not required to display

Total CostQTotal cost of the product based on quantity requested. Will be blank if price is not defined.V * TCalculated
  • Not required to display
NO
  • This column updates as I, J, or K are updated
  • If K contains data then it overrides any data in I or J, and then K is used to calculate total cost
  • This column updates as J or K are updated


Dispensing UnitUDispensing unit for this product.
ReferenceData
  • Not required to display
NO
  • Column not available
  • Not required to display

Ideal Stock AmountGThe Ideal Stock Amount is the target quantity for a specific commodity type, facility, and period.
ReferenceData
  • Column not available
NO
  • Column not available


Additional Quantity RequiredZ

Additional quantity needed for New Patients or other factors such as seasonality

Adjusted Consumption (N)+ Additional Quantity Required (Z)



  • If Z is displayed, then N is required to display





...