Missing Joins for BAQ usage - an IDEA for you to vote on and comment on

But for the actual original idea - this is great. I’ll certainly come up with a list and put it on Ideas.

I’ll do this if need be but one that will take some time is:

TranGLC to (anything that can connect to it)

Ditto for EntityGLC. (There are spreadsheets for these on the Epic-world somewhere, I think.)

And in recent memory, this is a far more bizarre one: PartBin to Warehouse to PartPlant.

Also, the way to get the standard cost of a part (or average cost, etc.) is on par with that.

Again, I understand the place for the details of that is Ideas, not here. I’m just brainstorming.

EDIT: So on that note, something well beyond this discussion is, it would be amazing if the BAQ editor might say “I see you are trying to join PartBin to PartPlant. The best-practice way to do that is like this…” (Gently implying that you probably should not do so directly - it’ll work in a one-warehouse setup, but not when you exand down the road…)

6 Likes