Where can I find the info n how to add a custom field to a table? I am needing to add a filed to the Customer table. My predecessor setup somethings that we use and they want me to add another Name_c to the table.

It is well documented in the On Line help Search for " Create the User-Defined Table" then back up one level [image]

Search the help for “Developing a Modified Version of an Epicor Shipped SSRS Report” for a good step-by-step example of adding a UD field to a table, and then adding that field to an Epicor supplied report

[image] ckrusen: Create the User-Defined Table Side note, When you do a Data Regeneration, does that interfere with other Epicor Users? I am assuming yes, but I have been known to be wrong. Normally I do it outside of business hours, but If I can do it during, this would help me out today tr…

That is a question that inspired lots of opinions… [image] Regenerate Data Model while DB is in use ERP 10 Is there any danger to regenerating the data model (because UD fields were added), while people are using the system? And what about letting users use it in between…

Well, I’ll just wait. No need to have any potential of any problems! Have enough without creating my own!!

In conclusion … The basic steps are: Extended UD Table Maintenance Regen data model Recycle App Pool Which of these can be done while users are: Users are logged in Users are performing transactions Scheduled processes are running And what about the periods between those basic steps? Is it o…

You definitely want to do steps 1-3 all at the same time - don’t leave time between them, this can definitely cause problems. If you’ve added the fields but not done a Data Model Regen, then the running app server knows nothing about that new field. Following on from that, if you’ve done the Data …

Add Custom Field

Epicor ERP 10

ckrusen (Calvin Krusen) September 6, 2019, 4:02pm 5

That is a question that inspired lots of opinions…

Topic		Replies	Views
How can I add a user defined column to an existing table? Epicor ERP 10 e10	4	7979	November 13, 2018
Extended User Defined Table Maintenance Epicor ERP 10	8	4207	June 2, 2017
10.2.200 UD Fields Epicor ERP 10	30	6043	August 23, 2018
Adding additional fields to the UDxx tables Epicor ERP 10 e10	4	1582	June 17, 2021
Steps to extended Tables in Epicor Epicor ERP 9 features , epicor , customization	1	1050	July 24, 2017

Add Custom Field

Related topics