RB ? number 2

Yahoo Archive
1
I was faced with the same problem trying to run a critical inventory listing.
I resolved it by importing all part numbers from the part master file. Then
summarizingquantities from all part buns, including null bins.
2
Try an outer join to the partbin.

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 3.00.614, Progress 8.3A

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Friday, August 11, 2000 06:18 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB ? number 2


Good Morning,

Yesterday I asked the question how to grab certain part numbers (my 60" wide
rolls) on a report builder report. I got some good suggestions and got past
that hurdle. Now I am faced with a new challenge; I am using the Part table
and the PartBin table to show me how much of each of these products I have
in stock. I am grouping and sorting by Part Number and everything is cool
except I cannot get the report to show parts with zero on hand. I think
because I am looking at the partbin table for on hand quantity and the data
dictionary states that when a partbin record hits zero it gets deleted. How
can I get zero on hand items on the report?

Thanks Again
Todd Hofert
Spartan Graphics, Inc.
(616)887-8243




We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
3
Patrick gave the simple solution listed below, Thanks Patrick

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Friday, August 11, 2000 8:31 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] RB ? number 2


Try an outer join to the partbin.

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 3.00.614, Progress 8.3A

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Friday, August 11, 2000 06:18 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB ? number 2


Good Morning,

Yesterday I asked the question how to grab certain part numbers (my 60" wide
rolls) on a report builder report. I got some good suggestions and got past
that hurdle. Now I am faced with a new challenge; I am using the Part table
and the PartBin table to show me how much of each of these products I have
in stock. I am grouping and sorting by Part Number and everything is cool
except I cannot get the report to show parts with zero on hand. I think
because I am looking at the partbin table for on hand quantity and the data
dictionary states that when a partbin record hits zero it gets deleted. How
can I get zero on hand items on the report?

Thanks Again
Todd Hofert
Spartan Graphics, Inc.
(616)887-8243
password, the link above will work the next time you try it.)