Greetings @Benjamin Paul - USA, Thank you for sharing your concern here in NetSuite Support Community. Tagging our guru @Michelle Jabanes-Oracle who might be able to help you out on this one. To other members who have any ideas, feel free to share them here. -Jack

Greetings @User_K9ZU8, To clarify your requirement, do you need to add the Bill Credits to the Payment Notification Email sent with the contents based on the selected template on the field indicated in the screenshot below? Or, should it be added in the generated Payment File itself that is referenced in the field…

Greetings @User_V5KBL, Upon checking, the functionality to assign specific Advanced PDF Templates to Invoice Group Forms is currently not available yet in NetSuite. The following related Enhancement Request has been filed for the possibility of future implementation: Enhancement 645454: Customization > Forms > Entry Forms…

Hi @User_ML5H4, Did the given solution above work on your end? If so, we would greatly appreciate you giving us an update. If you need further assistance, please let us know. -Jack

Hi @CashShurley, Apologies for not so soon reply since I just got back from the holidays. Anyway, upon checking and testing, it seems that transHash contains the data from each Bill Record associated with the Payment Record. Since the Paid Amount is on the Apply sublist under the Payment Record, transHash cannot be used to…

Greetings @bd85528, Thank you for posting a new inquiry here in NetSuite Support Community. Tagging our gurus @Katerina Winklerova-Oracle and @Micah Timbol-Oracle who might be able to help you out on this one. To other members who have any ideas, feel free to share them here. -Jack

Hi @Richard Appleford OB, Did our suggestions above help address your requirement? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the response post which will also help us and the other community members track replies that are meaningful, and…

Greetings @CashShurley, By "paid amount", are you referring to the amount on the Bill Payment indicated in the screenshot below? -Jack

Greetings @User_ML5H4, We have come up with a trick in the Advanced Template Code to sort the Bins in alphabetical order for each line. See the screenshot below: Added/modified Template Code: ... <#assign sortedinventorydetail= "" /> <#if item.inventorydetail?has_content> <#assign inventorydetailtblwithsortcol= [] />…

Hi @User_ZM320, Did the suggestion above help resolve your concern? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the response post which will also help us and the other community members track replies that are meaningful, and you will also…

Hi @Betsy Vance, Did the suggestion above help resolve your concern? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the response post which will also help us and the other community members track replies that are meaningful, and you will also…

Hi @Entartes, Have we provided what you are looking for? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the response post which will also help us and the other community members track replies that are meaningful and you will also get closer…

Hi @Arun Dasari, Do you still need assistance with this inquiry? If so, we would appreciate you providing the additional information we were requesting in the previous post. -Jack

You're very welcome @User_V5KBL! Glad we could help 🙂 -Jack

Greetings @User_V5KBL, Testing on my end, I was able to print the value of a Transaction Line Formula Field using Advanced PDF Templates. See my Custom Field and Advanced Template setup below: Custom Transaction Line Field: Advanced Template Code: Result: You can compare your setup with the above to check if there is…

Greetings @Richard Appleford OB, Here are 2 tricks via Browser Console scripting (Press F12 to open the Browser Console) on Edit Mode that you can try to be able to change the Customer Category field without disabling any workflows. Choose the one that you prefer. 1. Directly change the value of the Category field using…

Thanks for the update @rburns515. To keep the discussion in the thread related only to a single topic, kindly post the specific inquiries/concerns that you will come across in separate threads. This will also help the community members get relevant search results if they also have the same inquiry/concern. -Jack

Hi @rburns515, Have you already gotten started on this? As mentioned, we might be able to help you with specific concerns or inquiries in the course of the solution development. Let us know if you have come across some roadblocks. -Jack

Greetings @Betsy Vance, Checking on my end, Custom Records are showing up just fine when creating a new Dataset. See the screenshot below: One possible cause of the concern here is caching issue. To check this, try creating a new dataset in Incognito/Private Browsing mode of your browser. If the Custom Record is showing up…

Greetings @User_ZM320, In your scenario, using Cached Data for your workbook might help. Refer to the following SuiteAnswers Article for more information: 106603: Using Cached Data in SuiteAnalytics Workbook Let us know how this goes on your end. If you find this reply to your question useful, others might be as well. By…

Greetings @Arun Dasari, Are you using the NetSuite2.com data source or the legacy NetSuite.com data source for your connection? -Jack

Looking further, it appears that you are correct that it is possible to add conditions to the Element Text of a Custom Element in Basic PDF Layouts. I found SuiteAnswers Article 82921 which has the syntax below that you are looking for: <%= CASE WHEN <condition> THEN <ConditionIsTrueResult> ELSE <ConditionIsFalseResult>…

Greetings @Entartes, If you are referring to the Element Text formula for Custom Elements in Basic PDF Layouts, it seems that you can only use NetSuite Tags (e.g. {fieldId}) per the documentation in SuiteAnswers Article 10121 as there's no mention of support for SQL expressions. See the clipping below from the article:…

By the way, I have edited some of your comments on your behalf that included sensitive information such as your Account Number and Account Name. So, please check this in every thread/comment that you will post next time. -Jack

Hi @Eklon Eleuterio, Thanks for providing your project files. I tried validating and deploying your project on my side and the validation succeeded. However, I got an error without details with one of the dataset objects when deploying the project. See the screenshot of the deployment log below: So, we could be getting…

Glad to hear that @Rizkygaus! By the way, we would greatly appreciate you clicking the "Yes" button for “Did this answer the question?”, on the replies here that helped resolve your concern. By doing this, you’ll be able to help the community find the solution much easier and faster without the need to read through all the…

Thanks for the update @Rizkygaus. Can you provide the Workflow log for a record you have already approved on the Approve Vendor Payments page on the Pending Approval State? Also, I noticed that you had customized the sublist view in the bulk approval page and might have removed the Workflow : Button filter (see screenshot…

Greetings @User_C5N4B, Welcome to NetSuite Support Community and thank you for posting your question here! For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. By the way, it would be great if we will be able to recognize…

Greetings @Entartes, Thank you for posting a new inquiry here in NetSuite Support Community. We will look into this and will get back to you with an update. To other members who have any ideas, feel free to share them here. -Jack

Thanks for providing the steps you took in the workbook @Eklon Eleuterio. It appears that you are also correct that different datasets can be used on separate visualizations (tabs). So, I tried creating a new project with a workbook that uses 3 different datasets on separate tabs, and I was able to successfully validate…