Seems to me a BAQ would work for this
First Table Part - (filter Type if desired Purch or Manuf)
Second Table PartTran (filter on TranType if desired)
On the Table Relations screen, in the WhichItem column, use the drop down box to select last.
Your query phase should resemble this:
for each Part where ( Part.TypeCode = 'P') no-lock , last PartTran where (Part.Company = PartTran.Company and Part.PartNum = PartTran.PartNum) no-lock .
First Table Part - (filter Type if desired Purch or Manuf)
Second Table PartTran (filter on TranType if desired)
On the Table Relations screen, in the WhichItem column, use the drop down box to select last.
Your query phase should resemble this:
for each Part where ( Part.TypeCode = 'P') no-lock , last PartTran where (Part.Company = PartTran.Company and Part.PartNum = PartTran.PartNum) no-lock .
--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> This is why I need a report...I need it for every single part in the
> system.
>
>
>
>
>
>
>
> Manasa
>
> 630.806.2000 x1515
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of schaeferaz
> Sent: Tuesday, June 21, 2011 7:54 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Last transaction date report
>
>
>
>
>
> Manasa,
> Can you right click on the Part Number and get a menu that has the Part
> Transaction History showing?
> That should show the transactions for the Part - you can sort it by
> date.
>
> Thank you,
>
> Stephen
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > Does anyone have a report that will tell me the date of the last
> > transaction for a part? Would you be willing to share it if you did?
> >
> >
> >
> > We are on Vista version 8.
> >
> >
> >
> > I need something quick for a bank audit.
> >
> >
> >
> > TIA!
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Manasa
> >
> > 630.806.2000 x1515
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>