I think that's an intentional decision on NetSuite's part.

Someone keeps posting an article about how Scheduled Scripts don't work in sandbox - which I'm not 100% sure I believe unless they have changed it in 2019.2 because I've tested with scheduled scripts that I deployed in sandbox as recently as 2019.1. (maybe existing scheduled script deployments don't work unless they are manually rescheduled after a sandbox refresh?)

I'm guessing the same policy applies to Release preview.

Side note - if that article is true with sandbox, I'm gonna pitch a fit with NetSuite because there's no way to properly volume test in sandbox without it being able to do a full execution...

@KevinJ of Kansas, that was my initial assumption but quickly realize after manual duplication, the aforementioned results persist. Thanks for the response though.

if a bank account is already inactivated, there shouldn't be any revaluation journals created when reval is done right?

@DX maybe? I'd run reval before inactivation otherwise it might error out

hmm so do I need to uncheck the revalue open balance option?

because some of my inactivated accounts are still revaluing

Hi guys, i have country restrictions on products so i need to force a hard stop if you were trying to ship to an area that i cant deliver to. Is there any way to determine the country the user is reside in? Maybe based on ip? Is there a 3rd party module/integration maybe? Best Maik

Hi Guys i have created a custom field on the Bin number record (Sequence) which i want to print the picking tickets based on.But when i customise the Picking ticket i cannot see the field to sort the lines.

Anyidea

My question is more general than SDF. I'm starting to find shortcoming with SDF, like forms... I want to know if SDF is really used by other companies. Any help / comments appreciated

Looking for a way to implement a type of Bill Credit Approval system as Approval Status is not native to that record. NetSuite currently has an Enhancement Request but nothing available now (Enhancement 230394 ). Has anyone been able to implement a custom approval system?

Hi, I wonder if there is a way to identify if a transaction has been created manually by a user or is system generated? We've got a question from our auditor who wants us to pin-point transactions created manually manually by the accounting team. Cheers 🙂

Need a little help with a saved search formula. I want to convert today's date to the first of the month. So for example - if today is 10/2/2019, the formula should convert it to 10/1/2019. Similarly if today's date were 10/15/2019, the formula should still convert it to 10/1/2019.

If anyone has a formula handy or a sense of how best to do this - would appreciate it. Thanks!

ADD_MONTHS((LAST_DAY(SYSDATE)+1),-1)

you might have to use

ADD_MONTHS((LAST_DAY({today})+1),-1)

{today} should be fine - thanks @KevinJ of Kansas

For bonus points - I then want to use the result to calculate a value for trailing twelve months. So it would be the twelve months prior to the date that's returned.

So in this case, 9/1/2018 to 10/1/2019

basically i'm trying to automate so i don't have to manually update formulas each month

then do a add months -12, get rid of your +1 on last_day.

perfect thanks

I'm sending emails via Bulk Update in sandbox - anyone know where I can change the preference for where the test emails get sent? They go to my manager currently

email settings under setup

there will be a subtab for sandbox/release preview?

ahh. Sandbox Options. got it. Thanks!