Production Hours by Operation

The JobOper table has a nice field where it the EstProdHours are calculated. Is it the same calculation for the operation production hours? Here's what the data dictionary says for job operations:

The estimated Production run hours for internal operations (JobOper.Subcontract = No) . This is not directly maintainable. It exists so that it will be easier to display than always having to recalculate it when it is needed. It is calculated using the ProdStandard, StdFormat, StdBasis, OpsPerPart, QtyPer, EstScrap and EstScrapType.
FORMULAS:
If StdFormat = "HR" then EstProdHours = ProdStandard.
If StdFormat = "PH" then (JobOper.RunQty / Std).
If StdFormat = "PM" then (JobOper.RunQty / Std ) / 60.
If StdFormat = "OH" then (JobOper.RunQty/OpsPerPart) / Std.
If StdFormat = "OM" then ((JobOper.RunQty/OpsPerPart) / Std) / 60.
If StdFormat = "HP" then (JobOPer.RunQty/Basis) X Std.
If StdFormat = "MP" then ((JobOper.RunQty/Basis) X Std) / 60.

--- In vantage@yahoogroups.com, "Michael McWilliams" <mmcwilliams22@...> wrote:
>
> In our case this operation is always OP 20. If it is not easy to get
> I guess I will hard code it to look at the Resource Rates and
> Production Rate of the op and do the math against the quoted quantity.
>
> --- In vantage@yahoogroups.com, "Ben Belzer" <bbelzer@> wrote:
> >
> > I believe Vantage calculates this on the fly, hence the 0s in the
> > database. I haven't been able to easily get to this figure
> either... my
> > two cents.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
I am trying to find out if there is any place that holds production
hours by operation in the quote worksheet. We are trying to work
backwards to come to an operation based charge. Some customers want
to know how much we are charging them per unit for a secondary
operation and display it on the quote.
There is a quoteopdtl and a quoteopr table...try those....they link to
quoteasm table which links to quotedtl table!



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Monday, August 04, 2008 8:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Production Hours by Operation



I am trying to find out if there is any place that holds production
hours by operation in the quote worksheet. We are trying to work
backwards to come to an operation based charge. Some customers want
to know how much we are charging them per unit for a secondary
operation and display it on the quote.






[Non-text portions of this message have been removed]
I see the quoteopdtl which has a field prodhours which is supposed
to hold the hours for this sequence. The strange thing is they all
show zero, even though on the worksheet I am getting a total of the
ops.

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> There is a quoteopdtl and a quoteopr table...try those....they
link to
> quoteasm table which links to quotedtl table!
>
>
>
> M. Manasa Reddy
> manasa@...
> P: 630-806-2000
> F: 630-806-2001
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Michael McWilliams
> Sent: Monday, August 04, 2008 8:41 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Production Hours by Operation
>
>
>
> I am trying to find out if there is any place that holds
production
> hours by operation in the quote worksheet. We are trying to work
> backwards to come to an operation based charge. Some customers
want
> to know how much we are charging them per unit for a secondary
> operation and display it on the quote.
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I believe Vantage calculates this on the fly, hence the 0s in the
database. I haven't been able to easily get to this figure either... my
two cents.



[Non-text portions of this message have been removed]
In our case this operation is always OP 20. If it is not easy to get
I guess I will hard code it to look at the Resource Rates and
Production Rate of the op and do the math against the quoted quantity.

--- In vantage@yahoogroups.com, "Ben Belzer" <bbelzer@...> wrote:
>
> I believe Vantage calculates this on the fly, hence the 0s in the
> database. I haven't been able to easily get to this figure
either... my
> two cents.
>
>
>
> [Non-text portions of this message have been removed]
>