Supplier

Epicor ERP 10
1

Good afternoon all,

I’m trying to build a query, SQL, for Vendor’s with GL Controls. The problem I’m having is that the GL Controls on the Supplier Maintenance are EntityGLC and there’s no tie between the Vendor table and the mysterious EntityGLC table. I understand that it’s using Key1, Key2, Etc…

I just want the Vendor ID, GL Control Type and GL Control Code tied to that Vendor.

Does anyone have an SQL query that does this or something similar?

Thanks,

Jonathan Lang

2

Edit

Whoops … I did this for Customer. Supplier should be similar

There are two possible GLContol types that can be assigned to the Supplier. “AP Acct” and “Supplier” So that might complicate things

Each customer can have a GL Control of type "AR Account" assigned to it. Each GL Control of type "AR Account" has multiple Contexts.

In a nutshell…

image

image

image

image

image
image.png834×126 2.36 KB

Here’s the result. Its just one customer, but there are 23 Contexts for the GL Control. You’ll probably want to limit it to the contexts of concern. The contexts come from

image
image.png960×527 6.45 KB

image
image.png834×126 2.35 KB

1 Like
3

Thank you Calvin,

I’ll give it a whirl!

4

If you are linking to the PartTran and TranGLC, you really need to be careful about your joins. I would pull the info from EpiCare in KB0039633 and KB0028094. The pointers are in there for effective querying and linking by transaction types.