How can I get the Statement date to show in the Multi-Currency Advanced PDF/HTML template?

AI generated answer (using internal Slack threads):

To get the Statement date to show in the Multi-Currency Advanced PDF/HTML template, you need to use the field id of the date record in the NetSuite database, which is "trandate". You can retrieve the date using a formula SQL and render it in the HTML form of the invoice. Here is an example of how you can retrieve the content of your custom field with the formula:

${record.trandate}

. If you want to change the date format, you can use the following format:

${record.trandate?string["yyyy-mm-dd"]}

. Please note that the Transaction Date may be different from the Created Date. If you want to use the Created Date, make sure to use the correct field id. Also, remember that the drop-down in the 'Generate Statement' form selection doesn't show templates, it shows forms. You need to customize the standard form and point it to your advanced template. Then your newly customized form should show up in your drop-down list. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******