Hello! I am new to Epicor but have lots of coding experience. I am wondering how to go about writing code to update an epicor database, specifically the Ice.Memo database. I want to add a button to the MES screen that does this automatically.
Generally speaking we do not update the database through code. We use directives and functions. Use data directives to trigger an event based on changes to a specific data field. Use method directives to trigger an event based on another method firing.
Turn on tracing before you perform an action in Epicor to see the methods and data that Epicor uses. Then you can use similar methods and data in your own directives.
The ice.Memo field can be a tricky one due to all the other forms it can link to. Open a BAQ and study the format of the table for a while to ensure you understand where the key fields are. Once you have that, turn on tracing, then perform an action that submits a memo (like add a new memo to a sales order or whatever). After you stop the tracing and look at the output log file, you should see a list of methods that Epicor used to submit the memo. You will have to use the same approach.
This tool is incredibly helpful for this task: Trace Helper Utility for Epicor ERP 10 - Epicor ERP 10 - Epicor User Help Forum
Once you get through all that, you can begin toying around by creating a UBAQ in your pilot database. Use advanced BPM processing to create a BPM that adds records the way you want. If that works well, then you know you are on the right track. Now just convert what you did in a UBAQ into the correct data or method directive.
Good luck!
1 Like