Does anyone know how to control the displayvalues being sent from NAV to Excel?
I have two seemingly identical machines installed running on the same NAV2017 server.
When using the default "Export to Excel" functionality, for instance in the customer overview, one machine display TRUE/FALSE and the other YES/NO in the various columns.
I am assuming that it must be controlled somewhere in the regional settings or excel settings, but I am at a loss trying to find anything that is different between the two installations.
I know that I can use FORMAT with custom exports, but since this is the default export, I don't now where to control it.
Don't just take my word for it, test it yourself