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…

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!