Make Role required for Transaction Entry

[Anon Anon]

Is it possible to make the Role attribute required when you create a Transaction entry?  This field tends to get missed and is required for our transactions.  I have looked under the Admin/ Objects but do not see where I can make the field required.

 

[John Fechenbach]

The short answer is that no, this is not a configurable object, especially in an On Demand environment.  In an On Premise environment, you can use a VERY unsupported approach with a database trigger, but it is not recommended.  If you really, really need this, and you have a fair number of manual transaction entries to do (and if that is the case, you should really be looking into an automated feed), you can create a transaction entry object.  That will allow you to make any of the fields required, or with other rules as may be needed.  When the user Submits the entry, a process will run to XOG in the transaction entry...and, if you want the additional sophistication, you could even have that submittal go to a designated person(s) for approval before it is entered into the system.

 

John  

[mike2.2]

But I love triggers!

[Anon Anon]

Michael,

 

Can you expand on how would a trigger work for this?

[Anon Anon]

Thanks for the feedback John!

[Kathryn Ellis]

If your matrix is using Role to determine cost rates and it is missing from the transaction entry by leaving the rate and cost fields empty AND if the matrix does not have a default / catch-all row, then when you try to save the transaction you should get an error message to indicate you have to manually enter a cost/rate value. 

ERROR - REVMGR-20242:Cost and/or Rate must be entered. 

[Anon Anon]

Kathryn,

 

Thanks for your input.  We use the role to determine cost rates for FTE's, but for contractors we use their ID since each contractor has their own specific rate.  We create transactions for contractors so unfortunately your suggestion to not have a catch all row won't work for us.

 

It seems like for now it's just a training issue to make sure people remember to select the Role.

 

Garrett