Andreea Barcan
02/13/2025, 3:42 PMCeligo AI
02/13/2025, 3:42 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. ****** To print on an advanced PDF statement dynamic bank details based on currency and subsidiary, you can use a combination of custom fields, saved searches, and advanced PDF/HTML templates. Here's a step-by-step guide: 1. Create a custom field for bank details: You can create a custom field on the subsidiary record to store the bank details. This field will be populated based on the subsidiary and currency. 2. Create a saved search: This search should be set up to pull the bank details from the custom field based on the subsidiary and currency of the transaction. 3. Modify the advanced PDF/HTML template: In the template, you can reference the bank details field from the saved search. You can use the syntax
${subsidiary.custrecord_bank_details}
to pull the bank details into the template.
Here's a sample code snippet for the advanced PDF/HTML template:
xml
<#if record.subsidiary?has_content>
<#assign bankDetails = record.subsidiary.custrecord_bank_details>
<#if bankDetails?has_content>
<p>Bank Details: ${bankDetails}</p>
</#if>
</#if>
Please note that the field ID custrecord_bank_details
is just an example, you should replace it with the actual ID of your custom field.
Also, it's important to note that the bank details should be tightly controlled and not editable by users to avoid any potential risks.
Unfortunately, the render.statement
method in SuiteScript 2.0 API does not provide an option to select a subsidiary. It seems to always use the primary subsidiary. You might need to create a custom solution to handle this.Celigo AI
02/13/2025, 3:42 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.851362228
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837752283
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835482895
Celigo AI
02/13/2025, 3:42 PM