E9: How to determine FIFO Lot cost - which table?

> How did you link to PartTran
>to get the inventory cost of the part/lot?
When I use PartTran, it is for the history, (auditors).
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]
>
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]
Hi Joe,

I think I used the PartTran table.
Maybe other people know of a different table(s)?

--- In vantage@yahoogroups.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]
>
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]