Demand VS On Hand

Thanks, I think I may have it or be close anyway with what Dick told me to
do..... I will let you all know if I get it and if you want it I will
upload the PRL...

Thanks for all the help!

Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Friday, March 18, 2005 2:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Demand VS On Hand


Well that makes sense, unfortunately I do not think I have anything.
It would not be a hard to do though just use a sub report to get the
inventory and then on the main report sum up demand.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Colette Nunn [mailto:cnunn@...]
Sent: Friday, March 18, 2005 3:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Demand VS On Hand



The comptroller doesn't want all that detail... she just wants to see what
we have in inventory that we don't have orders for in a neat little
package.......

Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Friday, March 18, 2005 2:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Demand VS On Hand


Dumb question but why not just use time phase?

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Colette Nunn [mailto:cnunn@...]
Sent: Friday, March 18, 2005 3:26 PM
To: Vantage
Subject: [Vantage] Demand VS On Hand



Does anyone have a report that they would be willing to share that shows
Demand VS Qty on Hand? I would appreciate it if you do.

Thanks
Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...



[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views
of the sender and not necessarily the views of the company. The email and
any files transmitted with it are confidential to the intended recipient at
the e-mail address to which it has been addressed. It may not be disclosed
or used by any other than that addressee, nor may it be copied in any way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized alteration.
This e-mail has been prepared using information believed by the author to be
reliable and accurate. Unless expressly stated otherwise, this e-mail does
not form part of a legally binding contract or agreement between recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).



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


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
----
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. 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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views
of the sender and not necessarily the views of the company. The email and
any files transmitted with it are confidential to the intended recipient at
the e-mail address to which it has been addressed. It may not be disclosed
or used by any other than that addressee, nor may it be copied in any way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized alteration.
This e-mail has been prepared using information believed by the author to be
reliable and accurate. Unless expressly stated otherwise, this e-mail does
not form part of a legally binding contract or agreement between recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).



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


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
----
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
Does anyone have a report that they would be willing to share that shows
Demand VS Qty on Hand? I would appreciate it if you do.

Thanks
Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...



[Non-text portions of this message have been removed]
If you answered off list, I would like a copy as well please.

Mitchell Kirby
Riten Industries, Inc.

740-333-8719 Direct
800-338-0027 Sales
800-338-0717 FAX


-----Original Message-----
From: Colette Nunn [mailto:cnunn@...]
Sent: Friday, March 18, 2005 3:26 PM
To: Vantage
Subject: [Vantage] Demand VS On Hand



Does anyone have a report that they would be willing to share that shows
Demand VS Qty on Hand? I would appreciate it if you do.

Thanks
Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...



[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
Yahoo! Groups Links
I think this information is available by joining the partplant
(allocQty) with
the PartBin (OnhandQty). (left outter join because you will probably
have parts that have
an demand where onhand quantity is zero. Should be easy to do.
regards,
Dumb question but why not just use time phase?

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Colette Nunn [mailto:cnunn@...]
Sent: Friday, March 18, 2005 3:26 PM
To: Vantage
Subject: [Vantage] Demand VS On Hand



Does anyone have a report that they would be willing to share that shows
Demand VS Qty on Hand? I would appreciate it if you do.

Thanks
Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...



[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
The comptroller doesn't want all that detail... she just wants to see what
we have in inventory that we don't have orders for in a neat little
package.......

Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Friday, March 18, 2005 2:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Demand VS On Hand


Dumb question but why not just use time phase?

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Colette Nunn [mailto:cnunn@...]
Sent: Friday, March 18, 2005 3:26 PM
To: Vantage
Subject: [Vantage] Demand VS On Hand



Does anyone have a report that they would be willing to share that shows
Demand VS Qty on Hand? I would appreciate it if you do.

Thanks
Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...



[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views
of the sender and not necessarily the views of the company. The email and
any files transmitted with it are confidential to the intended recipient at
the e-mail address to which it has been addressed. It may not be disclosed
or used by any other than that addressee, nor may it be copied in any way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized alteration.
This e-mail has been prepared using information believed by the author to be
reliable and accurate. Unless expressly stated otherwise, this e-mail does
not form part of a legally binding contract or agreement between recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).



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


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
----
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
Well that makes sense, unfortunately I do not think I have anything.
It would not be a hard to do though just use a sub report to get the
inventory and then on the main report sum up demand.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Colette Nunn [mailto:cnunn@...]
Sent: Friday, March 18, 2005 3:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Demand VS On Hand



The comptroller doesn't want all that detail... she just wants to see what
we have in inventory that we don't have orders for in a neat little
package.......

Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Friday, March 18, 2005 2:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Demand VS On Hand


Dumb question but why not just use time phase?

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...



-----Original Message-----
From: Colette Nunn [mailto:cnunn@...]
Sent: Friday, March 18, 2005 3:26 PM
To: Vantage
Subject: [Vantage] Demand VS On Hand



Does anyone have a report that they would be willing to share that shows
Demand VS Qty on Hand? I would appreciate it if you do.

Thanks
Colette Nunn
Director of Computer Services
East Moline Metal Products
1201 7th Street
East Moline, IL 61244
Phone: 309-752-1381
Fax: 309-752-1382
E-mail: cnunn@...



[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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views
of the sender and not necessarily the views of the company. The email and
any files transmitted with it are confidential to the intended recipient at
the e-mail address to which it has been addressed. It may not be disclosed
or used by any other than that addressee, nor may it be copied in any way.
If received in error, please delete and notify the sender via e-mail or
sales@... quoting the name of the sender. Messages sent via this
medium may be subject to delays, non-delivery and unauthorized alteration.
This e-mail has been prepared using information believed by the author to be
reliable and accurate. Unless expressly stated otherwise, this e-mail does
not form part of a legally binding contract or agreement between recipient
and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).



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


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
----
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. 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
Yahoo! Groups Links










<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).