Part Bin Report

Yahoo Archive
1
Cliff
The join to the PartBin Table has to be a left outer join so that
every entry in the part table is included. Then a calculation is
needed like BinCheck ["iif(PartBin = "", 1,0)]. Then filter for
BinCheck = 1. If you filter on anything in the PartBin table the
outer join closes to an inner join because only records that exist in
both tables can meet any filter requirements.

HTH
Russ Dover

> Hey All
>
> I'm trying to make a report in Report Builder to show me parts
> that
> don't have a warehouse or bin .
>
> Master table = Part
> Joins : Part to Partdtl
> Part to PartBin
>
> It will give me a great report for every part in the system. I'm
> trying to filter unsuccessfully for parts where it is blank.
> Can somebody tell me the syntax for my filter ??
>
> Cliff Drumeller
> Information Technology Manager
> Mass Precision Sheetmetal
> 408 954-0200 ex 217
> Vantage 4.0
>

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
2
Hey All

I'm trying to make a report in Report Builder to show me parts that
don't have a warehouse or bin .

Master table = Part
Joins : Part to Partdtl
Part to PartBin

It will give me a great report for every part in the system. I'm
trying to filter unsuccessfully for parts where it is blank.
Can somebody tell me the syntax for my filter ??

Cliff Drumeller
Information Technology Manager
Mass Precision Sheetmetal
408 954-0200 ex 217
Vantage 4.0
3
PartPlant has PriWhse (Primary Warehouse)
PlantWhse has PrimBin (Primary Bin) and OnHandQty

Your report will look for inventory or no inventory on a part if that's what
you desire.

You can see if no inventory is out there try bin = ?

The PlantWhse.OnHandQty I think was added after version 4.0

Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.10.130, Progress 9.1C



-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Monday, July 14, 2003 10:58 AM
To: VantageGroup (E-mail)
Subject: [Vantage] Part Bin Report


Hey All

I'm trying to make a report in Report Builder to show me parts that
don't have a warehouse or bin .

Master table = Part
Joins : Part to Partdtl
Part to PartBin

It will give me a great report for every part in the system. I'm
trying to filter unsuccessfully for parts where it is blank.
Can somebody tell me the syntax for my filter ??

Cliff Drumeller
Information Technology Manager
Mass Precision Sheetmetal
408 954-0200 ex 217
Vantage 4.0

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Natural Vitamins for Good Prostate & Male Health. $28.97
http://www.challengerone.com/t/l.asp?cid=2865&lp=prosta2.html
http://us.click.yahoo.com/qJIe0D/89VGAA/ySSFAA/PhFolB/TM
---------------------------------------------------------------------~->

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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/