Is it possible to schedule the closing of a period...
# accountingp
Pavan Parikh
12/16/2019, 6:35 PMIs it possible to schedule the closing of a period on a monthly basis using a script or a workflow ? The issue we're encountering is website orders directly get created in NetSuite so we have to wait to close the periods exactly at Midnight on the end of the month. Will it be possible to do this on a schedule ?
s
suitedev
12/16/2019, 7:06 PMDo you have OneWorld, or intercompany transactions?
p
Pavan Parikh
12/16/2019, 7:07 PMYes OneWorld
s
suitedev
12/16/2019, 7:10 PMI haven't done this with a script before, but the fields appear to be scriptable..
https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_2/script/record/accountingperiod.html
suitedev
12/16/2019, 7:12 PMI would be concerned about auto-closing periods if there are any other transactions which require people-interaction prior to close.. things like creating elimination entries, which is a process I've only ever initiated via the UI.
suitedev
12/16/2019, 7:12 PMWhat bad thing is happening when you don't close the period at midnight?
suitedev
12/16/2019, 7:13 PMI would create a scheduled process in sandbox and test a script to close periods and see if you get the desired result.
p
Pavan Parikh
12/16/2019, 7:14 PMwell the problem is someone has to stay up & close the periods, works when it is still a working day the problem really is when the last day falls on weekends.
Pavan Parikh
12/16/2019, 7:14 PMThanks a lot shayes i'll give it a shot on SB
s
suitedev
12/16/2019, 7:20 PMIf the transactions entered after the close period are not hard-set to a prior date, what is the harm in the period remaining open until the next day?
suitedev
12/16/2019, 7:20 PM(are people entering prior period transactions after the period is closed?)
p
Pavan Parikh
12/16/2019, 7:22 PMThe problem is transactions get synced over to RevPro on a set Schedule & people tend to enter transactions after the closing date if the period has not been closed.
Pavan Parikh
12/16/2019, 7:27 PMWell on the records browser it says nlapiSubmitField & "False" for all of them, wouldn't this be something that stops the execution
s
suitedev
12/16/2019, 8:20 PMSince 'submitField' isn't an option, You would want to test by loading the Accounting Period, changing the field values, and then saving the record.
👍 1
4 Views