This helped with a previous question I posted, so thank you for the information. It turns out that another problem has presented itself though and the fields are all generic text fields, so when you convert it to the field type necessary for the join, you lose indexing ability. The PONum is an Integer field. But in the table, it's a String(50) field.
Any other thoughts? Again, I am simply (ha) trying to generate a purchase order report detailing purchases by supplier, with cost and GL account.
Any other thoughts? Again, I am simply (ha) trying to generate a purchase order report detailing purchases by supplier, with cost and GL account.
--- In vantage@yahoogroups.com, "Chris Robisch" <bluewine@...> wrote:
>
> Due to the expansion of the GL fields to 50 characters, rather than changing
> the old files, they moved the GL info to the TranGLC. Whatever file you're
> using now has pointers to that file, be it PO Number etc.
>
> And remember if you can see the GL Account on the screen, you can typically
> use Field Help to see where it resides.
> ----- Original Message -----
> From: "Brian Roberts" <broberts@...>
> To: <vantage@yahoogroups.com>
> Sent: Monday, March 21, 2011 8:22 AM
> Subject: [Vantage] Vantage 6.1 -> 9.05 PartTran schema differences
>
>
> > We have a custom report in Vantage 6.1 that pulls data from the PartTran
> > table for ADJ-CST transactions and looks at the GLChart and GL2Chart
> > fields in that table. Those fields no longer exist in the Epicor 9.05
> > schema and I can't find the link from PartTran to the GL. There is the
> > JournalCode & JournalNum fields, but they are zero for some the records
> > I'm looking at. Am I looking in the wrong place?
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Brian Roberts
> >
> > Business Systems Analyst
> >
> > Ground Effects Ltd
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
> >
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 10.0.1204 / Virus Database: 1498/3520 - Release Date: 03/21/11
> >
>