If you are using a BAQ then you can simply join the TranGLC table using Key1, Key2 and Key3 as the POnum, Line, Release.
However, If you are using ODBC you will NOT be able to make a direct join using Crystal becuase the PORel.PONum is a number field and the TranGLC.Key1 field is a String (or text) field. You will have to use a subreport to "lookup" the chart info.
DaveO
However, If you are using ODBC you will NOT be able to make a direct join using Crystal becuase the PORel.PONum is a number field and the TranGLC.Key1 field is a String (or text) field. You will have to use a subreport to "lookup" the chart info.
DaveO
--- In vantage@yahoogroups.com, Scott Lepley <scott.lepley@...> wrote:
>
> You probably need to include a link to the TranGLC table now.
>
>
>
> Regards,
> Scott
>
>
>
> *From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On Behalf
> Of *bebright@...
> *Sent:* Wednesday, October 05, 2011 9:11 AM
> *To:* vantage@yahoogroups.com
> *Subject:* [Vantage] GL Info from Part Tran
>
>
>
>
>
> I had a Crystal Report in Vantage 8 that used the GL information from the
> PartTran table. However, in Epicor 9, I don't seem to see any of the GL
> information in the table like I saw in 8.
>
> I need a way to link the transaction to some GL. Any suggestions?
>
>
> [Non-text portions of this message have been removed]
>