Is there a saved search formula to show the abbreviation of province and country?

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that the abbreviation of province and country cannot be directly obtained through a saved search formula in NetSuite. The internal IDs of countries' codes in NetSuite are the 2 character country codes, but they may not be available in saved searches. However, you can use SuiteScript to generate a list of all country and state names/abbreviations. Here is a sample code provided in the conversation:

javascript
function getCountries() {
    var suiteQL = "SELECT Country.ID,Country.Name FROM Country ORDER BY Country.Name";
    var resultSet = query.runSuiteQL(suiteQL);
    var results = resultSet.asMappedResults();
    log.debug('SUITEQL','Country records found = ' + results.length);
    return results;
}

This function uses SuiteQL (a part of the N/query module) to access the Country table in the database and retrieve the country IDs and names. Please note that this approach requires knowledge of SuiteScript and SuiteQL. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

Do we know how to use Non Directed Spot Counts with the Smart Count bundle? Netsuite advises that from the Main Menu you can complete a non-directed spot count to count rogue items. However, this is not the behavior that actually happens.