@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 ?

Any updates on this @Niks Blando-Oracle ? thanks

Hi @Katerina Winklerova-Oracle No the bank details are not updated. That might be the issue. I haven't customised it though the common thread with the two accounts where that issue is seen is they have an old bundle.

Hi @Clarisa De Torres-Oracle There is no net amount column available in the transaction dataset from what I can see

Hi @Patrick Fresnosa-Oracle In this case, the subsidiary currency and the parent currency are the same (AUD). It is only the transaction that was conducted in another currency (USD). Why would this use the consolidated exchange rate? Wouldn't the consolidated exchange rate be used when the parent and child subsidiaries…

Hi @Angelica Mae Segador-Oracle Just to clarify, I was wanting the system notes on when a child record was attached to a parent record. Not so much the ability to create a child record (which I can do). But more around when the child record was attached to the parent. From the system notes, i can see that visible on the…

Hi @Tigran Shahnazaryan I saw that though assumed that shouldn't affect the bank details record. There is a default company wide calendar and one on the employee record. Since that error only appears in one of the environments of the account, I believe this is an issue with the script/version of the bundle.

Hi @Clarisa De Torres-Oracle I did and I can't see that field: