You can try using GlJrnSrc. Many GlJrnDtl records will contain multiple GlJrnSrc records showing the source of the GlJrnDtl transactions. I have used that file to track down parttran and labordtl records relating to gljrndtl, but I don't know if it contains the same detail relating to invoice records.
--- In vantage@yahoogroups.com, "jeffery_p_sanders" <jps@...> wrote:
>
> We are trying to match up the invoice detail to the journal entry detail. If you match on the InvoiceNum only and there are three lines on the invoice, you will end up with:
>
> Journal Entry 1 $5.00
> Journal Entry 1 $7.00
> Journal Entry 1 &6.50
> Journal Entry 2 $5.00
> Journal Entry 2 $7.00
> Journal Entry 2 $6.50
> Journal Entry 3 $5.00
> Journal Entry 3 $7.00
> Journal Entry 3 $6.50
>
> There are three line items on the invoice so each journal entry returns all three in the BAQ. We need to know which journal entry goes with which invoice line item.
>
> I hope this makes sense. As you can tell I am not in accounting, just trying to help create a report for the accounting group and do not understand the accounting tables in Epicor enough to figure this out.
>
> Seems to me there should be a field somewhere stating "this Journal Entry" goes to the "this invoice line item". But I guess that would be too easy.
>
> We do not use the Tax Module if that helps.
>
> Jeff Sanders
>
> --- In vantage@yahoogroups.com, "jonmurray999" <jon.murray@> wrote:
> >
> > Hi
> >
> > The field apinvdtl.invoicenum matches with gljndtl.apinvoicenum
> >
> > What are you trying to do ?
> >
> > Jon
> >
> > --- In vantage@yahoogroups.com, Brychan Williams <brychanwilliams@> wrote:
> > >
> > > Hi,
> > >
> > > In Vantage 8 there is no direct link, the records in the GLJNDTL are generated
> > > through code with no relationship. If you can work out how the code works then
> > > you could write a report. But there alot of gotchas such as tax etc.
> > >
> > > Regards
> > >
> > >
> > >
> > >
> > > ________________________________
> > > From: jeffery_p_sanders <jps@>
> > > To: vantage@yahoogroups.com
> > > Sent: Fri, 21 January, 2011 22:26:36
> > > Subject: [Vantage] APINVDTL and GLJNLDTL
> > >
> > > ÂÂ
> > > Does anyone know how to link these two tables together? I am missing a table or
> > > two somewhere in the middle.
> > >
> > > Thanks,
> > > Jeff Sanders
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>