I would try Epicor support or EpicWeb first.
Here is part of an old answerbook 259.2236MPSS.
But it is for V5 & I think too many things have changed since then.
Here is part of an old answerbook 259.2236MPSS.
But it is for V5 & I think too many things have changed since then.
>>QM - How Costs are calculated on the Quote Worksheet
>>Detail Unit Cost: Quote Quantity of One
>>
>>Labor Cost:= [(Production PLR / Production STANDARD)+(Setup PLR x >>Setup
>>STANDARD)]
>>
>>Burden Cost:= [(Production PBR / Production STANDARD)+(Setup PBR x >>Setup
>>STANDARD)]
>>
>>Total Cost: (Labor Cost + Burden Cost) x Quote Quantity
>>
>>Detail Unit Cost: Where Quote Quantity of 'n' is greater than One
>>
>>Labor Cost:= {(Production PLR / Production STANDARD)+[(Setup PLR x >>Setup
>>STANDARD)/n]}
>>
>>Burden Cost:={[(Production PBR / Production STANDARD)+[(Setup PBR x >>Setup
>>STANDARD)/n]}
>>
>>Total Cost: (Labor Cost + Burden Cost) x Quote Quantity
>>
>>Assembly Totals:
>>
>>Quantity: Quanity quoted (setup on Quote Line Detail)
>>Setup Hours: Sum of all Setup hours per Operation
>>Production Hours: Sum of all Production hours per Operation
>>Material Cost: Sum of all Material costs per operation (including >>scrap)
>>Labor Cost: Sum of all Detail Unit Labor Costs
>>Burden Cost: Sum of all Detail Unit Burden Costs
>>Subcontract Cost: Sum of all Subcontract Costs per Operation
--- In vantage@yahoogroups.com, Mike Abell <mabell@...> wrote:
>
> Anyway to "figure out" what the details of the "on the fly" calculation are? Anyway to view a "EpiCor view" detail?
>
> Mike Abell
> Systems Analyst / Network Administrator
> Flexial - BOA Group - Cookeville, Tennessee
> Office: 931.432.1853 ext 302
> Mobile: 615.418.3055
> email: MAbell@...
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
> Sent: Friday, March 22, 2013 3:53 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage 8.03 Quote Costing Detail table location
>
>
>
> >> BUT the fields that are mentioned
> >> for the total costs
> I think QuoteQty used in the Quote form is an Epicor view.
> So the the totals are calculated on the fly and not stored in QuoteQty table.
> I expect you'll need to duplicate each of these as calculated fields in your BAQ or report.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Mike Abell <mabell@<mailto:mabell@>> wrote:
> >
> > Thanks guys but the odd thing is in the customization for Quote Tracker it
> > does indeed reference the QuoteQty table BUT the fields that are mentioned
> > for the total costs of the Material, Labor, Burden, SubContract are NOT in
> > the QuoteQty table when I look at it Data Dictionary so I'm not sure what
> > the deal is there. Any ideas?
> >
> >
> >
> > Mike.
> >
> >
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
> > b_ordway
> > Sent: Friday, March 22, 2013 1:56 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Vantage 8.03 Quote Costing Detail table location
> >
> >
> >
> >
> >
> > I think the QuoteQty table might be what you are looking for.
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , Mike
> > Abell <mabell@> wrote:
> > >
> > > Can someone give me some insight to what table contains the costing
> > information that shows up in quote tracker under the "worksheet" tab. I'd
> > like to use those costs in a report but can't find the data. Thanks!
> > >
> > > Mike Abell
> > > Systems Analyst / Network Administrator
> > > Flexial - BOA Group - Cookeville, Tennessee
> > > Office: 931.432.1853 ext 302
> > > Mobile: 615.418.3055
> > > email: MAbell@
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>