@Grant B Thank you! That worked. Hi @Herdi Rana-Oracle . I tried Grant's solution and it works for what I am after. For question 2. though (filtering sublists on a entity tab) I still need a bit of help please. Thanks

Hi Micah Thanks. I was after something more in line with Netsuite's native working calendar, which shows an employee's available hours, without having to create extra entries myself. The placeholder time entries was a workaround I was thinking of to achieve that though I don't want to create entries via a csv import or…

Hi Micah That would create one entry for one employee from what I understand. How do you do this en-masse so there is an entry for each period the employee is set to work? i.e. creating an entry for all the hours they were available to work?

 @Micah Timbol-Oracle Hi. Any updates? My access to Netsuite finishes pretty soon so I was wanting to see if this can be done before then thanks

Could you please provide the screenshot of your script deployment showing the available options under Applies To field? Please navigate the field to show all options starting with "Pr". This is what I get when I try to deploy it:

Please file a case to support team since this is a possible defect. You should have Project Task record as one of the options for deployment. Please also mention the checks that we've done so far. Thanks! Erick Dela Rosa-Oracle Ask A Guru Thanks for all your help. I tried it again in another demo account though came across…

Could you please send the screenshot of your Script record showing the Deployments tab? I selected project since there was no project task option.

Yes, this was already enabled The following is what I get when I try to view the details behind the task record: { * "type": "projectTask", * "id": "271", * -"fields": {* "_csrf":…

Is the Project Management feature enabled in your account? This is necessary to work with project tasks. It's located in Setup > Company > Enable Features > Company subtab > Projects > Project Management. Yes, this was already enabled

Thanks. I have fixed the beforeLoad issue and now I am able to save script. When I deploy it though, I can no longer click into a project record since I get the following error: I have amended the script so it is now: /** * @NAPiversion 2.0 * @NScriptType UserEventScript * @NModuleScope SameAccount */ define ([], function…

You should use the same function name that you're trying to return. Your function name is beforeload while your return is beforeLoad. See the difference? To correct this, you may opt to change the function name to beforeLoad. Furthermore, the code works fine even without specifying N/record in define line. Let us know if…

Thank you for your help Erick. I am getting an error when I try to upload the script: This is the script I am using: /** * @NAPiversion 2.0 * @NScriptType UserEventScript * @NModuleScope SameAccount */ define ([], function () { function beforeload(context) { var serviceItemField=context.newRecord.getSublistField({…

Hello @"New_44789", You'll have to deploy a user event script with beforeLoad. Here's the user event script to make the service item field from the assignee sublist mandatory. The script utilizes the N/record module to get the service item field from the assignee sublist and change it to mandatory. Hope this helps. @"Erick…

Hi Jack Daryl Espiel-Oracle The above post is really useful. I know that this workflow can only be set to work with item sublists. If a field is set to mandatory at the sublist level though, is there a way to enforce that when the sublist is used as part of a form? For example: A project assignee sublist has a field called…

Hi @"New_44789", Thank you for the feedback! To answer your question regarding your given scenario, currently, since SuiteFlow generally supports only the Transaction Item Sublist for all Actions, you may have to use SuiteScript to get your desired result. Also, the Service Item field on the Project Assignee Sublist…

Hi Michelle Any updates on this?

Hi Michelle This permission was already there. I think it was related to the employee's subsidiary being different to the customer's subsidiary. (I will have to have another look...I changed a few things last week though can't remember what it was) It seems to be working now. Thanks

Hi Michelle Thanks for looking into this.

Hi I never got a chance to test Michelle's linked solution. The issue of spam seemed to exist for only a handful of customers. As a result, it was decided that there invoices would be sent separately and not via Netsuite.

Thanks Micah. I tested it again right now and the issue seems to be there in Chrome though not in Firefox.

Thank you Mikko. Right now, I have tested this with another account which has 3 rows of data and found the same issue It seems like the 'pivot' option is no longer working

Hi Micah Apologies for the delay in response and thanks for looking at this. I am trying to replicate this right now. To clarify, in the decode function, are the returned values (11,38,2,37.5,6,37,etc) the work calendar hours by week? e.g. 2 hours available to work for the first week 38 hours for the second week 2 hours…

Thank you. I was looking in the script deployment record's tab and assumed that if I couldn't see it there, that information wasn't stored anywhere. Kind of related to this, is it possible to see who changed the settings of a feature? In this case, some user has unticked the 'trigger workflow or script' for CSV import…

Hi Pauline I just tested it now and it works perfectly! As usual, thank you so much for your detailed, easy to follow answers

Hi Pauline Thank you for your detailed help. I will have an attempt at this and let you know how I go. Thanks

Hi again Erick I have managed to load the scripts from what I can see (I'm not sure of some of the symbols though I managed to load all 3 scripts without the script deployments giving me any error messages) I am finding the buttons on the suitelet are not doing anything though I ran that through the debugger though did not…

Hi Erick are there any sample scripts that I can use to implement this solution? I can deploy scripts though don't have any knowledge of writing them Thanks

Hi Jack The other thread is an offshoot of this one and is looking at one particular aspect of this (namely, how to populate the child record on to the parent record) This one was more about the best approach as a whole. I would still be interested to know whether it is possible to approve child entries in bulk without a…

Hi Michelle I have had another look. There was a file generated with the correct naming convention. The problem is what it is pointing to. i..e. previously, a file with the naming convention "Credit memo for invoice FIN4546805" would point to the pdf file of the credit memo created against the invoice record for…

Hi Jack So for the approval of entries, I should have been clearer, there is already approval routing in place. 1.The employee codes time against a project. 2.The checkbox 'include' is marked for certain projects. This is sourced from the project task. i.e. the 'include' box is marked at the project task set up- this flows…