Actual Material Price Vantage 6.1

Been awhile but if I remember correctly I get it from the JobAsmbly table set to assembly level zero and then add the ThisLevel figure to the LowerLevels amount for material cost. The important part in report for JObs that are accumulating other amounts is to filter for assembly level zero so that the other costs are not multiplied buy the number of levels on the part.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Abe Klassen
Sent: Tuesday, September 05, 2006 12:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Actual Material Price Vantage 6.1




I am looking for the field that contains the actual material price for parts in a job. I have been using the Jobmtl.estunitprice field but if the price is changed later my numbers are not accurate. I know it does exist because Vantage uses it in the canned Production Detail Report.

Thank you,
Abe Klassen

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
I am looking for the field that contains the actual material price for parts in a job. I have been using the Jobmtl.estunitprice field but if the price is changed later my numbers are not accurate. I know it does exist because Vantage uses it in the canned Production Detail Report.

Thank you,
Abe Klassen

[Non-text portions of this message have been removed]
I use JobMtl.TotalCost, but you should read the data dictionary about
this field to make sure it is what you want.
I think there is field called total cost, depending on your costing
methods. But I think it doesn't include some credit costs such
salavage. The data dictionary should give you a better idea.

--- In vantage@yahoogroups.com, "Abe Klassen" <ak@...> wrote:
>
>
> I am looking for the field that contains the actual material price
for parts in a job. I have been using the Jobmtl.estunitprice field
but if the price is changed later my numbers are not accurate. I know
it does exist because Vantage uses it in the canned Production Detail
Report.
>
> Thank you,
> Abe Klassen
>
> [Non-text portions of this message have been removed]
>