Best Of

@Angela Bayliss my company doesn't use purchase orders

Issue resolved. I had the wrong object type. See corrected code snippet

var currentDate = new Date();

var invoiceDueDate = new Date(currentDate.setDate(currentDate.getDate() + 10));

scriptContext.newRecord.setValue({fieldId: 'duedate', value: new Date(invoiceDueDate)})

Hi @User_UEJ7U,

Glad to have you with us today. Thank you for creating this thread. 😊

Hi, Everyone! You are welcome to join the conversation and share your insights.

Hi @Nermin Wahdan-Oracle,

Thanks for posting your concern here! 😊

Hi, Everyone! You are welcome to join the conversation and share your insights.

Hi @Philly_NS,

Good day! Have you tried using {itemid} on the formula? Here's what I've tried on my test account:

Let us know if 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 “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.

Hi @User_7BO09 ,

Please try to check the following SuiteAnswers articles for date differences:

Create Custom Field to Calculate Difference Between Two Date Fields in Months

Saved Search Formula to Calculate Time Difference in Hours Between a Date Field and a Date/Time Field

Create Custom Field Calculating Date Difference

I hope these details help. Best regards,

I was able to create 2 saved searches (as stated above). Am just waiting to hear back from the user who requested this to see if it satisfies requirements. Will certainly let you know as soon as I know anything for sure. Thank you!

Sorry I was able to find it.

Hi,

Upon checking, there's an existing Enhancement requests for this:

• 339129 SS > Change field background color using SuiteScript (Client and Server
  sides)
• 182545 SSS > to be able to set the background color for the custom sublist

You can vote for this enhancement on the SuiteIdeas page. See 10054: Voting for Enhancements

You're welcome @Toanne Termeer 🙂