I need to be able to pull the shipzip into a custom field because we having issues pulling shipzip into tableau. I believe this is because in some cases we need to use a one time custom address. We are finding that we are unable to pull this zip code into our tableau reports and it comes in blank from the data table. We believe this is because it is not stored, so we thought we should be able to create a custom field that would source from shipzip and store the value to be pulled into the tableau reports. However, this is not working. Not only am I not able to get the custom shipzip into the new field, but I am unable to source the new field at all, even when the address used is the default ship address on the customer record. Is this because it will only populate on new records, or am I sorely misunderstanding something?
I've found an alternate thread, apologies for the duplication,https://community.oracle.com/netsuite/english/discussion/4482512/how-to-pull-the-zip-code-from-a-shipping-address, but there was not enough detail in order to ensure I was doing this properly. I've created a custom field, and as part of that field, I have the store value checked and it's a free form text field. Under Validation and Defaulting, I've set the default value to formula and {shipzip}. None of my sales orders are pulling in the shipzip to this new field, custom address or otherwise.