Onhand Quantity/Open Order Report

Yahoo Archive
1
Well! I guess I have some learning to do. In four years of creating
reports in Vantage, I've never used subreports. Any quick learning
resources out there that anyone is aware of? Maybe someone has a
report/subreport I can dissect?

Gary

-----Original Message-----
From: ggrenier@... [mailto:ggrenier@...]
Sent: Wednesday, April 27, 2005 4:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Onhand Quantity/Open Order Report



Hi, All!

I have been trying to create a report that will show ALL parts that we have
onhand quantities for, and any open orders in the system , if there are
any.
No matter what I do, I can't seem to get it to show parts for which we have
onhand quantities, but no orders. A left outer joining of PartBin to
OrderDtl gives me a list of all parts we have in stock, whether we have
orders or not, and I can get some order detail where there is some, and the
unknown value for the order-related fields. But I need more detail from
other tables. As soon as I add another join, I lose those parts that have
no orders tied to them.

Any ideas? Any preexisting reports?

Thanks.

Gary Grenier

Gary Grenier
IT Manager
Bell Manufacturing Co.
207-784-2961 x245
mailto:ggrenier@...
2
Hi, All!

I have been trying to create a report that will show ALL parts that we have
onhand quantities for, and any open orders in the system , if there are
any. No matter what I do, I can't seem to get it to show parts for which
we have onhand quantities, but no orders. A left outer joining of PartBin
to OrderDtl gives me a list of all parts we have in stock, whether we have
orders or not, and I can get some order detail where there is some, and the
unknown value for the order-related fields. But I need more detail from
other tables. As soon as I add another join, I lose those parts that have
no orders tied to them.

Any ideas? Any preexisting reports?

Thanks.

Gary Grenier
IT Manager
Bell Manufacturing Co.
207-784-2961 x245
mailto:ggrenier@...
3
Make sure all tables you add are left-outer joins as well, and also watch
your filters to make sure you aren't filtering out the blank ones...
4
Have you tried using a subreport to get the open orders?

Liz

-----Original Message-----
From: ggrenier@... [mailto:ggrenier@...]
Sent: Wednesday, April 27, 2005 01:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Onhand Quantity/Open Order Report


Hi, All!

I have been trying to create a report that will show ALL parts that we have
onhand quantities for, and any open orders in the system , if there are
any. No matter what I do, I can't seem to get it to show parts for which
we have onhand quantities, but no orders. A left outer joining of PartBin
to OrderDtl gives me a list of all parts we have in stock, whether we have
orders or not, and I can get some order detail where there is some, and the
unknown value for the order-related fields. But I need more detail from
other tables. As soon as I add another join, I lose those parts that have
no orders tied to them.

Any ideas? Any preexisting reports?

Thanks.

Gary Grenier
IT Manager
Bell Manufacturing Co.
207-784-2961 x245
mailto:ggrenier@...




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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>



_____

Yahoo! Groups Links


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


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
I think the way to go is open orders and sub report using partplant.whse

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



-----Original Message-----
From: ggrenier@... [mailto:ggrenier@...]
Sent: Wednesday, April 27, 2005 4:45 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Onhand Quantity/Open Order Report



Hi, All!

I have been trying to create a report that will show ALL parts that we have
onhand quantities for, and any open orders in the system , if there are any.
No matter what I do, I can't seem to get it to show parts for which we have
onhand quantities, but no orders. A left outer joining of PartBin to
OrderDtl gives me a list of all parts we have in stock, whether we have
orders or not, and I can get some order detail where there is some, and the
unknown value for the order-related fields. But I need more detail from
other tables. As soon as I add another join, I lose those parts that have
no orders tied to them.

Any ideas? Any preexisting reports?

Thanks.

Gary Grenier
IT Manager
Bell Manufacturing Co.
207-784-2961 x245
mailto:ggrenier@...




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