I have so many situations where I need to access settings provided for in general NetSuite preference records (e.g. webstore, sales lists, accounting lists, etc). Additionally, have been asking for access to some general default lists such as 'Countries' and 'States' (for use when building dynamic UI fields for example).
Here are some use cases:
1. Customer Center form: need to add a drop down for countries and states. the Countries field also needs to be filtered to only show countries allowed to buy in the webstore.
Options:
a) Create a custom list field and identify it as 'Countries' and set a filter option to match only 'webstore countries' (what I have set in the Website Setup > Shopping > Countries Web Store Ships To multi-select list). this use case would further allow me to create a custom list field identified as 'States' and link it the custom list field 'Countries' so that when I change Country, it loads the appropriate States list (or empties for non-state Countries).
b) Create a UI object list field and populate options using an exposed list I retrieve through a new 'nlapiLoadList' or nlapiLoadRecord('[netsuite record]'), or nlapiLookupField('[netsuite record]',...) to get list or array of Countries, or Countries Web Store Ships To. The same for States. In this scenario, I would need some UI management way to link States to Countries so the load the right set of States options based on the selected Countries option.
2. Building Custom Preferences. I have a number of situations where I want to add functionality similar to the way NetSuite provides already. NetSuite has made steps to provide the ability to add custom fields that identify some templates and files which is great. Need to expand this. For example, I have a preference that differentiates the default Forecast for Opportunities versus Quotes. NetSuite currently only provides one default Forecast setting in Sales Preferences. I want to create a custom preference field where I can show the same drop down list of Forecast Types (what were set in the Sales Preference fields for each forecast type), so that I can have admins set different preferences for different situations (e.g. quote versus opportunity, or quote versus opportunity for certain partner types, etc). I could then provide a drop down list in a special preferences record, knowing that if someone goes into the Sales Preferences and relabels 'Low Forecast Name', 'Medium Forecast Name', etc, that these reflect in the custom drop downs as well. Again, some of this could be script code magic as an interim, but I need at a minimum, access to the fields 'Low Forecast Name', 'Medium Forecast Name', etc so I can set the visual record appropriately and in turn use these values (using server-side or client-side scripting) to set defaults on various forms or conditions.
I know we have talked on this forum about exposing NetSuite preference records and lists. Can anyone at NS comment on whether this has advanced and if so, what we will be seeing in the near-future releases? I would expect that doing this may have security implications, so having them 'read only' is OK as a short term delivery.
Thanks.
-Steve