× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




Dear assistents,

see downstanding Query AS400 problem:


my report is almost ready, but only the 'strange' totals I can't get out of
the report.
The total quantity from 'AVAILQTY01' is placed in 'AVAILQTY03' when there
is no child item BCHLD.

The only thing I want is an '0' or ' ' in column AVAILQTY03 when the child
item is empty.

When I give fe in the last query 'AVAILQTY03 LE 500000' than it deletes in
the report all earlier information, here the 3rd and 4th line, but I want
to keep that information.


Explanation fields:
AVAILQTY1: Qty on hand from the can FLB5
AVAILQTY2: Qty in extern warehouse, consignment stock, from the can FLB5
AVAILQTY3: Qty on hand from the plate (childitem), information comes from
the outputfile were AVAILQTY1 is found as well.

Explanation used queries:
DA10 shows a list with salesquantities (cust nr/cust name/x-ref/imp
item/desc1/desc2)
DA11 same as DA10, but gives the totals per customer number and item
DA12 shows the info of DA10 with the totals of DA11
DA2 gives quantities on hand, on cust order and the diff
DA3 gives quantities in consigment stock
DA4 gives childitems from the parents (MBM)
DA5 shows a total overview, where I get the strange totals from
AVAILQTY01 when there is no childitem.

Do you have an advise or a tip?

Thank you very much!

The information is little changed for the privacy of our company:

I get a big total on AVAILQTY03 where I want to show the quantity on hand
from the child item of the can. Where there is no plate item as child I
want a qty = 0 or qty = ' '.

Thank you very much for your help and assitence!

Rgds,

David AntonissePlease consider the environment before printing this e-mail. --------------------------------------------------------------------------------------------------------------------- Discover Impress on http://www.impressgroup.com The information contained in this e-mail and any attachments is strictly confidential and may be legally privileged.It is intended solely for the use of the individual or entity to whom it is addressed. If you are not the named addressee, you are hereby notified that it is prohibited and may be unlawful to disclose, distribute, store, copy the information in any medium or usage for another purpose. ---------------------------------------------------------------------------------------------------------------------

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.