Jervin Nicholas Teopengco-Oracle · SuiteBuilder · Silver Crown

Hi @Peter Bergsma, Can you confirm if I'm getting this right? If the Preferred Vendor on the Item Record is Euroworks, you don't want it to update the Purchase Price? If yes, I believe we can retain the changes you've made on the Saved Search then add a Condition in the Workflow Action to not execute it when the Custom…

Hi @User_G9GZ7, Good day! Sending a gentle follow up on this in case you haven't read my previous reply. Thanks!

Hi @User_76ANW, Thanks for confirming! Glad to hear it's working ☺️

Hi @Rick Cobb_2, Good day. Would you be able to share the setup of the Picked By custom field? So that we could try to replicate this on our test account. Thanks!

Hi @User_G9GZ7, Good day! We would like to confirm if what you're referring to is the Chart of Accounts? If yes, would you be able to send me the steps to reproduce on how your End Users use the Accounts? So that I could try it on our test account to further check if this is possible via workflow. Thanks!

Hi @User_Q1DPO, Good day. We're currently testing this in our test account. We'll update you once we're done testing. Thanks!

Hi @User_76ANW, I would like to confirm if you manually typed in the Shipping Cost field in the SO? If not, I believe we can change the Trigger on to After Record Submit then add a Condition so that it will only trigger whenever the Shipping Cost is not equal to the Custom Field. First, we'll need to change the Display…

Hi @User_76ANW, You're welcome! Glad I was able to help you. 😊

Hi @User_76ANW, Unfortunately, we can't use the sourcing functionality of the Custom Field itself since we'll have to disable the Store Value feature to use it. Which means it wouldn't show the changes under the System Notes. Let me know if you have any further questions regarding this. Thanks!

Hi @User_76ANW, Good day! I believe what we can do here is to create a Custom Field that will act as a placeholder of the values then have a Workflow that will source the values from the Shipping Cost. How to create the Field: Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New On the…

Hi @Morgan Elmac, Upon further checking, our best bet for this is to attach it to the said enhancement. This is logged under Enhancement 59080 Vendor Record> Parent/Child (sub vendor) relationships on Vendor records, similar to customer records. You can vote for this enhancement on the SuiteIdeas page. At this time, there…

Hi @RS_RS, You're welcome! Glad I was able to help you with your questions. 😁

Hi @Peter Bergsma, Have you tried using the Preferred Vendor field on the Criteria of the serach? Let me know if this helps!

Hi @User_2LD8N, Unfortunately, due to system limitation, the only way to check this right now is by checking on each field. We really do appreciate your understanding on this. But to our members out there who would like to share their insights on the matter, don't be shy and comment on the thread!

Hi @Adinath Bodakhe, Since you've mentioned that this works for some records, we highly recommend you to create a case in NetSuite support to investigate your concern. As we cannot reproduce your concern via our test-account due to your concerns' configuration. Once you've created a case in NetSuite Support, they will be…

Hi @User_QJMYJ, Good day! We highly recommend you to file a case in NetSuite Support. As they are equipped with the right tools to investigate further on the behavior on your workflows. We appreciate your understanding on this.

Hi @RS_RS, Upon further checking, this is a current limitation. However, I've come up with a workaround for this. We'll have to create a new Custom Line Field that will source the Project ID of the Project. How to source the Project ID on a custom field: Once you've created the new Custom Line Field, set the fields below:…

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…