> How did you link to PartTranWhen I use PartTran, it is for the history, (auditors).
>to get the inventory cost of the part/lot?
I use the PartNumber & Lot number to display the various before and after costs/qtys but...
I wasn't doing FIFO at the time.
Have you looked at the PartLot table?
It looks like it has all the FIFO fields.
There is also a table called PartLot
--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> Thank Cooner,
>
>
>
> How did you link to PartTran to get the inventory cost of the part/lot?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of cooner_55421
> Sent: Wednesday, November 16, 2011 2:43 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: E9: How to determine FIFO Lot cost - which table?
>
>
>
>
>
> Hi Joe,
>
> I think I used the PartTran table.
> Maybe other people know of a different table(s)?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Joe
> Rojas <jrojas@> wrote:
> >
> > Hello,
> >
> >
> >
> > All of our parts are either FIFO or Lot FIFO cost.
> >
> > I know that if I want to create a query to determine the average fifo
> > cost for a part, that I can use the PartCost table.
> >
> > What table do I look at to determine the cost for a specific lot? I
> > tried looking at PartFIFOCost but I couldn't determine the link to
> pull
> > the latest cost for a lot.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@ | www.matsinc.com Ask us about our clean, green and
> beautiful matting and flooring
> >
> >
> > This message is intended only for the individual named. If you are not
> the named addressee you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately by e-mail if you have
> received this e-mail by mistake. Please note that any views or opinions
> presented in this email are solely those of the author and do not
> necessarily represent those of the company.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
>
> [Non-text portions of this message have been removed]
>