Jervin Nicholas Teopengco-Oracle · SuiteBuilder · Silver Crown

Hi @Dext3r, Have you tried this formula below? {subsidiary} IS 'MPSL' AND LOWER({createdfrom}) LIKE '%purchase order%' I've added the parenthesis on the LOWER function. Here's how it ran on my test account: Let me know how it goes. ☺️ ___ If you find this reply to your question as helpful, others with the same question…

Hi @RS_RS, As promised, this is the thread I've created on your behalf. Please allow me to further check this on my end. I'll let you know if I'll have any further questions. Thanks!

We are now closing today’s session. We hope to see you in the next #AskAGuruLive! I hope the tips I provided will be helpful for you. 😊 Be sure to follow the AskAGuruLive tag for updates. To help us improve this program, feel free to share your feedback with us. Have a good one, everyone! 🎉

Hi @RS_RS, Thank you for providing this! Since the duration of the AAGL is now over, please allow me to create a thread on your behalf and I'm more than happy to continue this conversation there. 😊 Thanks!

TIP 3: Ever wanted to revert back to a previous version of your Advanced PDF Template? Here's how: On the bottom left corner of the page, you can find the Template Version of your Advanced PDF form. If you want to revert back to a specific version, you can add this text &version=11 on the URL of your browser. Once done, it…

TIP 2: How to check on the Dependencies of Custom Fields: Note: On this example, we are using a Transaction Body field. 1. Navigate to Customization > Lists, Records, & Fields > Transaction body fields 2. Click on the Custom Field you wanted to check (In this case, we are using NSC Test Body Field) 3. On the Transaction…

Hi @RS_RS, Good day! Would you be able to show me the setup of your custom field (custcol_cs_sub_project)? So that I could replicate this on my test account. Thanks!

TIP 1: In case you wanted to have the Preferred Vendor on the header of your Item Records, here's how we can do it: Navigate to Reports > Saved Searches > All Saved Searches > New and click on Item On the Saved Item Search, set the fields below: Search Title: <Input your Search Title here> Under Results subtab: Sort…

Hi @Dext3r, Normally, what I do is check the Field ID by double-clicking on the field (when Show Internal IDs is enabled). I also have this external chrome plugin called NetSuite Field Explorer this basically creates a small pop-up on your browser that displays field ids with their values (Same behavior when you input…

Hi @Nickey, Let us know if the information provided in my previous comment was helpful. 😊 We would greatly appreciate if you can click "Yes" on “Did this answer your question?” on the previous comment. This will also help other community members who might have the same concern find the answer easier. Hope you have a great…

Hi @Tigran Shahnazaryan, thank you so much for sharing your insights with this! 😊 Hi @Nickey, Upon further checking, I've found several cases related to this and found out that this is a current limitation and an Enhancement is logged for this. This is logged and being tracked under Enhancement 136788 Canada…

Hi @Nickey, Good day! We have come up with a workaround wherein we'll use a Saved Search to Source the Built field onto a Custom Field. This way, we'll be able to use our condition properly. Please see the steps below: How to create the Saved Search: On your Transaction Saved Search, please input the values below: Search…

Hi @RS_RS, Unfortunately, upon further checking, this is not possible yet as there is no direct sourcing of files to transactions. I've also consulted this with our SuiteCloud team and it's also not possible via scripting. Though they've mentioned an enhancement related to this. This is logged and being tracked…

Hi @Dext3r, Good day! Have you tried removing the CASE WHEN on your formula? I've tried using the LIKE condition and seems like it works on my end as seen below: I hope this helps! 😊 ____ If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the…

Hi @Tafranklin5, Would you be able to confirm what error you were experiencing? Also could you try this: TO_CHAR({datecreated}, 'Day') As this seems to work on my end as seen below: Let us know if this helps!

Hi @Nickey, Thank you for confirming. I've found out the reason why this is not working. It's because on Edit mode, the Built field is not present on the form which triggers the Workflow that it's not equal since the Built field is not existing on that instance. With that said, I'm currently testing further on my end if…

Hi @brocha, Let us know if the information provided in my previous comment was helpful. 😊 We would greatly appreciate if you can click "Yes" on “Did this answer your question?” on the previous comment. This will also help other community members who might have the same concern find the answer easier. Hope you have a great…

Hi @Peter Bergsma, Let us know if the information provided in my previous comment was helpful. 😊 We would greatly appreciate if you can click "Yes" on “Did this answer your question?” on the previous comment. This will also help other community members who might have the same concern find the answer easier. Hope you have a…

Hi @Peter Bergsma, I believe this would be possible by creating a Custom Field that sources the Preferred Vendor Purchase Price then on a Workflow, we'll use this field as the source of our Set Field Value. How to create the Item Saved Search: On an Item Saved Search, set the values below: Criteria subtab: Filter: Formula…

Hi @Tigran Shahnazaryan thank you for sharing your insights with this 😊 Hi @brocha, Good day! Upon further checking, Tigran is correct. You could utilize the Same Row as Previous feature so that the State and Zip fields will be next to each other in one row. However, if you still wanted to make a field invisible, we could…

Hi @jm4160, Upon further checking, we found out that the Maps for Netsuite SuiteApp is not owned by NetSuite. In order to customize or configure this bundle, you may need to contact the Bundle Owner and they should be able to help you out. I apologize for the inconvenience. But to our members out there who would like to…

Hi @User_Z8H2D, Unfortunately, we cannot reproduce your concern via our test-account due to your concerns' configuration. We recommend you to create a case in NetSuite support to further investigate your concern. That way, Support will be able to further check the duplicate of your account via the secured QA environment…

Hi @RS_RS, My apologies for the late revert on this. We're currently testing if this is possible with the Document type custom field. We'll let you know once we're done. Thanks!

Hi @User_I42GU, Let us know if the information provided in my previous comment was helpful. 😊 We would greatly appreciate if you can click "Yes" on “Did this answer your question?” on the previous comment. This will also help other community members who might have the same concern find the answer easier. Hope you have a…

Hi @brocha, Thank you so much for providing this. We're curerntly testing this on our end. We'll update you once we're done. Thanks!

Hi @Sivasubramaniam, Unfortunately, this is a current limitation. We can only specify the Width for Free-Form text, Email, Hyperlink, etc. As seen below: For fields like Rich text, Long Text, and Text Area, we can set the Width and Height for this: I hope this helps. ___ If you find this reply to your question as helpful,…

Hi @Nickey, Good day! Can you try using this code instead? nlapiGetFieldValue('orderstatus')=='G' && (parseFloat(nlapiGetFieldValue('quantity'))!=parseFloat(nlapiGetFieldValue('built')) && (!isValEmpty(nlapiGetFieldValue('quantity')) || !isValEmpty(nlapiGetFieldValue('built')))) Thanks! __ If you find this reply to your…

Hi @User_2LD8N, Let us know if the information provided in my previous comment was helpful. 😊 We would greatly appreciate if you can click "Yes" on “Did this answer your question?” on the previous comment. This will also help other community members who might have the same concern find the answer easier. Hope you have a…

Greetings, everyone! We have a fellow member, @Neo_Suite, who could use our assistance. Please don't hesitate to share your knowledge and best practices to help them out. Your input is highly valued and appreciated! In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our…

Hi @DanishBernadeth, Since you were able to move the Delay to the Transition, I would like to confirm if the workflow is now executing as expected on your end? Thanks!