Defining requisition values

Requisition Type Definition Values Setup enables you to define the values used in the Requisition Type.

  1. From the Action menu within Requisition Types, select Requisition Value.
  2. Specify this information:
    Value Label
    The value label to be applied, as defined in Value Labels (VLB).
    Value Label Value Type
    Depending on the Value Label selected, this field may automatically be completed, or you may have to select the type of the value label.

    These options are available:

    • Without Units: A number without a Unit of Measure attached to it. For example, a percentage.
    • With Units: A number with a Unit of Measure attached to it. For example, a quantity.
    • Corresponds to Base Currency: A number that is the base currency.
    • Corresponds to Transaction Currency: A number that is the transaction currency.
    • Corresponds to Reporting or 2nd Base Currency: A number that is the reporting or 2nd base currency.
    Formula Code
    The formula to be used for the value, for example VAT, which has been set up using the Formula Designer user tool.
    If you do not enter a formula the value must be entered at run-time instead of being calculated. For example, a quantity does not normally use a formula.
    Note: When you set up formulas, you can specify the number of decimal places to use. This number is used when entering values into the value label. Take care when selecting the correct number of decimal places to be used. Problems may occur if a formula returns more decimal places than the currency is expecting. If in doubt, use the Default Currency option when setting up the decimal places in the formula.
    Calculation Sequence
    If a Formula Code is specified, this field indicates the sequence in which the formula is calculated. For example, 1, 2, 3 etc. If you close and re-enter the form, entries are reordered by this sequence. You can use parallel sequence numbers. That is, more than one value can have the same sequence number. The calculation sequence '0' is intended for values that are entered by the user and do not have a formula attached to them. '0' cannot be used if a formula is attached to the value.
    A value must be calculated before it can be used in a formula. If a value is referenced in a formula before it is calculated, an error results when a transaction is entered for this Purchase Type. Therefore, its sequence number must be lower than the sequence number of the value with the formula that it uses.
    For example, you might have three values: Quantity, Unit Price and Net. Quantity is entered by the user; Unit Price has a formula to use a Price Book; and Net has the formula Quantity '*' multiply Net.
    Table 1. Example sequence
    Value Label Calculation Sequence
    Quantity 0
    Unit Price 1
    Net 2
    Soft Commitment Budget Value
    Indicates whether or not the value label holds the budget amount. Only one value can be nominated, or none if no budget checking is applied.
    Note: This applies only to Base Currency values.
    Purchase Quantity
    Indicates whether or not the value label holds the purchase quantity. Only one value can be designated as the purchase quantity. A purchase quantity must be specified in order to process Items with Goods as the Item Type.
    Holds Unit Price
    Indicates whether or not the value label holds the unit price. Only one value can hold the unit price.
    Note: 
    • One of the uses of this field is with Purchase Blanket Contract functionality, in which case it indicates which value label contains the unit price, and so which value label into which to insert the contract price.
    • If unit conversions are carried out, the value in this field is converted. For example, if a case costs GBP 10, and can be bought in barrels where there are 15 cases in a barrel, then a transaction for one barrel has a unit price of GBP 150.
    Holds Purchase Value
    Indicates whether or not the value label holds the purchase value. Only one value can hold the purchase value.
    One of the uses of this field is with Purchase Approval functionality. This field is checked by the system when a line or document is amended in order to determine if this value, and so this line or document, has changed. If no value label is marked as holding the purchase value, then any amendments to lines or documents are not handled correctly. If another value label is marked as holding the purchase value, then this is acceptable as long as a change to the line or document results in a change to this value. If it does not and, for example, the quantity is changed, the approvals process does not pick up the amendment to the line or document and so the line or document will not be reset for reapproval if required.
    Rate Required
    Indicates whether the currency conversion rate should be entered which overrides the rate looked up on the currency table.
    These options are available:
    • No - never entered.
    • Yes - must be entered.
    • Optional - may be entered. The rate defined in the currency tables is displayed but can be overridden.
      Note: If different rates are defined for different account ranges, the rate defined for the supplier's account is used.
    Running Total Required
    Indicates whether the value has a running total created for it. This allows display during entry of, for example, the value of the purchase order entered so far. These totals can be incorporated into formulae to calculate further values based on purchase order totals.
  3. Click OK to save your changes.