BAQ Issue Blank Title 100061

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]
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]
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@yahoogroups.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]
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@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.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@yahoogroups.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]
field = ''
should match empty text fields. If you're not getting the results you
expect, you may have an error elsewhere in your code. Can you post your
whole query?

On Tue, Apr 26, 2011 at 8:47 AM, Sreejith Jaganathan <
sreesvantagedoubts@...> wrote:

>
>
> 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@...>
> To: "vantage@yahoogroups.com" <vantage@yahoogroups.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@yahoogroups.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]
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]
Sreejith, there is another trick available if the setting below doesn’t work.

Link your Vendor table to the APAcct one through “Company” and “APAcctID”, checking the “outerjoin” checkbox to get all vendors regardless of a record existing in the APAcct table; then in the Select criteria for APAcct, create one where APAcctID <> Vendor.APAcctID (deselecting “constant” checkbox).

This will bring both, Vendors without an APAcctID and Vendors with APAcctID but no link to APAcct table.

Hope this helps, too.

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 Roel Martinez
Sent: Tuesday, April 26, 2011 9:03 AM
To: vantage@yahoogroups.com
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%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Sreejith Jaganathan
Sent: Tuesday, April 26, 2011 7:47 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.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><mailto:rmartinez%40sabre-sts.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.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%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.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]