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.

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]

> >

>