Vernita Bronze Trophy

Hi @Michelle Jabanes-Oracle Wouldn't this mean the Sales Manager (Jeff in this example) won't be able to see his team members' quotas included in the quota KPI on the dashboard? The issue here is that Jeff's boss's(Shaun's) quotas are also included in the quota KPI. Jeff still needs to be able to see his direct report's…

Hi @Angelica Mae Segador-Oracle I didn't see any option to use a saved search for that field unless I use free-text field type. Off memory, I had created a hyperlink to the returned result using this method, but I believe I ended up having to use two custom fields (it was some time ago that I did this) so that one field…

Hi @Joahnna Given Uy-Oracle I had worked out a workaround for this: Use a custom field and not a workflow state field or workflow field. Then use a before record submit to store the initial value (on record creation) : I just wanted to check if there was a way to do this with workflow level fields or state level fields

Hi @Angelica Mae Segador-Oracle I am not trying to filter out the type of transaction. I am trying to set the value of the drop down field with the only matching result.

Hi @Joahnna Given Uy-Oracle The record type is a sales order, I want to store the value of the "expected shipping date" on an existing record, before the user edits it. For example: On SO123, the "expected shipping date" is 7/8/2023. The user presses edit on SO123. Before the value is edited, the "expected shipping date"…

Hi @Robert Nedelkow-Oracle I wasn't able to upload images with just the permission change. I changed my password which has worked. thanks

Hi @Robert Nedelkow-Oracle I am having the exact same issue as the original poster on this thread

@Michelle Jabanes-Oracle I have uploaded the IDP metadata from production into sandbox. However, the sandbox environment is still not available via the list of available accounts in the single sign on. Is there an additional step required?

EDIT: I think this seems to suggest it is possible to use RP and SB accounts: https://suiteanswers.custhelp.com/app/answers/detail/a_id/102813 Will look at setting it up. Hi @Michelle Jabanes-Oracle That was what I ended up doing to give the users access. Is it actually possible to access the sandbox environment with…

Hi @Angelica Mae Segador-Oracle Any response on this?

Hi @Richard James Uri-Oracle Revisiting this thread since I have a follow up question: Is it correct a suitelet (such as the one in the link) can only be used to restrict a custom field and not a native field such as the serial/lot number field on the inventory detail subrecord?

Thanks @Pedro Alegria-Oracle That is what I was after

Hi @Angelica Mae Segador-Oracle Thanks for the response. Is it possible to source the field in a saved search?

Hi I have working version of the code (credit to Raghav on Netsuite Slack for help on formatting filter): /** * @NApiVersion 2.x * @NScriptType MapReduceScript */ define(["N/runtime", "N/search", "N/util"], function (runtime, search, util) { function getInputData() { var scriptObj = runtime.getCurrentScript(); var…

Hi @Angelica Mae Segador-Oracle Not sure what you mean by sourcing using free form text? The field type is list/record. Are you saying I should change it to free form text? If so, how would that point to the related record as a hyperlink?

Hi @Michelle Jabanes-Oracle Thanks for the response. Is there a way to bring in other contact details into this search? Specifically, I wanted to bring in company name for the receipient whose email address is included. I can't see the related table to do this. I have tried with analytics though I have found a discrepancy…

Hi @Angelica Mae Segador-Oracle Thanks. I know how to create a custom field and source it. However, it appears as a drop down with one value rather than setting the value on the project record I need this field to source the relevant returned result rather than having to select from a drop down This is the set up

Hi @Nicole Mendoza-Oracle Can scripts be deployed to inventory detail subrecord though? i.e. Client Scripts and/or User Event for standard Netsuite fields

Hi @Nicole Mendoza-Oracle yes, the filter array shows 14651: [ "2", "3" ], 14654: [ "2", "3" ], 14660: [ "1", "2" ], 14663: [ "2", "5" ] }

Hi @Katerina Winklerova-Oracle Thanks for the proposed solution. The end user was wanting another option if it is feasible: Is it possible to have a saved search showing which sales orders were pending billing as at a specific date by having a criteria that effectively 'ignores' any invoice related records of the sales…

HI @Nicole Mendoza-Oracle The audit trail had no filters yet the failed login attempts did not appear on this list

@Tiru Chembeti I have installed it in another account and can't see that field on any subsidiary records

Hi @Katerina Winklerova-Oracle Is it supposed to automatically add a bill to the income/expense tab if the bill is created (and not edited) with reference to the related asset in the related asset line field? So far I have found that to not be the case.

Hi @Tiru Chembeti I don't have that checkbox on the subsidiary record. Is that part of the suiteapp? Thanks

Hi @Micah Timbol-Oracle I wanted to set up the expense validation suiteapp so that if expenditure is entered on a supplier bill that exceeds the budget for that line, a warning shows up. I have followed the instructions for the suiteapp though cannot get the validation to work.

Hi @Micah Timbol-Oracle I had already marked one of your comments as the answer. thanks

Thanks for the link @Richard James Uri-Oracle So would this (suitelet) be used in place of the standard location selection drop down in a sales order record? Thanks

Thanks @Katerina Winklerova-Oracle So does that mean the limitations listed on Suiteanswers: shouldn't be an issue here?

I have edited the script though am still getting an error // Create the search using the filters var invoiceSearchObj = search.create({ type: "invoice", filters: filters, columns: [ search.createColumn({ name: "internalid", label: "Internal ID" }), search.createColumn({ name: "trandate", label: "Date" }),…

Hi again Any updates @Niks Blando-Oracle ?