I'm not sure what your exact situation is but if you want to go in through the front door, you can setup a custom UI form for the UD table using Epicor.Mfg.UI.UDxxEntry.dll (replacing xx with the UD table number) as the program in Menu Maintenance. You can customize the form as needed. Then for mass updates, copy your data to Excel, update as needed outside the system, use paste insert or paste update in list view to write the data in the UD table.
None of the Epicor logic is based on the UD tables so you aren't bypassing any business rules. Assuming you don't have any customizations/BPM based on the UD table, you will not mess up anything with a proper formatted ODBC update query.
None of the Epicor logic is based on the UD tables so you aren't bypassing any business rules. Assuming you don't have any customizations/BPM based on the UD table, you will not mess up anything with a proper formatted ODBC update query.
--- In vantage@yahoogroups.com, Thomas Rose <t.rose@...> wrote:
>
> I access the Vista tables a lot to get information I need. I am extraordinarily careful to never update any of the Epicor defined tables, only read them. However, there seems to be some opinion that one may safely update user defined tables without adverse consequences (assuming, of course, that one does not put garbage into the tables). My biggest concern is that Epicor would refuse to help me if I am updating the database from outside the Epicor defined system. I know they might do that if I update the tables they define, but will they have a problem if I only update user defined tables from outside the system?
>
> Thom Rose
> Controller
> Electric Mirror LLC
> HOTEL LUXURY
>
> "The World Leader in Back-lit Mirrors & Mirror TV Technology"
>
> T 425 776-4946
> A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electricmirror.com>
>
>
>
> [Non-text portions of this message have been removed]
>