I've got a backlog report in Report Builder that has 4 columns for
release months, and a column for remaining. You should be able to
run it for any time in past. Three Rows further categorize the data
by product code grouping.
Five calculated fields have to be edited for the column date ranges.
If anyone interested, email me off list for a copy and further
description.
If a moderator is listening, let us know when we'll have more upload
space.
Lonnie
release months, and a column for remaining. You should be able to
run it for any time in past. Three Rows further categorize the data
by product code grouping.
Five calculated fields have to be edited for the column date ranges.
If anyone interested, email me off list for a copy and further
description.
If a moderator is listening, let us know when we'll have more upload
space.
Lonnie
--- In vantage@y..., "Chris Reed" <chrisr@p...> wrote:
> Hi Shirley
>
> My idea is for the report to reflect the value of outstanding sales
orders
> at a point in history to assess those book values against current
levels. I
> have the idea that the report should return for the period by
filtering on a
> single date
>
> If you check out the Vantage canned report >Sales Management>Order
> Management>Reports>Sales Order Backlog, accept the defaults except
uncheck
> the Print Order Release Detail that's pretty much it, but I want
the ability
> to view it retrospectively i.e. what was our order book looking
like six
> months ago.
>
> Does this help? If not let me know and I'll try a different tack.
>
> Many thanks
>
> Chris
> PWSL
>
> -----Original Message-----
> From: Shirley Graver [mailto:shirleyg@R...]
> Sent: Thursday, January 24, 2002 1:30 PM
> To: vantage@y...
> Subject: RE: [Vantage] Order Book Value Report
>
>
> Chris,
> I've taken a quick look, my first impression is to forget about
Report
> Builder. This can only be done in crystal using odbc. It looks
like its
> something that I'd find useful also. A couple of questions though,
can you
> give me a little more detail on what you're looking for, how it
would be
> used and the kinds of time periods you have in mind. Anything else
that you
> have in mind as far as how such a report would be used would help.
>
> Shirley
> -----Original Message-----
> From: Chris Reed [mailto:chrisr@p...]
> Sent: Tuesday, January 22, 2002 9:18 AM
> To: vantage@y...
> Subject: Re: [Vantage] Order Book Value Report
>
>
> Does anyone have a Sales Order Value report, similar to the
canned Sale
> Order Backlog report they're prepared to share?
>
> I'm looking for a summarised period on period report for
comparisons.
> Currently running v4.
>
> Thanks
>
> Regards Chris Reed
> Professional Welding Services Limited
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/