Jack Daryl Espiel-Oracle Gold Crown

Upon testing on this, I didn't find any unique characteristics of Kit Member Items that can be checked for a condition to the indent those items so it is currently not available for Advanced PDF/HTML Templates. The following Enhancement Requests have been filed for a possibility of future implementation: Enhancement…

Greetings @jmack_admin, You can set up a Workflow that will populate the Terms on the Invoice upon record save with the latest value from the Customer Record. This will override the field value from the Quote. See the screenshots below on how to set up the Workflow: Hope this helps. If you find this reply to your question…

Greetings @timblun, Checking on this, currently, the only workaround available for the enhancement you stated is via SuiteScript. The reason for this is because the Addresses on the Customer Record are Subrecords. As of now, Basic customization and Workflows do not have access to subrecords. For more information, refer to…

Thanks again @CDuf for providing more information. Based on the behavior you explained, the problem may lie on the backend cache/index of your account since the record is not searchable on the Release Preview environment. The backend cache should be refreshed once your account is updated to the upcoming version of…

Thanks for the additional information @CDuf. It seems that the permission error only occurs on the Home page and the URL does not provide any information about the record found in Global Search. I noticed that you are in a Sandbox Account and I'm interested to know if this is also happening in Production. It could only be…

Greetings @CDuf, Can you share the URL of the page with the permission error? -Jack

Glad that my solution helped you @Kyle_Lautzenhiser-Oracle! You can tweak the if else statement to check if item.rate is a percentage discount by adding the portion in bold below: <#if item.itemtype=='Discount' && item.rate?contains('%')> With the condition above, Dollar discounts will be printed as a regular currency…

Hi @User_Q9SHI, I have branched your follow up question into this new thread. There could be a typographical error on the Field ID you are using (line.otherfnum). Can you try ${record.otherrefnum} if it prints out the PO#? If you find this reply to your question useful, others might be as well. By clicking “Yes” on “Did…

Greetings @User_Q9SHI, To use Advanced PDF/HTML Templates for Customer Statements, follow the steps below: 1. Customize the Standard Statement Form in Customization > Forms > Transaction Forms > Click Customize beside Standard Statement form. See screenshot below: 2. On the Printing Type field, select Advanced and choose…

Testing on this, I came up with the following code to round the percentage of the discount to the nearest hundredths: <#if item.itemtype=='Discount'> <td align="right" colspan="2">${nsformat_percent((item.rate*100)?string('#.##'))}</td> <#else> <td align="right" colspan="2">${item.rate}</td> </#if> Note: With the above…

Greetings @Kyle_Lautzenhiser-Oracle, Can you share some screenshots of the print-out of the rate value and the way it should look? Please redact/mask any personally identifiable information. -Jack

Greetings @User_Q9SHI, Thank you for posting a new inquiry in NetSuite Support Community. Tagging our gurus @Shamaine Chan-Oracle, @Ivy Lopez-Oracle, and @Joy Noreen Magoling-Oracle who might be able to help you out on this one. To others who have any ideas, feel free to share them here. -Jack

Greetings @Hormese Paul, Upon checking, the generated Data Model for the Customer Deposit Advanced PDF Template does not support the Items Sublist from the source Sales Order unlike the templates for Packing Slip, etc. For a list of supported fields and sublists on the Customer Deposit Template's data model, refer to…

You're very welcome @User_Q9SHI! Glad I could help ? -Jack

Greetings @NS ERP CONSULT, I'm currently performing testing for this. I'll get back to you with an update. -Jack

Test comment ?

Hi @User_Z1408, Another follow-up question. Are the different templates you described for each geographic region located in Customization > Forms > Transaction Form PDF Layouts? -Jack

Greetings @Jeroen Sprangers ZS, Upon checking, NetSuite currently does not have an Online Opportunity Form yet. The following Enhancement Request has been filed for a possible future implementation: Enhancement 83075: Online form> ability to have an online opportunity forms You can vote for the Enhancement Request by…

Greetings @dle_35705, You can use the following formula to default the field to the date in the next 10 days: Expected Result: Hope this helps. If you find this reply to your question useful, others might be as well. By clicking “Yes” on “Did this answer your question”, you’ll be able to help the community find the…

Greetings @User_Z1408, Is the Print Using HTML preference enabled and the Transaction Email Attachment Format set to HTML in Home > Set Preferences > Transactions subtab > Printing section as shown in the screenshot below? -Jack

You can use the Workflow's Sublist Action Group feature and Set Field Value action to populate the Amount Custom Transaction Line Field. See the screenshots below for an example: Result: The value of the Amount field will be copied to the Custom Transaction Line Field upon saving the record. See the sample screenshot…

You're welcome @User_Q9SHI. Glad I could help ? -Jack

Greetings @User_Q9SHI, Thank you for posting a new inquiry in NetSuite Support Community. We will look into this and get back to you with an update. -Jack

You're welcome @kfluk. Glad I could help ? -Jack

Greetings @BWM- Shem, Thank you for posting a new inquiry in NetSuite Support Community. Tagging our gurus @Emilia Ironov-Oracle, @Micah Timbol-Oracle, and @Camille Cagalingan-Oracle who might be able to help you out on this one. To others who have any ideas, feel free to share them here. -Jack

Greetings @kfluk, You can use either <div> or <p> tag to set the text alignment in Saved Search Formulas like the example below: '<p align="right"><font color="#006400">'||{locationquantityavailable}||'</font></p>' As for your other concern, it is expected behavior for text formulas with HTML formatting to be exported with…

Thank you for the additional information @User_B8HM0. Upon checking and testing, the Tax Registration sublist on entity records is a Standard sublist and a script from the SuiteTax bundle is adding more fields to it. Since the scripts from the bundle are locked and cannot be edited, we recommend that you submit a case…

Thanks for the screenshots @Benoit Cavailles. We now understand your requirement better. Unfortunately, with the way Custom Segments are designed, dynamic values are not yet implemented. Currently, it only supports pre-defined values. Alternatively, to address your requirement with custom segments, you can export the names…

Hi @Benoit Cavailles, Apologies but we are having a bit of difficulty understanding your requirement. Can you provide some sample screenshots for us to visualize your desired result? (Please redact/mask any personally identifiable information). Thank you. -Jack

Upon checking, the Amount sublist field from source Sales Order/Transfer Order cannot be directly referenced on the Advanced Packing Slip Template as of now. The following Enhancement Request has been filed for a possibility of future support: Enhancement 483566: Advanced PDF/HTML Template > Standard Packing Slip Template…