IBM Support

Duplicate Actual Services with the Work Order Details report

Troubleshooting


Problem

Duplicate Actual Services appear on the Work Order Detail Report

Symptom

When you print the Work Order Detail report and some services appear more than once.

Cause

This is because these received services are on a PO that has revisions.

Resolving The Problem

To resolve this issue, open the report in the Eclipse Designer. In the open script for the actualServicesDataSet, add an additional statement to the where clause: and servrectrans.porevisionnum = po.revisionnum.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21701322