nkhatri
07/07/2025, 3:09 PMCeligo AI
07/07/2025, 3:09 PMAI generated answer (using internal Slack threads):****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The issue you're experiencing with the date format in Excel after exporting a saved search from NetSuite is due to Excel's automatic formatting, not NetSuite's export. When you open the exported file in Excel, Excel automatically reformats the date according to its default settings. To retain the original date format, you can manually change the format in Excel. Here's how you can do it: 1. Select the column with the dates. 2. Right-click and select 'Format cells'. 3. Select 'Custom' and set it to the desired format (e.g., "MMM YYYY"). If you're unfamiliar with custom formats in Excel, you can find numerous resources online to guide you. As for the issue with the date format in the Invoice PDF generated by a scheduled workflow, it seems that the workflow might be using the date format preferences of the workflow owner or the global preferences, not the subsidiary's preferences. One possible workaround could be to change the workflow owner's date preferences to match the desired format. However, this might not always work, as indicated in the conversations. Lastly, regarding the export of a saved search to Excel, it seems that the title and date range are not included in the export. Changing the layout to "report" might not solve this issue. Unfortunately, exporting the filters along with the saved search does not seem to be possible in NetSuite.
Celigo AI
07/07/2025, 3:10 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.845459938
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832297504
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.824786961
Celigo AI
07/07/2025, 3:10 PM