Manuafactured Stock Report - RB

it might be a linking issue. If you are doing equal join on partbin or part
warehouse you will have to change it to a left join or outer. In layman's
terms show me all parts regardless if I have records in the part.warehouse
table or part.bim table.



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: DODD, Jim [mailto:jimd@...]
Sent: Wednesday, August 25, 2004 3:31 PM
To: Vantage (E-mail)
Subject: [Vantage] Manuafactured Stock Report - RB


The recent thread concerning Manufactured Stock seemed appropriate as I have
been working on a simple RB report to address production suggestions for
stocked manufactured inventory.

I am stumped with one aspect of the report. Parts that have zero (0) on
hand do not print on the report. The report will print any part number with
a minimum quantity requirement. It will then suggest to produce the
quantity in the minimum lot size field if the on hand is equal to or below
the minimum field. Well, inventory with zero on hand will not print. Does
anyone know what to do to get zero on hand inventory to print? I hope I
explained this correctly.

Thanks,
Jim Dodd
La Calhene, Inc.


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

<http://us.ard.yahoo.com/SIG=12931k77m/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1093548587/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=183901056>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
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/> .



<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).



[Non-text portions of this message have been removed]
The recent thread concerning Manufactured Stock seemed appropriate as I have
been working on a simple RB report to address production suggestions for
stocked manufactured inventory.

I am stumped with one aspect of the report. Parts that have zero (0) on
hand do not print on the report. The report will print any part number with
a minimum quantity requirement. It will then suggest to produce the
quantity in the minimum lot size field if the on hand is equal to or below
the minimum field. Well, inventory with zero on hand will not print. Does
anyone know what to do to get zero on hand inventory to print? I hope I
explained this correctly.

Thanks,
Jim Dodd
La Calhene, Inc.