---
sourceDocument: Yokohama Finance and Supply Chain
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/source-to-pay-operations

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Employee


---

# Run the fix script to enable decimal quantities for services

# Run the fix script to enable decimal quantities for services {#ariaid-title1}

* Release version: Yokohama
* 
* Updated February 20, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

After upgrading to Yokohama Patch 12 or Zurich Patch 6, if you are unable to specify decimal quantities for services, you must run a background fix script to enable support for decimal quantities.

## Before you begin

Role required: sn_shop.procurement_administrator

## About this task

If you upgraded to Yokohama Patch 12 or Zurich Patch 6 and cannot specify decimal quantities for services, run this script from the Scripts - Background module. The script converts the quantity field type from integer to decimal and updates the field scale to four decimal places.

## Procedure

1. Navigate to AllSystem DefinitionScripts - Background.
2. In the Run script (JavaScript executed on server) section, paste the following code:  

       (function() {
          var tableName = 'sn_spend_sdc_service_request_line';
          var columnName = 'new_purchased_quantity';
          if (pm.isZboot()) {
              return;
          }
          try {
              var updated = GlideFixStuff.fixTypeFromIntegerToDecimalCaseLineQuantityItem(tableName, columnName);
              if (!updated) {
                  gs.info('Cannot update type from integer to decimal for field ' + columnName);
                  return;
              }
              updateScale();
          } catch (ex) {
              gs.info('Cannot update type from integer to decimal with error ' + JSON.stringify(ex));
              return;
          }
          function updateScale() {
              var desiredScale = 4;
              var dictGR = new GlideRecord('sys_dictionary');
              var query = 'name=' + tableName + '^elementIN' + columnName;
              var fieldName;
              dictGR.addEncodedQuery(query);
              dictGR.query();
              if (dictGR.next()) {
                  try {
                      var attrbiuteArray = [];
                      var currentAttributes = dictGR.attributes;
                      if (currentAttributes != '') {
                          attrbiuteArray = currentAttributes.split(',');
                      }
                      var currentMaxLength = dictGR.max_length;
                      fieldName = dictGR.element;
                      var newMaxLength = currentMaxLength + desiredScale;
                      dictGR.max_length = newMaxLength;
                      attrbiuteArray.push("scale=" + desiredScale);
                      dictGR.attributes = attrbiuteArray.join(',');
                      dictGR.update();
                      dictGR.max_length = newMaxLength + 1;
                      dictGR.update();
                      gs.info('Updated max length twice for field ' + fieldName);
                  } catch (ex) {
                      gs.info('Cannot update scale attribute due to error : ' + JSON.stringify(ex));
                      gs.error('Error updating max length attribute for field {0}. No update performed.', fieldName);
                  }
              }
          }
       })();

3. Deselect the Record for rollback? check box.
4. Select Run Script.

*[\>]: and then