Linking PM20000 and GL20000 1

[RickSchultz]

I'm trying to build a query to get GL transaction data merged with some data from the subledgers. I can't seem to find a combination of unique fields in GL20000 to allow me to link to PM20000 (and, of course, PM30200). What fields should I use to link them?

 

[klewis10367]

You have to also use the PM10100 (Open/Work..Distribution Table) and PM30600 (History Distribution) link the dstindx to the actindx on the gl20000. So link GL20000<PM10100<PM20000 for Open, then GL20000<PM30600<PM30200 for History.