Vernita Bronze Trophy

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…

Hi Jack Thanks again for your response When I remove the available filter, the sublist shows no results Regarding the suitelet, I don't have any knowledge of coding or creating one of these. Is there anywhere I can find out more on how to do this for this particular example? thanks

Thanks for the explanation Michelle on how to set up the CRM field I am little bit stuck still on how I can use this to filter the list of available projects to those where the employee is assigned as resource? Thanks

Hi Chris I have tried the following though it is still not the correct figure For example, one employee works Monday to Friday, 8 hours per day Taking the date range 1/5/2020 to 5/5/2020 gives 72 hours using this formula

This screencap shows what I am trying to achieve thanks

Hi Michelle I have had a look and this is enabled It looks like there is an issue with the naming convention of files generated on the 'print' button of invoice or credit memo records. Previously, these would be accessible/searchable through the global search bar. Now, these don't appear to be stored anywhere Where can I…

Hi Camille Yes, that is correct: the first screenshot is of the results from the saved search, the second is the criteria and the third is the formula behind one of the additional columns used in the search The saved search is on time entry records I am trying to find the sum of all billable hours (a project task flag on…

Hi Michelle Thanks for looking into it. I have found the way to create a hyperlink so that it updates with the record ID (I am including my findings here in case anyone else finds this useful) The URL format: Companyaccount.app.netsuite.com/app/common/custom/custrecordentry.nl?rectype=99&id=${customrecord.id} The non bold…

Thanks so much for the detailed response Jack. I will try this later today and let you know how I go