How to use GL Accont Editor in UD Table?

Hi

I am trying to use GL Acconut Editor in UD Table, but there are no Data view table in customization screen to link COA, Account, Segvalue etc.

Is there anyone who has exprience to customze UD table using GL Account Editor?
I tried to map UD table fields to GLAcctDisp via Extended Property, but it doesn’t work out

Besg Regards,
John

I’m sorry but I don’t understand. Could you please explain exactly what you want to do and why?

Hi~

I will use UD table to create AP Invoice.
To do that, I need to let Epicor which GL Account to be used in AP Invoice.
So, I tried to add GL Acconut Editor which can be found in Journal Entry.
However, UD table doens’t have veiw tables to link UD filed to COA, GL Account.

Is there any solution to use GL Account Editor in UD Table?

I think your best option would be to use a baq combo from GLAccount
for the value field do a calculated filed with a replace of | with - and then concatenate that with AccountDesc as the description. If you want to limit the list to valid GL Categories you could join GLAccount to COASegValues and limit the list to the categories they can use for AP Expenses.

replace(GLAccount,'|','-') as GLAccount

Thanks for the reply!
There are dynamic segvalues as well. GL Account covers only controlled.
I am trying to use GL Account Editor which is the same as Journal Entry.
Is there other way to to use GL Account Editor in UD Table?

We have something lost in translation here.

What you are asking doesn’t make sense.

Break it down and ask a different way, in as simple terms as possible.

He wants this.
image

Which is Ice.Lib.Framework.EpiGLAccountEditor, but that is not in the toolbox.

2 Likes

I have no idea, but if the dynamic segvalues are available then they are in a table to add to the baq.

You can add EpiGLAccountEditor from ToolBox → General Items–> Choose Items

You are right.
I am trying to use same GL Account combo as in Journal Entry.

However UD table doesn’t have relevant dataview in it.

LOL. In ten years of using Epicor I never knew that was a thing.

1 Like

Because of limitation of using them, Epicor hide them

1 Like