I was trying to do what the OP was trying, extract MVs that didn't meet the
"multiple" criteria, negative though those may be. So, I tested for items
where an
MV account didn't start with "52" and "29". This worked. But I added a
requirement
to output just those MV accounts that didn't start with either "52" or "29". I
couldn't get this to output properly because multiple limiting criteria didn't
work
but single criteria did. So...
list APOPEN WHEN ANY ACCTS UNLIKE "52..." INVDATE COMMENT ACCTS AMTS
APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
58*6-4 06-01-08 LOAN #123456, 06/2008 2910 1,025.50
2365 61.08
2980 273.70
...worked fine while...
list APOPEN WHEN ANY ACCTS UNLIKE "52..." AND WHEN ANY ACCTS UNLIKE "29..."
INVDATE
COMMENT ACCTS AMTS
APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
58*6-4 06-01-08 LOAN #123456, 06/2008 5230 246.04
2910 1,025.50
2365 61.08
2980 273.70
5230 50.00
...did not.
However, when an item had a single valued ACCT, and that value started with
either a
"52" or a "29" it didn't show up so I know this aspect works fine. It's just
then
output of items with both in them that doesn't work. So I'd have expected the
second
list to output:
list APOPEN WHEN ANY ACCTS UNLIKE "52..." AND WHEN ANY ACCTS UNLIKE "29..."
INVDATE
COMMENT ACCTS AMTS
APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
58*6-4 06-01-08 LOAN #123456, 06/2008 2365 61.08
As always, thanks.
Bill
P.S. The dictionaries look like:
2 Dev (0)-> AE DICT APOPEN ACCTS AMTS
< 1 > Top of "ACCTS" in "DICT APOPEN", 7 lines, 84 characters.
*--: P
001: D The G/L acct#s associated with this invoice (controls field# 10)
002: 9
003:
004: ACCT
005: 5L
006: M
007: AS_9
Bottom.
*--: EX
Quit "ACCTS" in file "DICT APOPEN" unchanged.
< 2 > Top of "AMTS" in "DICT APOPEN", 7 lines, 118 characters.
*--: P
001: D The amounts associated with each G/L acct# in ACCTS field. ACCTS and
AMTS are
related.
002: 10
003: MR2,M
004: ACCT/AMTS
005: 13R
006: M
007: AS_9
Bottom.
*--: EX
Quit "AMTS" in file "DICT APOPEN" unchanged.
2 Dev (0)-> AE DICT APOPEN AS_9
Top of "AS_9" in "DICT APOPEN", 2 lines, 61 characters.
*--: P
001: PH
002: ACCTS AMTS MVCHECKNO MVPDDATE MVVNAME MV_CHECKNO MV_PDDATE
Bottom.
3 Intel (0)-> AE APOPEN "58*6-4"
Top of "58*6-4" in "APOPEN", 17 lines, 144 characters.
*--: P
001: 9505
002: 14757
003: 14763
004: 43*100
005: LOAN #123456, 06/2008
006: 165632
007: 0
008: 165632
009: 523022910223652298025230
010: 2460421025502610822737025000
011: 200806
012: 200805
013:
014:
015: AUTO
016:
017: 43
Bottom.
Anyway...it's always something. :-)
Bill
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:owner-u2-
>[EMAIL PROTECTED] On Behalf Of JPB-U2UG
>Sent: Tuesday, June 24, 2008 11:24 AM
>To: [email protected]
>Subject: RE: [U2] Friday query logic
>
>I take it that you checked to make sure that the fields were associated so
>let's take a different look. Are the values separated by value marks or
>sub-value marks? What does the dictionary contain? What does the record
>below look like in the editor?
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
>Sent: Tuesday, June 24, 2008 12:12 PM
>To: [email protected]
>Subject: RE: [U2] Friday query logic
>
>Eric:
>
>That doesn't work either.
>
>list APOPEN WITH ANY ACCTS UNLIKE "52..." OR WITH ANY ACCTS UNLIKE "29..."
>INVDATE
>COMMENT ACCTS AMTS
>APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
>
>58*6-4 06-01-08 LOAN #123456, 06/2008 5230 246.04
> 2910 1,025.50
> 2365 61.08
> 2980 273.70
> 5230 50.00
>
>I wouldn't have expected this to work anyway because every MV meets one or
>the other
>of the criteria. The dicts ACCTS and AMTS are associated with each other.
>I would
>have expected the following to work though:
>
>list APOPEN WITH ACCTS UNLIKE "52..." AND WITH ACCTS UNLIKE "29..." INVDATE
>COMMENT
>ACCTS AMTS
>APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
>
>58*6-4 06-01-08 LOAN #123456, 06/2008 5230 246.04
> 2910 1,025.50
> 2365 61.08
> 2980 273.70
> 5230 50.00
>
>Bill
>-------
>u2-users mailing list
>[email protected]
>To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
