PaulFleetwood Silver Medal

Thanks @Leonard Mallare-Oracle - the users changed their mind about what they wanted on the suitelet, so I don't have those searches running now. (users!!). Thanks for the info above - what you are suggesting could be the cause - however I'm still unsure why the two fields behave differently. TRANID is listed int he…

OK thanks - I've found two accounts like that - luckily I don't need these in my dashboard so it is just the one account we will need to enter manually each month...

@Jack Daryl Espiel-Oracle - I have looked at the Mass Update options you suggested (which are useful - I wasn't aware of those) - but in this case the Workflow is in the correct Workflow State (Approved) - it is just the Transaction that is showing incorrect. I'm not sure that the Mass Update would help in this case…

@Patrick Fresnosa-Oracle Thanks for your detailed explanations. Yes, it appears this account was originally the 'Retained Earnings' account. Is this the only account that behaves in this way? Or are there others that I need to look out for? Is there a visible setting on the account that identifies it as an account that…

@Mikko De La Fuente-Oracle I haven't had time to investigate this further, but I will look at what you suggest and see if it is feasible....

@Mikko De La Fuente-Oracle - I have added my vote to that enhancement, but as it has been open for 10 years (!) I do not expect any improvements to this functionality. As with many other elements of NetSuite, I will need to write my own functionality to replace NetSuite's poor implementation of functions....

@Mikko De La Fuente-Oracle - sorry - is there a similar context for the user? I've tried "user", "userid", "employee" This would probably be used more on a homepage dashboard rather than Customer Dashboard, but I would hope the functionality is there......

Thanks @Mikko De La Fuente-Oracle - I'm sure that is documented somewhere but I couldn't find it from multiple searches for this issue. That is working perfectly - thanks again!!

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.