Hello - We just started using the fixed asset mod...
# suiteflowl
Laura
10/14/2024, 2:57 PMHello - We just started using the fixed asset module and I am receiving an error when I run the depreciation JEs. The error is because we have the created by field in our JE approvals. INVALID_KEY_OR_REF: Invalid custbody_be_createdby reference key -4 .
I added the following to my JE workflow approval and it works in sandbox but it does not work in production.
Production is on 2024.2 and the sandbox has not been upgraded yet. Any suggestions on how to get this to work in production? TIA
m
MGBC
10/14/2024, 3:57 PMWhat actions do you have in the approved state?
MGBC
10/14/2024, 3:58 PMThis is most likely caused by an action trying to set a field value to -4 OR and email being sent with the author or recipient as -4
l
Laura
10/14/2024, 4:42 PMI do have and email action and the send from and to was "created by" (even though it was going only to one person). I changed it to send from me and only go to her but I am still receiving the error.
m
MGBC
10/14/2024, 5:14 PMYou have a script or a workflow that is setting this field value to -4
custbody_be_createdby
MGBC
10/14/2024, 5:15 PMYou need to update that action so it does not trigger if User = -4
l
Laura
10/14/2024, 5:36 PMuser -4 is the system. I added a transition that goes from entry to approved if the user is -4.which i have at before record submit. It worked fine in sandbox. I do have to set created by = current user on entry before any transitions, should I change my transition for the -4 to entry?
m
MGBC
10/14/2024, 5:58 PMYou could try that
MGBC
10/14/2024, 5:58 PMActually...transitions fire after actions, so I don't think that would work
MGBC
10/14/2024, 5:59 PMUnless you change your Set Field value to Before Load
l
Laura
10/14/2024, 7:28 PMI got it to work! I ended up putting a condition on the set value for the created by field to {user.id}!=-4 and that worked. Thank you for being a sounding board, it really helped me narrow down the issue.