Paul Salkeld

I did think this was the only way I can achieve this via a script!

in Discounts on Quotes/Sales Orders Comment by Paul Salkeld Apr 4, 2023 10:21AM

Please see image

in Is there anyway to add Expenses in VAT on Mobile App? Comment by Paul Salkeld Mar 29, 2023 8:39AM

Its on the Expense Report. When employees upload a receipt, they just enter the gross amount in, as in £3.10. But the Accounts department then have to open the receipt image file and fill in the correct VAT (Tax Code) so that the VAT is split from the Gross value. Cant seem to find a way to do this on the app.

in Is there anyway to add Expenses in VAT on Mobile App? Comment by Paul Salkeld Mar 28, 2023 10:22AM

Jack This has been resolved now by NetSuite support. They have advised to use 1 workflow instead of the 2 I had setup and this works now. Thank you for you response though.

in Why is my Workflow that toggles the visibility of a Custom Field based on a Condition not working? Comment by Paul Salkeld Mar 27, 2023 7:55AM

Thank you

in How to create a calendar event via suitescript 2.0? Comment by Paul Salkeld Mar 20, 2023 3:40PM

Nicole I tried setting the time to '10:00:00' and got this error: {"type":"error.SuiteScriptError","name":"INVALID_FLD_VALUE","message":"You have entered an Invalid Field Value 10:00:00 for the following field: starttime" So I tried adding the date in front as in '23/03/2023 10:00:00' and got this error:…

in How to create a calendar event via suitescript 2.0? Comment by Paul Salkeld Mar 20, 2023 2:46PM

Thank you

in Why is the Parent Customer's Billing Account not showing when Subcustomer is selected? Comment by Paul Salkeld Mar 20, 2023 10:04AM

The field by default is set to be shown

in Why is my Workflow that toggles the visibility of a Custom Field based on a Condition not working? Comment by Paul Salkeld Mar 17, 2023 2:25PM

This is my workflow. And states Dosent work

in Why is my Workflow that toggles the visibility of a Custom Field based on a Condition not working? Comment by Paul Salkeld Mar 17, 2023 2:23PM

I did try hh:mm and that did not work either.

in How to create a calendar event via suitescript 2.0? Comment by Paul Salkeld Mar 17, 2023 8:22AM

Hi I'm using Suitescript 2.0 and i did try to see what the value of the time field was so that I could set it accordingly. What i saw was this. So I used this. calendarEvent.setValue({ fieldId: 'starttime', value: "2023-02-28T10:00:00.000Z" }); To try and set the time to 10:00am but it did nothing. Tried all sorts of…

in How to create a calendar event via suitescript 2.0? Comment by Paul Salkeld Mar 3, 2023 10:47AM

It would seem to combine it yes, but the description for ICI5 is not "a". So i've no idea where its getting this from. I have already tried erasing the description, saving it etc but it still shows an "a". Some of the items show the ID and Description, some just show the ID and some have "a" attached. There are no…

in How to Remove Additional Characters in List Field From Custom Record Comment by Paul Salkeld Mar 2, 2023 10:13AM

Thanks Nicole. Also, on creating a calendar event, would you know how to set the start and end times? Have tried all sorts, but it just fails saying its not a valid value.

in How to create a calendar event via suitescript 2.0? Comment by Paul Salkeld Mar 1, 2023 10:43AM

(Spoiler) The field is the item

in How to Remove Additional Characters in List Field From Custom Record Comment by Paul Salkeld Mar 1, 2023 8:47AM

Hi Kristoffer Did you mean this? Screenshot of the sublist is in the post above.

in How to Remove Additional Characters in List Field From Custom Record Comment by Paul Salkeld Mar 1, 2023 8:25AM

I have got round this by creating a field in the main body and looping through the sublist items i want to appear in the PDF and generating a HTML table in that field and then referencing that in the advanced PDF. chklstarray += "<tr><td style='width:350px; padding:10px; border: 1px solid black; text-align:left;'>" +…

in How to add Custom Sublist in Advanced PDF Comment by Paul Salkeld Feb 7, 2023 9:15AM

Its a custom record and a custom sublist too.

in How to add Custom Sublist in Advanced PDF Comment by Paul Salkeld Feb 6, 2023 12:21PM

Jack I do have these options ticked and yes it removes the line in view mode, but a saved search shows that the records are not deleted though. But in edit mode, you are right, it deletes the record, which then begs the question, whats the point of the remove in view mode?

in How to have the corresponding record deleted upon removal of its line in a Child Record Sublist? Comment by Paul Salkeld Feb 1, 2023 9:44AM

Thanks Jack, the workflow idea sounds a plan!

in How to assign an Email Message Template to be used for Bill Payment Emails? Comment by Paul Salkeld Jan 27, 2023 8:21AM

No thanks, I think I have resolved this thank you,

in How can I create a Phone Call Work Flow for Invoices? Comment by Paul Salkeld Oct 24, 2022 7:06AM

Hi Katerina I cannot edit the employee ID field on the employee record and the link to article 31385 just sends me to a new release video.

in User Names Issue Comment by Paul Salkeld Sep 8, 2022 7:38AM

Joahnna Although this worked for Purchase Orders, it is still showing on the Vendor Return Authorization. How can this been turned off?

in Hiding Expense Tab Comment by Paul Salkeld Aug 25, 2022 7:46AM

Hi Mikko I would like further assistance please as I cannot find the right reference to change the colour.

in Changing colour of sales order line if line is closed Comment by Paul Salkeld Aug 23, 2022 7:23AM

I have amended the code thank you, but now I see this error. So as you have suggested above, maybe I need to create a class.

in Changing colour of sales order line if line is closed Comment by Paul Salkeld Aug 17, 2022 7:08AM

Thankyou for your reply. I had tried a slightly different approach, but I still cannot get the row colour to change. Below is my script. /** * @NApiVersion 2.1 * @NScriptType ClientScript */ define(['N/record','N/ui/dialog'], function (record,dialog) { function pageInit(context){ //Set pointer to current record var…

in Changing colour of sales order line if line is closed Comment by Paul Salkeld Aug 16, 2022 8:30AM

Leonard That works thank you. The only thing is it requires the user to click the edit button to trigger it. Is there a way to open a record in edit mode?

in Set Focus To New Window Comment by Paul Salkeld Aug 1, 2022 8:39AM

Joahnna This dis work but only on newly created credit memo's not existing ones. So I tried record.copy.promise instead and that seems to work in all cases. So thank you for all your help on this.

in Copying a Record Comment by Paul Salkeld Aug 1, 2022 7:16AM

I still dont fully understand how to use workflows and scripts.

in Loop through workflow and run script Comment by Paul Salkeld Jul 29, 2022 7:28AM

Yes thats correct. I am using Suitescript 2 and i am in the Sales Order record. When the record is saved i want the customer record to open and display a message. I am using open(url) and it successfully opens the customer record in a new tab, but the message i am using via dialog.alert is being displayed on the sales…

in Set Focus To New Window Comment by Paul Salkeld Jul 29, 2022 7:17AM

Joahnna I have copied your code and I can see the dialog alert pop up with the record number but thats it, nothing else happens. I have tried looking to see if a credit note has been created and it has not.

in Copying a Record Comment by Paul Salkeld Jul 25, 2022 7:19AM

MFA for Oracle Community

Paul Salkeld Red Ribbon

Comments