Automate

In the criteria, how can I get BSAK.SHKZG <> BSAK1.SHKZG to execute.

It seems that it's looking for the text "BSAK1.SHKZG" versus the value.

Thank you.



------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000
------------------------------

Hi Kelvin,

Unfortunately, we don't support comparing a field to another field in the selection criteria in Query.  So yes, it is comparing the literal text you typed.

Can you please elaborate on what you want to extract?    We might be able to figure out another way to do it.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 06-18-2021 11:54
From: Kelvin Hayes
Subject: Query with BSAK and BSAK_1

In the criteria, how can I get BSAK.SHKZG <> BSAK1.SHKZG to execute.

It seems that it's looking for the text "BSAK1.SHKZG" versus the value.

Thank you.

------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000
------------------------------

Trying to find where a vendor was invoiced for an amount and that same amount was credited back to us.  Looking for same amounts but opposite signs.

Thank you.

Kelvin

------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000
------------------------------

Original Message:
Sent: 06-21-2021 09:40
From: Sigrid Kok
Subject: Query with BSAK and BSAK_1

Hi Kelvin,

Unfortunately, we don't support comparing a field to another field in the selection criteria in Query.  So yes, it is comparing the literal text you typed.

Can you please elaborate on what you want to extract?    We might be able to figure out another way to do it.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-18-2021 11:54
From: Kelvin Hayes
Subject: Query with BSAK and BSAK_1

In the criteria, how can I get BSAK.SHKZG <> BSAK1.SHKZG to execute.

It seems that it's looking for the text "BSAK1.SHKZG" versus the value.

Thank you.

------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000
------------------------------

I think I may have figured it out.  I can use the Posting Key instead of the debit/credit indicator.


------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000
------------------------------

Original Message:
Sent: 06-24-2021 09:12
From: Kelvin Hayes
Subject: Query with BSAK and BSAK_1

Trying to find where a vendor was invoiced for an amount and that same amount was credited back to us.  Looking for same amounts but opposite signs.

Thank you.

Kelvin

------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000

Original Message:
Sent: 06-21-2021 09:40
From: Sigrid Kok
Subject: Query with BSAK and BSAK_1

Hi Kelvin,

Unfortunately, we don't support comparing a field to another field in the selection criteria in Query.  So yes, it is comparing the literal text you typed.

Can you please elaborate on what you want to extract?    We might be able to figure out another way to do it.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-18-2021 11:54
From: Kelvin Hayes
Subject: Query with BSAK and BSAK_1

In the criteria, how can I get BSAK.SHKZG <> BSAK1.SHKZG to execute.

It seems that it's looking for the text "BSAK1.SHKZG" versus the value.

Thank you.

------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000
------------------------------

Hi Kelvin

I was just going to look at it, but I see you have found another way.  That's great news! 

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 06-24-2021 09:26
From: Kelvin Hayes
Subject: Query with BSAK and BSAK_1

I think I may have figured it out.  I can use the Posting Key instead of the debit/credit indicator.


------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000

Original Message:
Sent: 06-24-2021 09:12
From: Kelvin Hayes
Subject: Query with BSAK and BSAK_1

Trying to find where a vendor was invoiced for an amount and that same amount was credited back to us.  Looking for same amounts but opposite signs.

Thank you.

Kelvin

------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000

Original Message:
Sent: 06-21-2021 09:40
From: Sigrid Kok
Subject: Query with BSAK and BSAK_1

Hi Kelvin,

Unfortunately, we don't support comparing a field to another field in the selection criteria in Query.  So yes, it is comparing the literal text you typed.

Can you please elaborate on what you want to extract?    We might be able to figure out another way to do it.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 06-18-2021 11:54
From: Kelvin Hayes
Subject: Query with BSAK and BSAK_1

In the criteria, how can I get BSAK.SHKZG <> BSAK1.SHKZG to execute.

It seems that it's looking for the text "BSAK1.SHKZG" versus the value.

Thank you.

------------------------------
Kelvin Hayes | Senior Analyst
Nissan North America, Inc. | 615-725-1000
------------------------------