Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
NSC | How To Check Vendor and Transactions Terms Mismatch?
Scenario: User would like to check transactions that have different Terms from the Vendor record.
To resolve this, we may create a Transaction Saved Search and filter out Purchase Orders and Vendor Bills that have different Terms.
Here are the steps we may take:
- Navigate to Lists > Search > Saved Searches > New
- Select Transaction
- Enter Search Title
- Under Criteria
> Standard tab, add the following filters:
- Type
= Any of Bill, Purchase Order
- Name = Select Vendor
- Formula (Text)
Formula: Enter Case When (NVL({vendor.terms},0) != NVL({terms},0)) Then 'Yes' End
Formula (Text): Select is
Formula (Text): Yes
- Click Save & Run
On the results page, we will be able to pull up the list of mismatch terms for
Tagged:
0