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......

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

@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.

@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.

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

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.......

@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…

then @Kristoffer Viray-Oracle

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

OK I will check tomorrow.

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

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

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

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

@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…

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?

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…

@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…

@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…

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

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:…

@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…

@Varonis inc. Hannah - I don't recall having specific issues with Tax Codes, but I know I did have some problems with other mandatory fields. You should be able to use a Workflow to set any default fields etc - seems like I used the 'User Event Script' context to get this working here so you might want to experiment with…

Thanks @Leonard Mallare-Oracle I can't view the closed enhancement to see what it said, but 134322 does not seem to have any relevance to SuiteCommerce Advanced. I will put my notes on it, but probably raise a specific request for my issue also

@Kristoffer Viray-Oracle Thanks for this - I will look at the enhancement for specific days per week (as this would be useful for part time employees with varying shifts). However, for this 'night shift' work calendar, the users start at 22:00 Sunday-Thursday and finish at 07:00 the following day. It is not possible to…

@Leonard Mallare-Oracle - based on Option 2 in the SuiteAnswers article - we already have the 'Credit' Gateway Request Type enabled, so it should have worked. However, I think these notes are based on a 'normal' integrated payment card solution (that can be used within the NetSuite UI) - ours is an externally hosted…

@Niks Blando-Oracle Thanks - no further help needed - we clearly need to use serialised or lot numbered items for these bespoke item orders - I will have to plan a project to move over to these. Unfortunately this is one of the many legacy issues left over from the severe lack planning and process understanding from our…

@Niks Blando-Oracle Please see attached XL file I've run this from the start of our NetSuite, so it starts without any issues from older transactions. The first 4 lines are correct, items in and then items out. On lines 5 and 6 we have two receipts (for different values). Lines 7 and 9 have items going out for what I…

Hello @Leonard Mallare-Oracle , We have now downgraded to the recommended version of node.js for our SCA version, it is now creating the DeployDistribution folder as expected. Thankyou for your help.

I've just checked one, and it's not the Average Cost for the location - and I've gone back 5 months and I can't find any receipt for the item at the value of the GL Impact on the Item Fulfilment....