Virginia
We only ever sell one item per line, I am sure the data is in the tables
below.
Cheers
Andrew
We only ever sell one item per line, I am sure the data is in the tables
below.
Cheers
Andrew
On 12 July 2010 13:26, Virginia <vjoseph@...> wrote:
>
>
> Hello Andrew: How does your report account for a line that has multiple
> quantities and unit prices?
>
> Thanks,
> Virginia
>
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Andrew
> Marshall <apm545@...> wrote:
> >
> > Hello
> >
> > We had the same issue, I ended up writing a crystal report which used a
> sub
> > report to calculate the cost. The data is in tables quotedtl, quotemtl,
> > quoteopr.
> >
> > Regards
> >
> > Andrew Marshall
> > Premier Hytemp Ltd
> > UK
> >
> > On 6 July 2010 18:45, Virginia <vjoseph@...> wrote:
> >
> > >
> > >
> > > Hello: Version 8.03.408 - We have been looking at how to report quoted
> > > margins for a while and unfortunatley have not been successful at
> accessing
> > > this information. Has anyone been successful at creating a report or
> > > dashboard that displays the quoted profit margin (field is labeled
> Quoted
> > > Profit on the worksheet) for each line in the quote?
> > >
> > > Here is what we are trying to do. The sales department relies heavily
> on
> > > the quote status dashboard to follow-up on open quotes and the sales
> manager
> > > uses it to review the daily quote activity. We modified the dashbord to
> > > include a calculated field for the line value based on
> > > QuoteDtl.SellingExpected and QtyQuoteDtl.ExpUnitPrice and now we now
> want to
> > > add the corresponding quoted profit for the same expected selling
> quantity.
> > >
> > > On the worksheet in Opportunity / Quote Entry, if I use customization
> to
> > > identify the field I want to use, it tells me the field is
> > > QuoteQty.QuotedProfit. However, when I go to the data dictionary, the
> > > QuoteQty table does not contain a QuotedProfit field. Any ideas why it
> does
> > > not exist in the data dictionary?
> > >
> > > We have also been looking at doing a calculated field using the the
> variety
> > > of cost fields that are available in the QuoteAnalysis table. According
> to
> > > help you use the Quote Analysis Export to create analysis files based
> on
> > > quotes. Running the quote analysis export menu option puts information
> from
> > > the quote tables into a single table, QuoteAnalysis, which can then be
> used
> > > for analysis. The problem is that when I run the export for all our
> quotes
> > > (currently only 1,980) I receive an error that says "The maximum size
> of the
> > > input data is 32k. If you need more than that then please use input
> > > TEMP-TABLES". Maybe I should, but I am not sure what means.
> > >
> > > Any help would be greatly appreciated. Since this is a detailed
> problem,
> > > please feel free to contact me directly at 440-543-8157.
> > >
> > > Thanks,
> > > Virginia
> > >
> > > Virginia Joseph
> > > Deep Hole Specialists
> > > 440-543-8157
> > > vjoseph@... <vjoseph%40deephole.com>
>
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
[Non-text portions of this message have been removed]