coffeeguy Blue Ribbon

we have a similar issue with a newly installed bundle. Initial emails do not e send when a note is first created. User's replies do trigger email notifications.

This is one way, there could be others, but this one works. LAST_DAY(ADD_MONTHS({duedate},-1))+15 To explain, I move the "due date" back one month, I now get the last day of the previous month and add 15 days. So, in full: Formula (date) field (not the original formula (text) CASE WHEN TO_CHAR({duedate},'dd') <=15 THEN…

Hi @User_QHG6U to understand you, you have used the formula CASE WHEN TO_CHAR({duedate},'dd') <=15 THEN '15th Day' ELSE '30th Day' END and you would prefer to have the output as a DATE instead of the TEXT "15th Day". so 1 Feb 2021 returns 15 Feb 2021 2 Feb 2021 returns 15 Feb 2021 18 Mar 2021 returns 30 Mar 2021 I'll have…

A few options: This would be a nice way for you to introduce your self to Analytics in Netsuite. Display the transactions and a nice pivot. A Saved Search and an additional Group by Date by Quarter and Amount Sum A saved search and add some columns with the amounts for each quarter.

to me this sounds like you will need a couple of sales order custom transaction body fields and a process like this: Total Edit time (defaults to 0) then each Edit it gets update adding the additional time. Load Time - would be a date/time field with a default of the load time of this Edit, populated before load. Save Time…

@Lina Fetter did you do a refresh on the Reminders portal? Can you post a screenshare of the criteria?

@Deepak Joshi would it work for you to only include the actual amount of the item in the Work Order and then trigger an Inventory Adjustment after the completion of the Assembly Build to consume the item by transfer to scrap? Work Orders 9.7 metres of Item A Inv Adustment -0.3 metres of Item A +0.3 metres of Scrap Item One…

I know I’m a bit late but the InternalID cannot be set by an import which is why it does not appear in the Add. External ID if missed in the earlier imports can be added later with an Update CSV import of Internal ID , External ID coffeeguy

function setPDFName(){ var email_template = '20'; var filename_suffix = "New Suffix "; //leave a space at the end //Send and receiver var sender = nlapiGetContext().user; var receiver = nlapiGetFieldValue('email'); //Get the internal id of the transaction var tranid = nlapiGetRecordId(); //Print the transaction as a PDF…

This proposed new formula field will give the same value for the dates as follows: Days 1-15 will return 15th Day Days 16 - 28,29,30 & 31 will return 30th Day explained CASE WHEN TO_CHAR({duedate},'dd') <=15 THEN '15th Day' ELSE '30th Day' END This part of the formula TO_CHAR({duedate},'dd') returns just the day of the…

@mandry one way would be to achieve this via a simple scheduled script that will email the search results after saving them to the name you need. There are sample codes in this foum.

@skulkarni_33360 when you are looking in the Workflow Actions, look for Transform Record which will allow you to Transform your Sales to these options: One way I'm currently using this is trigger when Sales Orders go from Pending Fulfilment to Pending Billing. As mentioned our saved search looks for Sales Order : Pending…

@Mark_BRIT have you tried updating your fields without changing the Form? IME, although the record may have the "minimal" form, it is is likely that you can update the fields. I have a account where we do not display the Department in the transaction header. Due to the way taxes are assigned, we do need the Department…

@Nairolf Let me tell you something I used for quite a few year using Netsuite Cases. When we closed a Case, we had a script which posted a financial journal to take up a fixed employee cost and post to our Cogs account. We created the journal with Customer Name, Case No at Line level. In your situation, the actual accounts…

I think this article https://netsuite.custhelp.com/app/answers/detail/a_id/75940 is going to work for us. All good now. :)

@Shamaine Chan-Oracle as an external observer there seems to be two parts to this. A/P Receiving the bill ($12,000), taking up the charge and then settling the invoice over 10 period. This would be done with that cool Instalments Term setup with 10 payments of $1,200 over 10 months. (first time for me to notice that…

I would be drawing inspiration from Netsuite Bundle 34958 - End of Month Payment Terms if you want to make the change within the actual defined Terms. Look at how they found end of month and adjust it so you find 15 & 30. Alternatively, you could have a Custom Transaction Body field that gives you "Next Payment Run" based…

OK, got it.

@Michelle Jabanes-Oracle so in this method you are saying we set the tab to be available to the Audience of the saved search and the new Tab we create we make with the dashboard layout we want.

What I think is happening is that the browser when loading the URL sees the part of the name after the & as the next parameter custrecord_his_services_survey_project=Me Parameter as expected = Me custrecord_his_services_survey_project = Me & You Parameter custrecord_his_services_survey_project = Me Parameter You = null and…

@rlandick a couple of options for you to explore depending on the number of vendors per item. 1-2 vendors If have 1-2 vendors then you can add them in the Import mapping. You would have them as a additional columns across your Item CSV flat file Item Details Columns.... Vendor 1 details Columns.... Vendor 2 detail…

@Meherin here is an ideas A. Publish Saved Search you could use the site builder in your account to use Publish Saved Search. You first have a Saved Search of the Inventory items you want included and the columns you want to present. Name, Description, Location on Hand. The layout would come from the Theme.

My thoughts... Current Year Inventory = Minimum (Location On Hand, Item receipt current year)

Thank you. We won’t be provisioning that just for this feature. Maybe my question was “Is there an method for achieving a consistent Employee Center dashboard?” hopefully without Suitepeople

@Mark_BRIT and others I've seen this in two other accounts and now that I check, both times it is the original customer's administrator at the time of provisioning. The same fix worked ie untick the auto, rename, save etc

What if.... Idea 1 You have a Saved Search of the 5 matrix items that make up each time. The search SUMS the line Qty of orders. Then put that number (or maybe 400 minus the sales) on the Parent item and maybe the same number onto each of the Matrix items. I'm thinking trying it as a custom Item field based on the saved…

I just had a look at a Workflow script that we have to send an email //Get the internal id of the transaction var tranid = nlapiGetRecordId(); It is a SS1.0 Workflowscript that can be triggered in a workflow which will rename the attachment from the default NS transaction name and then send the email. Here is is as it…