Hi,
How to update a extended user defined table using a BAQ? If I create a regular BAQ, I cannot see the user defined table. If I create a external BAQ, I do see the table but I don;t seem to be able to get the update working: I don;t see the Business Object that would allow me to update the extended user defined table.
Thank you,
Daniel Cardoso
You can see a UD field in a BAQ. If you can’t see it you haven’t completed the data model Regen on the server.
It should show up, what field did you add?
You may need to close and reopen Epicor to get it to show up. Not sure on that though.
Also, I’m assuming you know that the added fields show up on the table you added it to. It’s part of the epimagic. You treat it like it’s actually on the parent table.
The UD table doesn’t show up there. Look in the OrderHed table. Your custom field will be in there.
What field did you create? If you didn’t make a field, there is nothing to see.
Thank you, I got it to work! My mistake was to expect to see the UD table, not the field attached to the base table.
And it might not show alphabetically. It might be at the very end of tge field list.
Glad you got it figured out.
Actually, what is interesting is that if I bring OrderHed to a BAQ, I see my UD field but if I bring the same table to a External BAQ, I do not see the UD field…
I haven’t done external BAQs, but you might have to handle the link outside of Epicor. The Epimagic will only work inside Epicor.
Probably, thank you for the help anyway, I was getting nuts with…
External BAQ isn’t looking at your data model. You are looking at the ERP.OrderHed table if you change your schema to dbo.OrderHed the us field will show in the external baq.
By the way Checkout the Ice and Customization guides available online as well as the online help most of these questions and many many more are covered there.
