I'd approach this by writing a query against the ECH and ECL tables
selecting records that are closed with zero shipments against them.

-----------------------------------
George Sagen
MITY Enterprises, Inc.
1301 West 400 North
Orem, UT 84057
(801) 224-0589 ext. 442 Office
(801) 360-6360 Cell
(801) 224-6191 Fax
georges@xxxxxxxxxxxx
http://www.mitylite.com

CONFIDENTIALITY NOTICE: This email and any attachments are for the
exclusive and confidential use of the intended recipient. If you are not
the intended recipient, please do not read, distribute or take action in
reliance upon this message. If you have received this in error, please
notify us immediately by return email and promptly delete this message
and its attachments from your computer system. In the case that a
confidentiality agreement exists between MITY Enterprises, Inc. or any
of its subsidiaries and the recipient(s), use of the information
contained herein is governed under the terms of the agreement.

"William Couch" <wcouch@xxxxxxxxxxx> 5/4/2007 12:28 PM >>>
Does anyone know a way to capture the value of the orders entered and
cancelled for a select month?





Bill




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.