Is the Sales Order Backlog report insufficient for your needs? It will at least tell you when future sales will occur. It won't give you changes, except that it will report the latest changed information.
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The World Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<
http://www.electricmirror.com>
Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com] On Behalf Of Jasper Recto
Sent: Friday, August 21, 2009 1:57 PM
To: '
vantage@yahoogroups.com'
Subject: RE: [Vantage] Daily Booked orders
I also need to get any changes to existing orders. If I just look at the order table, how would I know what changes have been made to existing orders?
I want to be able to report on all new and change orders and be able to report how much the change was and when the sales will occur.
Any ideas?
Thanks,
Jasper
________________________________
From:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Randy Weber
Sent: Friday, August 21, 2009 4:28 PM
To:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Daily Booked orders
Try using OrderHed.OrderDate along with OrderDtl.DueDate
Randy Weber
From:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
Of Jasper Recto
Sent: Friday, August 21, 2009 3:00 PM
To: Vantage Groups (
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Daily Booked orders
Does anybody have any idea how I can create a report that shows me all
orders booked each day and is due within the year.
The bookdtl table gives me all the information except that it does not
identify when the sales will occur. It only shows the First release date
and associates all sales on that day.
Any ideas on how I can figure this out?
Thanks,
Jasper
[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]
[Non-text portions of this message have been removed]