I’m overriding on of Acumatica methods. This method is triggered when “Remove Hold” action is called. The method clears all records from Approval table. I would like to keep this records. So I have added a trigger on the table that restores any deleted record. My method is called after Remove Hold does it work. I would like to access the records restored by trigger and manipulate a certain record. What happens I can see the record exist in DB when I select from query analyzers but my method is not being informed and returns null value. How can I address this issue?
Answer
action/method is not informed of restored deleted record by trigger
+10Best answer by aaghaei
Thanks
I couldn’t override the method that resets the approval as it is one of the private protected methods buried deep down in one of the approval map classes.
instead, I removed the trigger, added a list variable to my method before calling Acumatica’s standard action, broke the link between approval table that will be rest and the current document by changing parent ref to a temp value, call Acumatica’s base method, and finally reestablishing the broken link by restoring from the list variable I kept in memory. To ensure either everything is completed as expected or fully rolled back, I put the full method in a transaction scope. This worked perfectly but was some extra work compared what could have been achieved using trigger.
+2Based on what you’re describing, I might suggest some other ideas for options instead of using a database trigger:
- Override the method, but change the part that deletes the records.
- Override the method, but write the rows to a new custom table, and let the existing method remove them from the original table. Then you can query the records from the new table, and even join to the existing table.
+10Thanks
I couldn’t override the method that resets the approval as it is one of the private protected methods buried deep down in one of the approval map classes.
instead, I removed the trigger, added a list variable to my method before calling Acumatica’s standard action, broke the link between approval table that will be rest and the current document by changing parent ref to a temp value, call Acumatica’s base method, and finally reestablishing the broken link by restoring from the list variable I kept in memory. To ensure either everything is completed as expected or fully rolled back, I put the full method in a transaction scope. This worked perfectly but was some extra work compared what could have been achieved using trigger.
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+2Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.