Displaying status 10 equipment records or equipment without related customer

To display status 10 equipment records in M3 or equipment records without connected customer in M3, you must update Customer details dialog and Equipment details dialog.

Ensure to enable the Standalone Equipment list in M3 Mobility Core Tenant Toolbox before you proceed.

See M3 Mobility Core Tenant Toolbox Administration Guide for more information.

  1. Using M3 Mobility Core Toolbox, select System configuration > Dialog design.
  2. Select and copy the Customer Details dialog and proceed to the Dialog layout tab.
  3. From Groups, select Pending Assignments.
  4. On the Dialog Layout tab, select FilterListControl.
  5. Click the ellipsis button to display Control properties.
  6. Update the Filter group to (MFS-MAI) Customer - Pending Operations - Standalone Equipment List.
  7. Click Close.
  8. From Groups, select Service History .
  9. On the Dialog Layout tab, select FilterListControl.
  10. Click the ellipsis button to display Control properties.
  11. Update the Filter group to (MFS-MAI) Customer - Service History - Standalone Equipment List.
  12. Click Close.
  13. From Groups, select Installed Equipment.
  14. On the Dialog Layout tab, select List with the column EquipmentAccount.EquipmentAccountID.
  15. Click the ellipsis button to display Control properties.
  16. Replace the current user defined data with this sample user defined data: 
    {"headerCol":["ModelDescription"],"itemsCol":[["ProductNo","SerialNumber"],"Status"],"mainTableId":"291E1DAB-504D-49B7-AF80-F24ABDF07FBA","params":["ParentPrimaryKey"],"sql":"select e.PrimaryKey,p.ProductNo,e.SerialNumber,e.Status,e.EquipmentNumber,e.ModelDescription,a.AccountNumber,a.Name1,el1.City from Equipment e left join Product p on e.ProductID=p.PrimaryKey left join EquipmentAccount ea on e.PrimaryKey=ea.EquipmentID left join Account a on ea.AccountID=a.PrimaryKey left join EquipmentLocation el1 on e.OriginIdentity=el1.OriginIdentity left outer join EquipmentLocation el2 on el1.OriginIdentity=el2.OriginIdentity and strftime('%Y-%m-%d %H:%M:%f', el1.StartDATE)>strftime('%Y-%m-%d %H:%M:%f', el2.StartDATE) where el2.StartDATE is null and e.Status>=10 and e.Status<90 and a.PrimaryKey='\{0}

' order by p.ProductNo,e.SerialNumber"}