José Vale
José Vale

Reputation: 3

How to compare two columns in netsuite in a saved Search

I have two columns Vendor Account (in the bill) and the default payables account in the vendor record. We have some wrong postings and I want to create a saved search to control this. I've isolated the account number and default account number, however i can't seem to create a formula column that compares them (with a case formula i.e)

Is it because one of the account columns might be in text? What are the problems that can be happening here?

Columns to be compared

Upvotes: 0

Views: 3128

Answers (1)

Martha
Martha

Reputation: 764

Assuming that "Vendor Account" and "Vendor Payables Account" are both number/integer fields the following case statement should work. Be sure to replace the field ids to match your account.

CASE WHEN {VendorAccount}={VendorPayablesAccount} THEN 'T' ELSE 'F' END

If the fields are not number fields use the following:

CASE WHEN TO_NUMBER({VendorAccount}) = TO_NUMBER({VendorPayablesAccount}) THEN 'T' ELSE 'F' END

Upvotes: 2

Related Questions