Sorry, but I have no idea if that could be done. Although I personally haven't done it, I would think you could get what invoices were paid with a check along with the GL info. (You can find invoices paid with a check in places like the Payment Tracker and you can find what GL accounts are linked to an invoice in the Invoice Tracker. So you should be able to pull all of that together.) I'm not sure what you mean by as well as which invoices were still open at the end of July. If you want to eliminate the invoices that were paid in August from the list you could exclude any invoices dated after July (no August payments/invoices would show up) and also exclude any checks (and invoices attached to it) that were dated in August. (The Aged AP report with a cutoff date of 07/31/2013 would show what invoices were open at the end of July.) I'm the programmer here and our payables department hasn't needed much in the way of workarounds and customizations so I haven't had to dig into those tables very often. I hope this little bit of info is of some use to you, sorry I don't have more!
Sue
Sue
--- In vantage@yahoogroups.com, "senskepuff" <senske3@...> wrote:
>
> Thank you Sue.
> Before we try to tackle this (we are new to BAQs) will this allow me to create a spreadsheet that shows what Check #s paid what invoices AS WELL as which invoices were still open at the end of July?
>
> --- In vantage@yahoogroups.com, "snielsen28" <snielsen.hipco@> wrote:
> >
> > An Epicor tech sent me an Excel spreadsheet that that lists TranGLC keys. (I printed it, put it in a sheet protector and it lives where I can grab it quickly...I use it quite a bit!) The keys for APInvDtl are:
> > VendorNum = Key1
> > InvoiceNum = Key2
> > InvoiceLine = Key3
> >
> > For APInvExp and APInvMisc add InvExpSeq = Key4
> > For APInvJob add JobNum = Key4, AssemblySeq = Key5, MtlSeq = Key6
> > For APInvHed you don't need Key3
> > For APInvTax TaxCode = Key3, RateCodKey4, ECAcquisitonSeq = Key5
> >
> > Also make sure you set the criteria for RelatedToFile to the file you're linking to (APInvDtl, APInvExp, etc.) and make sure to link Company to Company before setting the links on Keys1-6. That makes a HUGE difference in the response time.
> >
> > Sue
> >
> > --- In vantage@yahoogroups.com, "cathyattechnologicsys" <cathy@> wrote:
> > >
> > > There is a field named RelatedToFile. Try ApInvExp.
> > >
> > > There are 4 type that relate to AP - they are:
> > >
> > > APAlcDtl
> > > ApInvExp
> > > APInvHed
> > > APTran
> > >
> > > Not sure what the Keys are to AP. I found the keys to the Inventory transactions on Knowledge Base on the Epicor Website.
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com, Calvin Dekker <calvind@> wrote:
> > > >
> > > > Senske3 -
> > > >
> > > > Try the TranGLC table linked to the APInvDtl table.
> > > >
> > > > HTH,
> > > > Calvin Dekker
> > > > [cid:image001.jpg@]<http://www.codabears.com/>
> > > > 630-672-7688 x1484
> > > >
> > > > *Solutions for Epicor users.
> > > >
> > > > "No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of senskepuff
> > > > Sent: Friday, August 16, 2013 12:33 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] GL Account on AP Invoice
> > > >
> > > >
> > > >
> > > > Does anyone have an idea how to get the GL Account from an AP Invoice into a BAQ? I need to provide a report to our auditors of all the checks we've writtin this year and to what account the cash disbursed relates to?
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>