Field Service Order Data Fix [FSInvFix]

Article • 6/8/2026 • 3 min read

You can run this utility to fix several kinds of data issues related to Field Service Sales Order. The Field Service Data Utility page has an option to select FS Sales Order. The option checks the sales order in the field service document file that can be invoiced. Then, it processes those Field Service Sales Orders in the FSORD Item table (i.e., fsseritm). It checks the specified Sales Orders for the following issues for each FSORD item record:

A. Missing SO Key Reference B. Missing SHIP Key Reference C. Missing SHIP Quantity Issue D. Missing SHIP Document in fsserdoc table issue E. Invalid Type of Item – R (Returned) or S (Service Tool)

To fix Sales Order issues

  1. Open the Field Service Order Data Fix page. Select Utilities > Maintenance > Data Utilities > Field Service Order Data Fix.

    Or Search for Field Service Order Data Fix in the Navigation box and select Field Service Order Data Fix.

    Field Service Order Data Fix Utility page appears.

  2. In the Document type list, you can select one of the following options:

    a. Single Field Service SO: Select this option to run a single field service sales order to the invoiced status.

    i. Type the sales order number in the Sales Order field. Or ii. Click the Sales Order lookup reference and select the sales order from the Lookup for Sales Order window.

    b. Range Field Service SO: Select this option to move a range of Sales Orders to the invoiced status. Selecting this option enables the From and To fields.

    i. Type the first and last value of the Sales Order range in the From and To fields. Or ii. Select the first and last value of the Sales Order range from the From and To lookup reference.

Note: The Document type field has the default value set as Single SO.

  1. On the Toolbar, click Execute. After executing the utility, a grid will display all records with identified issues. This grid lists all Field Service Sales Orders (SOs) that require attention.

To resolve the issues

  1. Select the Sales Orders where the ‘Can Fix’ column is marked as ‘Y’. These are the SOs that the utility can automatically correct.
  2. Sales Orders where ‘Can Fix’ is ‘N’ cannot be fixed by the utility and may require manual intervention.
  3. Once all fixable issues have been resolved, the ‘Can Fix’ status will change to ‘I’.
  4. For Sales Orders with ‘Can Fix’ = ‘I’, users can proceed to generate invoices, as these SOs are now eligible for invoicing. Next, click the ‘Run’ button. This will fix the selected SOs having issues. If for any reason a record cannot be fixed, the ‘message’ column will be updated with the error message in the grid. To see the report of Field Service Orders having issues, right-click on the grid and ‘Export’.

Note to Invoice a FSORD

  1. The Field Service Order must be in Completed status.
  2. The Field Service Order must have a Sales Order related document tab under the Service Order, and the SO must also be in Completed status.
  3. The Field Service item must have a quantity shipped greater than the quantity received on the Items tab. Run this program if you cannot invoice a sales order and have already gone through the ‘Steps to Shipping Success of Field Service Sales Order’.

Tip: While selecting a record to be fixed, ensure that all the records of a given SO are selected.