Could someone please help me understand this error and possibly present a solution?
Error message:
An error occurred and the transaction is stopped. Contact your administrator or partner for further assistance.
The following AL methods are limited during write transactions because one or more tables will be locked: Form.RunModal, Codeunit.Run, Report.RunModal, XmlPort.RunModal.
Form.RunModal is not allowed in write transactions.
Codeunit.Run is allowed in write transactions only if the return value is not used. For example, 'OK := Codeunit.Run()' is not allowed.
Report.RunModal is allowed in write transactions only if 'RequestForm = false'. For example, 'Report.RunModal(...,false)' is allowed.
XmlPort.RunModal is allowed in write transactions only if 'RequestForm = false'. For example, 'XmlPort.RunModal(...,false)' is allowed.
Use the commit method to save the changes before this call, or structure the code differently.
Contact your application developer for further assistance.
Happening when we:
- try to generate an Inventory Pick from a Sales Order
- try to enter the planning page from a Sales Order
- Try to attach documents using the action bar (working okay from the factbox)
AL call stack:
"Sales Header"(Table 36).CreateInvtPutAwayPick line 24 - Base Application by Microsoft version 27.4.45366.47325
"Sales Order"(Page 42)."Create Inventor&y Put-away/Pick - OnAction"(Trigger) line 3 - Base Application by Microsoft version 27.4.45366.47325
AL call stack:
"Sales Order"(Page 42)."Pla&nning - OnAction"(Trigger) line 5 - Base Application by Microsoft version 27.4.45366.47325
AL call stack:
"Sales Order"(Page 42)."DocAttach - OnAction"(Trigger) line 7 - Base Application by Microsoft version 27.4.45366.47325
Thank you