How to link the PartTran table to the TranGLC table

Yahoo Archive
1
Tranglc is a special case, the data dictionary is of limited help in figuring out how to link to it. Using a BAQ Filtered on the RelatedToFile of interest and displaying the key fields is a good starting point along with posts from people that have figured it out.

Even after figuring out the linking fields, if at all possible add additional criteria to limit the records returned from PartTran and/or TranGLC, both are very big eaters.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "P" <pklein@...> wrote:
>
> if you go to the data dictionary, and look at the primary index for the 'releatedtofile' - that will tell you what key1, key2 key3 etc should be.
>
> --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> >
> > I used these in a BAQ:
> >
> > TranGLC.RelatedToFile = PartTran
> >
> > TranGLC.Key1 = PartTran.SysDate or TranDate
> > TranGLC.Key2 = PartTran.SysTime
> > TranGLC/Key3 = PartTran.TranNum
> >
> > --- In vantage@yahoogroups.com, Lori Gustafson <lori_gus@> wrote:
> > >
> > > We are trying to build a BAQ report to show our Job Cost Variance and are struggling trying to find how to link the PartTran and TranGLC tables. Does anyone know how to link these tables? We need the GL codes that were associated to the transactions�in order to find our variances.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
2
We are trying to build a BAQ report to show our Job Cost Variance and are struggling trying to find how to link the PartTran and TranGLC tables. Does anyone know how to link these tables? We need the GL codes that were associated to the transactions in order to find our variances.

[Non-text portions of this message have been removed]
3
Part tram.tranid is stored in one of the TRANGLC keys for records associated to that table
Motty

--- In vantage@yahoogroups.com, Lori Gustafson <lori_gus@...> wrote:
>
> We are trying to build a BAQ report to show our Job Cost Variance and are struggling trying to find how to link the PartTran and TranGLC tables. Does anyone know how to link these tables? We need the GL codes that were associated to the transactions in order to find our variances.
>
> [Non-text portions of this message have been removed]
>
4
I used these in a BAQ:

TranGLC.RelatedToFile = PartTran

TranGLC.Key1 = PartTran.SysDate or TranDate
TranGLC.Key2 = PartTran.SysTime
TranGLC/Key3 = PartTran.TranNum

--- In vantage@yahoogroups.com, Lori Gustafson <lori_gus@...> wrote:
>
> We are trying to build a BAQ report to show our Job Cost Variance and are struggling trying to find how to link the PartTran and TranGLC tables. Does anyone know how to link these tables? We need the GL codes that were associated to the transactions�in order to find our variances.
>
> [Non-text portions of this message have been removed]
>
1 Like
5
if you go to the data dictionary, and look at the primary index for the 'releatedtofile' - that will tell you what key1, key2 key3 etc should be.

--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> I used these in a BAQ:
>
> TranGLC.RelatedToFile = PartTran
>
> TranGLC.Key1 = PartTran.SysDate or TranDate
> TranGLC.Key2 = PartTran.SysTime
> TranGLC/Key3 = PartTran.TranNum
>
> --- In vantage@yahoogroups.com, Lori Gustafson <lori_gus@> wrote:
> >
> > We are trying to build a BAQ report to show our Job Cost Variance and are struggling trying to find how to link the PartTran and TranGLC tables. Does anyone know how to link these tables? We need the GL codes that were associated to the transactions�in order to find our variances.
> >
> > [Non-text portions of this message have been removed]
> >
>
1 Like