That's really frustrating, but I'll have to continue with my other option around using scripting to create discount items based on subtotal fields....

Unfortunately I need these changes to happen while the user is adding the items and subtotals to the order. What script actions will trigger when lines are added to an order besides validate line?

So I've been experimenting with code options such as: var index = thisRecord.findSublistLineWithValue({ sublistId: "item", fieldId: "item", value: 16029 }); thisRecord.selectLine({sublistId: "item", line: index}); var subTotal = thisRecord.getCurrentSublistValue({ sublistId: 'item', fieldId: 'amount' }); To try and find…

I know NetSuite can't answer this for me (and I have tried all the partners on SuiteApps, and spoken with various people in NetSuite). But I am hoping there are some UK based NetSuite users on here.... Does anyone in the UK have a working Payment Card Gateway supplier for SCA that is compliant with the new 3DSecure payment…

@Mikko De La Fuente-Oracle Thanks - that didn't actually work, but searching for ns-client-ip gave me a working solution: var ip = context.request.headers['ns-client-ip']; context.response.write(ip); Thanks for pointing me in the right direction.

OK thanks @Mikko De La Fuente-Oracle - I will contact support. I have tried running my search multiple times with smaller results and this seems to work without timing out, so that may be the way round this issue.

@Kristoffer Viray-Oracle - thanks for the suggestion, that has lead to a solution.... I wasn't aware this was a custom field - it wasn't anything created by us - but it turns out it is part of one of the many 'bundles' installed by NetSuite (many of which I have not idea what they are doing). This one is linked to the…

Thanks - I don't think that Enhancement entirely lines up with my issue, but I'll vote and monitor it anyway. But this still doesn't explain why I have been using the trigger 'After Field Edit' with a Triggering Client Field of 'Amount after discount' for many months (possibly over a year) and it has suddenly stopped…

@Kristoffer Viray-Oracle - thanks - yes if I wanted to set a Field Value I can trigger this from a sublist field change. However, (for some unknown, illogical reason) if I want to set a Field Display Type, I don't get the option to trigger this on a sublist field change?

Thanks @Jack Daryl Espiel-Oracle I had to search through the list of custom fields by ID to find the Counterparty VAT field - turns out the actually description is 'Partner ID' - which i have now been able to successfully hide using workflow. The others I will have to look at as part of my scripting review and/or wait for…

Looking at these: custbody_counterparty_vat is part of 'International Tax Reports' bundle 43003 I'm guessing we do need this bundle as it mentions UK VAT reports, but I have no idea what this field is meant to be used for? I have 11 'NetSuite' User Event scripts scripts attached to my Sales Order record, and I don't really…

Thanks @Leonard Mallare-Oracle I have voted for this enhancement. I am very disappointed to find out that these reports do not report on SCA as this was included in my SCA SuiteSuccess implementation from NetSuite PS as providing me with KPIs and Reporting on SCA usage. My developers are looking a SuiteCommerce Analytics,…

custpage_delivery_terms custbody_counterparty_vat custpage_country_of_origin_temp They all appear to be standard fields

Looking back at my template, I used: item.custcol_qty_picked?number To convert fields to numeric so I could run calculations on them. Here's an excerpt of some of my code: <#if (item.custcol_cust_itemsalesuom?has_content)> <#assign salesuom = item.custcol_cust_itemsalesuom> <#else> <#assign salesuom = 1> </#if> <#if…

@George Mihaylov - did you ever find any native NetSuite reporting for SuiteCommerce Advanced? I know Google Analytics is an option, but I specifically want to know which Customers are accessing the site (we require a login for all access), and I assume Customer information will not be available to Google Analytics?

@Katerina Winklerova-Oracle - I'm guessing the search you have shown is an Account search, and you are searching the sublist of System Notes from the Account? I need to produce a Transaction search, so I am already searching the sublist of Account and therefore can't access the Account Sublist of System Notes I've just…

Thanks @ShyamBandari and @Mikko De La Fuente-Oracle - that works well?️

@Ivy Lopez-Oracle - thanks very much - I think that may be exactly what I am looking for! I will need to do extensive testing to understand exactly how this would work, but it could be a major improvement for us.

@Mikko De La Fuente-Oracle This is an older script that I've been adapting, so it is SuiteScript 1 So where I have sections with: function updateRouteDetailsOnSO(type) { if (type == 'edit') { ......... and if (type == 'create') { ......... I could potentially have a new section with: if (type == 'pack') { and this would…

Yes, that has given me some new options to work with - thanks

Thankyou @Patrick Fresnosa-Oracle Yes, it appears the Document Date field had been set as Mandatory on the Purchase Order form (I have no idea why). This doesn't typically give us a problem with creating POs (I'm not sure why), but seems to cause and issue with this particular scenario of updating a Sales Order linked to a…

No, the field is not set to mandatory on the form or in the field definition. Most of our Sales Orders complete fine with this field empty - it just seems that in certain circumstances it becomes required.

@Patrick Fresnosa-Oracle We are UK based, and do not trade in France. We do not need FEC compliance, and (as far as I know) we have not set this up. The article makes no mention of this Document Date field (it implies the calculations are based on Transaction Date). None of this explains why I can create Sales Orders…

@Erick Dela Rosa-Oracle thanks for offering to look at this... It is very large/complex so I totally understand if this is not feasible. Hope this is OK uploaded like this - I tried adding as a code block but the format was unreadable...

@Katerina Winklerova-Oracle The issue is reproducible in Sandbox, and also happens with the Standard Sales Order form. I have worked through the Client Scripts, and found a script (created by a third party I no longer work with), and part of that is causing the issue. The script is used to calculate custom column fields on…

My apologies @Dominica Sevilla-Oracle - it is Tasks that my users are asking to add to the Portlet. Sorry for the confusion ?

Are you using Mac or is it reproducible in Microsoft? Microsoft - we don't use Macs Which browser (+ version) are you using to reproduce this issue? Edge and Chrome (latest versions) Is this reproducible with the other browsers? Haven't tried yet How often is this happening? Consistently on large orders (but the size of…

OK, I will have to look at the custom field approach to re-create the email signature.....

Thanks Yes that SuiteAnswers article is similar to the searches I am running - but I am already finding those significantly too slow (and we only have 3 years data in NetSuite) - I cannot comprehend how these will remain viable in future once we have 5 or 10 years worth of transactions to search..... I guess I will have to…

Hi, thanks for these. As I understand it (and if I am incorrect please let me know): A Balance Sheet report is the value of various accounts at a specific point in time (typically end of last month, or end of last financial year). A Profit and Loss report is the sum total of various transactions within a set period of time…