Order BAQ help needed

You probably need to rethink the BAQ and go with order lines and not
orders. This will allow you to select those order lines that have been
untouched you can then link the order header and the customer for the
other criteria.





[Non-text portions of this message have been removed]
We are trying to build a BAQ that lists only those open orders that have
had nothing shipped or invoiced yet, and the customer is not on credit
hold. Basically, we want a list of untouched orders. We just can't
seem to get it right. We are pulling data from the Orderhed, and
Customer. From OrderHed, we based our criteria on the fields
OpenOrder, TotalInvoiced, and TotalShipped. The criteria we are
applying to Customer is using the CreditHold field. Does anyone have
any suggestions for us? Thanks!



Here is our Query Phrase:

for each OrderHed where ( OrderHed.OpenOrder = true AND
OrderHed.TotalInvoiced = 0 AND OrderHed.TotalShipped = 0) no-lock ,
each Customer where ( Customer.CreditHold = false) and
(OrderHed.Company = Customer.Company and OrderHed.CustNum =
Customer.CustNum) no-lock .



Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231 or 870-480-4530
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





[Non-text portions of this message have been removed]