Thanks Mr. Roel it worked out for me. Now I got the results
________________________________
From: Roel Martinez <rmartinez@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Tue, April 26, 2011 6:02:34 PM
Subject: RE: [Vantage] BAQ Issue
I just tried and, you have to leave the (Vendor.APAcctID = ) blank. In other
words, instead of typing “†or ‘’ in the CONSTANT field, just leave it blank.
I hope it is not only my version (8.03.407)….
Regards.
Roel Martinez
ERP Analyst
SABRE TUBULAR STRUCTURES â„¢
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sreejith Jaganathan
Sent: Tuesday, April 26, 2011 7:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Issue
Good Afternoon
Thanks Mr. Martinez for responding I tried the below said but it didn't worked
out. If anybody could help me out with some other way.
Regards
Sreejith J
________________________________
From: Roel Martinez <rmartinez@...<mailto:rmartinez%40sabre-sts.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>"
<vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Tue, April 26, 2011 3:51:51 PM
Subject: RE: [Vantage] BAQ Issue
Good morning.
You can try matching the APAcctID to a "known" null field within the table, for
instance:
for each Vendor where ( Vendor.APAcctID = Vendor.Character05) no-lock
It has worked in a couple of BAQs but not in others for me in the past.....
don't know exactly why but hope it works for you.
Regards.
Roel Martinez
ERP Analyst
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Sreejith Jaganathan
Sent: Tuesday, April 26, 2011 5:04 AM
To: Vantage Group
Subject: [Vantage] BAQ Issue
Hi Friends
I am trying to find out the list of Vendors to which an AP Account is not
connected.
With the below 2 queries I didn't get any results
for each Vendor where ( Vendor.APAcctID = 'NULL') no-lock .
for each Vendor where ( Vendor.APAcctID = '""') no-lock .
I know that I am missing a simple point some where. Could any body please let me
know how to get the results for the query.
Regards
Sreejith J
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
________________________________
From: Roel Martinez <rmartinez@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Tue, April 26, 2011 6:02:34 PM
Subject: RE: [Vantage] BAQ Issue
I just tried and, you have to leave the (Vendor.APAcctID = ) blank. In other
words, instead of typing “†or ‘’ in the CONSTANT field, just leave it blank.
I hope it is not only my version (8.03.407)….
Regards.
Roel Martinez
ERP Analyst
SABRE TUBULAR STRUCTURES â„¢
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sreejith Jaganathan
Sent: Tuesday, April 26, 2011 7:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Issue
Good Afternoon
Thanks Mr. Martinez for responding I tried the below said but it didn't worked
out. If anybody could help me out with some other way.
Regards
Sreejith J
________________________________
From: Roel Martinez <rmartinez@...<mailto:rmartinez%40sabre-sts.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>"
<vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Tue, April 26, 2011 3:51:51 PM
Subject: RE: [Vantage] BAQ Issue
Good morning.
You can try matching the APAcctID to a "known" null field within the table, for
instance:
for each Vendor where ( Vendor.APAcctID = Vendor.Character05) no-lock
It has worked in a couple of BAQs but not in others for me in the past.....
don't know exactly why but hope it works for you.
Regards.
Roel Martinez
ERP Analyst
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Sreejith Jaganathan
Sent: Tuesday, April 26, 2011 5:04 AM
To: Vantage Group
Subject: [Vantage] BAQ Issue
Hi Friends
I am trying to find out the list of Vendors to which an AP Account is not
connected.
With the below 2 queries I didn't get any results
for each Vendor where ( Vendor.APAcctID = 'NULL') no-lock .
for each Vendor where ( Vendor.APAcctID = '""') no-lock .
I know that I am missing a simple point some where. Could any body please let me
know how to get the results for the query.
Regards
Sreejith J
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]