Best Of

Re: workflow to update custom record field on schedule

Unfortunately, this is not possible natively.

On a brighter note, if you really need this to requirement, I have thought of a workaround. However, this would be a long process.

First, you'll need to create a Transaction Saved Search that shows the Approval Status on Sales Orders. Here's a quick sample of the Saved Search:

Once done, you'll need to create a Custom Field on Sales Orders that uses the Saved Search as it's source.

Since this field is sourcing from the Saved Search (therefore the Store Value is unchecked), we'll need to create another Custom Field (With Store Value checked) and create a Scheduled Workflow (On Sales Orders) that will set the Custom Field (Store Value) via the Custom Field (Sourced via Saved Search).

Once done, you should now be able to use that field as a source for the Custom Field in the Custom Record:

I hope this helps!

To our other members, feel free to share your ideas and suggestions on this. 😊
___
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 “Did this answer your question?”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies, and you will also get closer to earning your next Answer Accepter badge.

Jervin Nicholas Teopengco-Oracle

1

Re: Can scripts be locked within account customization projects using SDF?

thank you @Richard James Uri-Oracle ,

I am looking for NetSuite Account customization but not suitecommerce advanced, sorry with my initial query, may be I suppose to elaborate more, could you please let me know your inputs, once again thank you so much

Nayeem Rahman Shaik

1

Can scripts be locked within account customization projects using SDF?

Can scripts be locked within account customization projects using SDF? As I see documentation its not possible, however I would like to know on the alternate solutions to lock the objects using SDF, please suggest!

Nayeem Rahman Shaik

1

Re: Is it possible to encrypt contents of a SuiteScript in NetSuite & deploy it? if yes how? if not why?

Hello @Richard James Uri-Oracle thank you so much for sharing the related info, it is helpful, but we are looking for something like we want to encrypt the whole script file and use it in NetSuite, is this possible?

Nayeem Rahman Shaik

1

Re: How to create a NS saved search with criteria to get open invoices with 30,60,90,120 past due date?

Hello @Jeremy Guimaras -Oracle thank you so much for the quick updates and follow up, very appreciated, it is helpful, with that reference, we tried with different ways, finally got the output as expected, please check on the below screenshots for reference,

Using below criteria we get the invoices with 30 days past due,

Using below criteria we get the invoices with 60 days past due,

Using below criteria we get the invoices with 90 days past due,

Using below criteria we get the invoices with 120 days past due,

In the results tab pulling below information,

Hope it will be helpful for the ones who are looking for past 30, 60, 90 and 120 days invoices with the past due,

Actually this was queried by one of my friend, I shared him the ideas to achieve the solution with your reference, now he is fully happy with it and got what he expected, once again thank you @Jeremy Guimaras -Oracle , thanks to my friend as well who given me the screenshot to post it here so that it is helpful to others in our group,

Nayeem Rahman Shaik

1

Re: How to create a NS saved search with criteria to get open invoices with 30,60,90,120 past due date?

You are welcome, @Nayeem Rahman Shaik 🙂

I'm glad that you were able to tweak the saved search according to your business need. Thank you for sharing it as well so our members who might need the same can easily see.

Have a great day ahead!

Jeremy Guimaras-Oracle

1

Re: Summarizing [Deferred Revenue Waterfall Detail] report

Thanks @Patrick Fresnosa-Oracle

After reading your response, I tried grouping to summarize then found [Transaction Demension: Period Name] which is the name of month for us.

So I was able to get the view I wanted!

Now I will try to find a way to order the system to only generate at the summary level instead of generating a report and then group them to make the report faster.

If you have any insight on this please share as well.

Thanks again!

Burton_K

1

Re: Vendor or customer specific Pricing Sublist

I found that this was filed under

Enhancement # - 164589

Summary: Multiple Vendors = T > Go to Lists > Accounting > Items > View any item > Be able to add a custom field in the Vendors subtab and customize the vendors sublist view.