Is it possible to include a contract's last status's reason code on a report

I'm creating a report on contracts that are in an amendment or addendum status, and I want to include the reason code to explain why they are in those statuses. Near as I can tell, the Reason Code drop into a void and the only way to get at it is through the 3-dots > Audit Log. Does anyone know if the reason code that explains a contract's status can be retrieved?

Find more posts tagged with

Accepted answers

steve-machovsky

Hi Jhedal- use configuration to create a Derived Field like this-

Then add the field to your list like this (my example is on a list)-

It will then display like this-

All comments

steve-machovsky

Hi Jhedal- use configuration to create a Derived Field like this-

Then add the field to your list like this (my example is on a list)-

It will then display like this-

jhedahl

Thank you Steve, that works great! Do you know what the derived field's code needs to be if I wanted to make it a boolean field instead and it returns true or false?

Contract is a BusinessClass

owned by po

Derived Fields

IsReasonCodeChangeExpiration is a DerivedField

type is Boolean

for each audit log records

if (each.reason code = "CHANGE EXPIRATION")

return true

else

return false

steve-machovsky

I think you could try changing the field to something like this

jhedahl

Thank you Steve, that worked out. I really appreciate your help

Update: I just realized this code won't work. I think I'll go back to returning the last reason code entered and validate it's "CHANGE EXPIRATION" in the flows JavaScript.

Copyright © 2025 Infor. All rights reserved.