PaulFleetwood

@Niks Blando-Oracle - When logging the case I was directed to some support articles, and I've found this: Resolve Unexpected Error When Saving an Item Receipt Without Marking Restock Checkbox (custhelp.com) We don't appear to have any account set in the 'Write Off Account for Returns' field? Is this a new field? What…

in Issue with Mark/Unmark All on Item Receipt from Return Authorisation Comment by PaulFleetwood May 5, 2023 12:11PM

Yes it still happens after a cache clear, and on a newly created Return Auth. I'll raise a support ticket.

in Issue with Mark/Unmark All on Item Receipt from Return Authorisation Comment by PaulFleetwood May 5, 2023 12:01PM

@Melanie Schaefer - with a U6 priority I would anticipate this will never get fixed. It is more likely that the 'problem' will be fixed 'by accident' when they make further changes to the page/UI behaviour. As you are clearly getting reports from your users on UI behaviour change, have you had any comments about the top…

in Why Drag and Drop Dropzone not loading? Comment by PaulFleetwood May 5, 2023 6:07AM

Had a couple more users report this, so I logged this and got a very quick response: Support Case #: 5168497. We have filed the following defect on your behalf: Defect 715993: NetSuite Performance > Drag and Drop Zone > Intermittent > Takes more than 1000ms to load Alternate Solution: Use manual file upload button on…

in Why Drag and Drop Dropzone not loading? Comment by PaulFleetwood Apr 28, 2023 9:53AM

Not yet - I don't have any clear idea on how often this is happening..... Have you opened a ticket? Has a defect been issued?

in Why Drag and Drop Dropzone not loading? Comment by PaulFleetwood Apr 28, 2023 5:55AM

I've had this reported by some of our users since moving to 2023.1

in Why Drag and Drop Dropzone not loading? Comment by PaulFleetwood Apr 27, 2023 9:24AM

@Patrick Fresnosa-Oracle - thanks for the further details. Identifying that 'Gross' is before discount and 'Net' is after discount at least shows some logic to the design of the fields (we do not use discounts at the moment, so it is unlikely I would have seen this difference). There still doesn't appear to be any…

in How to add Amount Fields with Tax on Transaction Searches? Comment by PaulFleetwood Apr 18, 2023 5:36AM

Amount (Transaction Total) is the Total Amount for the Transaction, not the line: You'll see that this order has 3 items, and the Transaction Total value is the total of all 3 lines (with tax added). I am fairly sure that by most definitions of the terms 'Gross' and 'Net' those two figures should be different. One should…

in How to add Amount Fields with Tax on Transaction Searches? Comment by PaulFleetwood Apr 17, 2023 6:17AM

Thanks @Patrick Fresnosa-Oracle - that is helpful if you are running 'Main Line = True' searches, but I typically need to run my Transaction Searches with 'Main Line = False' to see details of each individual line......

in How to add Amount Fields with Tax on Transaction Searches? Comment by PaulFleetwood Apr 14, 2023 5:42AM

@GauravAgrawal thankyou! I was not aware of those sublist fields - I found this: Which gives me the detail I need. Thanks again

in How to create Saved Search for Expense Reports containing Quantity / Rate? Comment by PaulFleetwood Apr 13, 2023 12:27PM

@Dominica Sevilla-Oracle - thanks for confirming this limitation (and I will vote for the enhancement). This is useful as it confirms my decision that Demand Planning is not suitable for our business and I will continue to develop custom solutions to meet our needs.

in Demand Planning - Multiple Lines for Same Item Comment by PaulFleetwood Apr 13, 2023 9:13AM

@Michelle Jabanes-Oracle I accept your 'workaround' as the only option we have to resolve this, but I still find it incredibly frustrating that default NetSuite email templates contain standard subject lines that will always cause issues with the standard NetSuite spam engine.

in How to customize the Expense Approval Email Notification - Subject Line / Template? Comment by PaulFleetwood Apr 11, 2023 6:09AM

Hi Theo, That has worked perfectly and will definitely be what we need following our sandbox refresh. Thank you.

in How to configure Suitecommerce Advanced after Sandbox refresh? Comment by PaulFleetwood Apr 6, 2023 1:45PM

I've found that NetSuite setup a Workflow to do this - which I have now changed to only trigger when the Termination Date is on or before YESTERDAY (it was set to TODAY). Another example of NetSuite's excellent 'Best Practices' that we are all meant to follow.......

in Termination Date? Comment by PaulFleetwood Apr 5, 2023 7:00AM

@User_E15G4 - we did build a custom solution for this. I can't recall all the exact details here, but I think it was built from the Quote. A tickbox set on the quote enables the quote to be print with a different template titled as a 'Call Off Purchase Order' that we send to the supplier. This has a unique reference (based…

in Blanket Purchase Order - link to Sales Orders Comment by PaulFleetwood Apr 4, 2023 7:49AM

then @Kristoffer Viray-Oracle

in How to Delete a Custom Field That Shows No Dependent Record Comment by PaulFleetwood Mar 29, 2023 6:45AM

@Kristoffer Viray-Oracle - it is still erroring when I attempt to delete (but shows no dependent records)

in How to Delete a Custom Field That Shows No Dependent Record Comment by PaulFleetwood Mar 29, 2023 6:01AM

OK I will check tomorrow.

in How to Delete a Custom Field That Shows No Dependent Record Comment by PaulFleetwood Mar 28, 2023 2:04PM

Just tried in a different browser in incognito window - no change - still get same error

in How to Delete a Custom Field That Shows No Dependent Record Comment by PaulFleetwood Mar 28, 2023 10:38AM

@Michelle Jabanes-Oracle - thanks for your help with this - there was a User Event script running that is causing the fields to be locked.

in What are the Permissions for Sales Team sublist on Customer Records? Comment by PaulFleetwood Mar 27, 2023 6:18AM

Thanks @Ivy Lopez-Oracle the NS_CONCAT(DISTINCT({internalid})) option appears to work well

in How to remove duplicates when using NS_CONCAT on Events Saved Search? Comment by PaulFleetwood Mar 23, 2023 3:34PM

Thanks @Michelle Jabanes-Oracle No, it appears to be the standard sub-list:

in What are the Permissions for Sales Team sublist on Customer Records? Comment by PaulFleetwood Mar 14, 2023 10:26AM

@Kristoffer Viray-Oracle I don't believe it did, but I have now undeployed that solution so I can't test again. My new plan is based on this: Script To Update Multi-Select Field on Save (custhelp.com) From this I hope to be able to take the list of Companies shown in the sublist on the Contact record and update a new…

in How to Filter Contact Dropdown List by Companies Sublist Comment by PaulFleetwood Mar 10, 2023 8:33AM

I did try experimenting with that setting, but I wasn't able to get it to change the behaviour. Can you confirm if changes to that setting take effect immediately, or if they require a log out or hard refresh etc?

in How to Filter Contact Dropdown List by Companies Sublist Comment by PaulFleetwood Mar 7, 2023 9:58AM

Thanks @Patrick Fresnosa-Oracle - I've used workflow to remove the 'required' star from the net amount field and moved the gross amount field and renamed it to make it more obvious for the users. I've had to create multiple rate options for expenses claimed by rate (as the rate x quantity calculation seems to complete the…

in How to add a tax inclusive amount in an Expense Report in UK? Comment by PaulFleetwood Mar 6, 2023 12:21PM

@Kristoffer Viray-Oracle When creating a custom field of type 'Select' using the scripted options shown in the articles, the user is not able to 'type' in the field to search for options within the drop down. Is there anyway to include that 'type ahead' search functionality in a field that is added from Script? I've…

in How to Filter Contact Dropdown List by Companies Sublist Comment by PaulFleetwood Mar 3, 2023 11:44AM

@Micah Timbol-Oracle The account in question is not inactive and is not a summary account. I've checked the 'standard expense report' form and the Expense Account is shown at line level on there also. I have tried changing the Subsidiary settings on the account from: To: (which is something we've had to do in other places…

in How does setting up the Expense Category work? Comment by PaulFleetwood Feb 28, 2023 7:31AM

Thanks @Kristoffer Viray-Oracle - it's a bit of a complex 'workaround' but it does work and has resolved our problem.

in How to Filter Contact Dropdown List by Companies Sublist Comment by PaulFleetwood Feb 27, 2023 4:23PM

Don't worry - I've found a solution - I always forget that the formula fields on Workflows are not 'normal' formulas but need SuiteScript (1). This got me the User Name: nlapiGetContext().getName() And because I actually wanted the User Initials, after some experimentation I got this working:…

in How to Source Name of the Current User Comment by PaulFleetwood Feb 16, 2023 8:48AM

@NetSuiteSarge - I'm also struggling to understand this (and on the verge of dropping the Supply Planning project completely). Not sure about overdue POs, but I found I had to set 'Late Period Days' on the Items for it to correctly take into account Sales Orders that are overdue (compared to their ship date). Might be…

in Is there a cheat sheet on the Planning Times parameters and their function in MRP? Comment by PaulFleetwood Feb 16, 2023 7:00AM

PaulFleetwood Silver Medal

Comments