Issue: The MO have close to status 90 and can see at PMS100 but in MMS080 it still show the record with status 90.

Solution: 

We consulted Infor on this issue and the only way is to soft delete the record in MITPLO that corresponds with the issue by updating the CONO to 999. The below script can help us in achieving this. Note that we need to replace MORIDN, MOWHLO,  MOORCA with our own value. 

SELECT * FROM MITPLO WHERE MORIDN = 'XXXXXX' and MOWHLO = '090' AND MOORCA = '101'

1 row(s) affected)

UPDATE MITPLO SET MOCONO='999' WHERE MORIDN = 'XXXXXXX' and MOWHLO = '090' AND MOORCA = '101'

1 row should be affected

Noted that we need to test this solution in PRT/SND to make sure it is working OK, and we need to have a user confirmation as CAB is needed for SQL execution in M3 Live environment(KMN).