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:

Thanks @Clarisa De Torres-Oracle ! That worked Though am I able to access that field in a dataset for transactions? (rather than sales (invoiced))?

Hi @Clarisa De Torres-Oracle That option doesn't appear for me in any of the accounts I am looking at for Sales (Invoiced) dataset

Sorry, related to that @Clarisa De Torres-Oracle , the amount (net) transaction currency field doesn't appear to be in the Transaction dataset. It seems to only be present in the Transaction Line data set

Hi @Patrick Fresnosa-Oracle I am using the transaction data set. The field I am filtering on here is the 'date' field: does the First Fiscal Month represent the Calendar of the Parent Subsidiary? Do you mean is the July First Fiscal Month taken from the parent subsidiary record? That screenshot was from the company…

Hi @Clarisa De Torres-Oracle I don't see any option for conversion: This is the field I am using:

Hi @Patrick Fresnosa-Oracle I have updated the setting, logged out of the account, cleared cache though am still getting the following: This setting has never changed: