Customer saved search for a match but ignore upper/lower case

How can I compare 2 fields in a Customer saved search for a match but ignore upper/lower case? I tried Case When {email} like {custentity_invoice_email_address} then ‘Match’ Else ‘No Match’ End I would like this result to be a Match. My Criteria only returns rows that are No Match. I was hoping to exclude this… Continue reading Customer saved search for a match but ignore upper/lower case

Send Transactions Email to Customers Only With Invoices

1. Update Customer Record – Navigate to Lists > Relationships > Customers – Edit any customer– In the Preferences tab, uncheck Email next to Send Transactions Via– Click Save 2. Update Custom Form– Navigate to Customization > Forms > Transaction Forms– Edit your preferred Invoice Form– Go to Screen Fields tab> Communication:Messages tab– In the To be E-mailed, mark the Default checkbox– Click Save

Maximizing Customer Project Management with NetSuite

Client Request: “We need a streamlined approach to track our customer projects within NetSuite, ensuring we can efficiently monitor costs and revenues for each project. We require a solution that allows us to customize project records, track expenses, and generate detailed reports to better understand project performance. Additionally, we want to ensure that our project… Continue reading Maximizing Customer Project Management with NetSuite

Generate Price List Only for Items Under Item Pricing Tab of Customer Record

Generate Price List only for Items under Item Pricing Tab of Customer Record Solution Pull up the Customer Record via Lists > Relationships > Customers Click Edit Go to Financial subtab Price Level: Putblank / null / empty Click Save Go to Actions > Generate Price Lists  Assigned Price Levels Only: Enter Checkmark Click Submit

Set field as Mandatory in Customer form if Customer Type is Individual via Workflow

To create the workflow: 1. Navigate to  Customization > Scripting > Workflows > New.2. In the Basic Information section, set the following:    • Name: For example, “Mandatory only if Individual”   • Record Type: Customer   • Sub Types: Lead, Prospect, Customer   • Execute as Admin is marked   • Release Status: Released 3. In the Initiation section, set the following:    • Event Based: On Create   • Trigger Type: All 4. Click Save.5. Click State 1.6. Update the Name to a… Continue reading Set field as Mandatory in Customer form if Customer Type is Individual via Workflow