Sales Order Report

Yahoo Archive
1
I assume you are doing this in Report Builder. This might make it a brunette moment, add a couple of filters to your filter:

OrderHed.OrderDate = 05/19/2003
and ShipHead.ShipDate = 05/19/2003

or better yet,

OrderHed.OrderDate = 05/19/2003
and ShipHead.ShipDate = OrderHed.OrderDate

Hope this helps.

Mike Tonoyan / All American Products Co.
E-mail: miket@...


----- Original Message -----
From: "Nora Story" <Nora_Story@...>
To: "vantage@yahoogroups. Com" <vantage@yahoogroups.com>
Sent: Monday, May 19, 2003 3:04 PM
Subject: [Vantage] Sales Order Report


> I have been asked to create a report that for a given date range shows any
> new sales orders placed and any shipments made against any sales orders. I
> am having a very blonde moment and am struggling with how you would set up
> such a report so that a date filter would cover both order dates and
> shipment dates. Could someone offer a suggestion as to how to accomplish
> this?
> Thanks,
>
> =======================================================================
> Nora Story Spectra Technologies
> Project Administrator 1505 Royal Parkway
> Phone: 817-540-4475 ext.105 Euless, Texas 76040
> Fax: 817-540-4439 Nora_Story@...
> =======================================================================
>
2
Anyone have a report to print all sales orders, open or closed sorted by
customer and include the dollar value for each order. Would be a big help
as the boss wants this yesterday.
Thanks.

Ver 4.0 Build 904
--
Gary Wassing
Systems Administrator
SteelCraft Industries
519-271-4750 ext. 227



[Non-text portions of this message have been removed]
3
Gary,

I put a basic report together for you. If you want it, send me an
email and I'll reply with the file.

Lonnie

--- In vantage@y..., Gary Wassing <gwassing@s...> wrote:
> Anyone have a report to print all sales orders, open or closed
sorted by
> customer and include the dollar value for each order. Would be a
big help
> as the boss wants this yesterday.
> Thanks.
>
> Ver 4.0 Build 904
> --
> Gary Wassing
> Systems Administrator
> SteelCraft Industries
> 519-271-4750 ext. 227
>
>
>
> [Non-text portions of this message have been removed]
4
Hey everyone!

Before I begin creating another report...................does anyone already have a report that lists JobNum, Customer, then lists the Sales Order $$$'s for that job by month?

Thanks!

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

[Non-text portions of this message have been removed]
5
I have been asked to create a report that for a given date range shows any
new sales orders placed and any shipments made against any sales orders. I
am having a very blonde moment and am struggling with how you would set up
such a report so that a date filter would cover both order dates and
shipment dates. Could someone offer a suggestion as to how to accomplish
this?
Thanks,

=======================================================================
Nora Story Spectra Technologies
Project Administrator 1505 Royal Parkway
Phone: 817-540-4475 ext.105 Euless, Texas 76040
Fax: 817-540-4439 Nora_Story@...
=======================================================================