Objective:
To display the status memo of the current status in record.For any object having status functionality the status history is tracked in different table, for example Work Order status will be tracked in WOSTATUS table.
To display the memo entered for the current status in the application can be done using relationships and application designer application.
Example:
Display current PO status memo in PO application.
Steps:
- Create a relationship from PO to POSTATUS with where clause as below:
Name of the relationship: CURRENTSTATUSponum = :ponum and siteid = :siteid and status = :status and changedate = :statusdate
- In the application designer for PO application add the attribute and give the attribute value as CURRENTSTATUS.MEMO, where CURRENTSTATUS is the relationship name from PO to POSTATUS.
Does this apply for the Asset Module?
ReplyDeleteYes. It will work for any statefulmbo. You need to give the correct where clause in the relationship between the main object and the status history object.
DeleteFor ASSET, the relationship should be from ASSET to ASSETSTATUS and the where clause should be
assetnum=:assetnum and siteid=:siteid and status=:status and changedate=:statusdate