-
Saved Searches, Restrict State filters to only USA
When filtering customers in a Saved Customer Search we want to filter by the default address state, but when selecting the state from the drop down it displays Australia, Canada, China, Japan, Mexico, United Kingdom, all before the United States. We do not accept customers from outside of USA, Mexico, Canada. Ive tried…
-
Is it possible to show Average Days To Pay and Average Days Overdue on a Customer Saved Search?
SuiteAnswers and old (2007 / 2008) Oracle Community posts address how to show Average Days To Pay and Average Days Overdue by customer on a Transaction saved search; but no guidance for same on a Customer Saved Search. Does anyone have info on how to do this? Thanks
-
Search | Forcing Multiple Rows
Greetings! I need to export a list of customer telephone numbers that are all part of the Main Line of the Customer Record. Currently, each number is in a separate column. However, the requirement is that each phone choice (home, work, cell) needs to be on a separate row. Is there a way to force each column to be a row?…
-
How to get customer balance with multiple subsidiaries?
We've recently enabled multi-subsidiary customers after acquiring another company with an overlapping customer list. Now I'm trying to adjust my statement mailing workflow to only send statements out when the company has a balance with a particular subsidiary. I have a saved search with the criteria Subsidiary: Name =…
-
Saved Search: Cant find field Give Access field in Customer table
I am trying to create a customer saved search and I want to add Give Access to the saved search results. I cant seem to find it. Not sure if its in one of the joins or has a different name. this is in customer record in the access tab. the Give Access Field ID: giveaccess thanks in advance!
-
How to retrieve data from Customer list with netsuite script ?
I have some script to get vendor data with N/query module then export data to internal API to process and it worked fine but broke today. Someone created a customer List that take vendor site code from previous table and created a customer List as enumeration for normalizing tables with additional join. I tried to find…
-
Saved Search > Customers with All Billed Sales Orders
I have a Saved Search that shows me if there are any customers that have a custom field ('no creditcard on file') that's just a checkbox, but currently have credit cards in their customer profile. I would like to show results ONLY if all their orders have been billed. It's a Customer Saved Search and I've tried to add the…
-
Getting total Customers in search formula
Hi, I am trying to create a search which is grouped by subsidiary showing me total of only B2B customers(type= customers) with website login access per subsidiary. I am wanting to further show percentage of customers that have login access to website vs the total customers for that subsidiary. I tried below two formula but…
-
Pricing analysis - List of ALL the Items Purchased when Customer active on specific items
We are reviewing our sales history and pricing to determine if we/our Customers could sustain a price increase. My goal is gathering data in consideration of a price increase for one of our Items, "Web Service License" but I want to understand the entire suite of products our Customers currently have, when the Customer has…
-
SuiteTalk SOAP Services
So I'm trying to use PHP to search customer records with a specific value for a custom field. All the examples that I have found do not work. For example this one errors on <serachRecord line with messag…