Hi all! We have a script that prevents JE to be up...
# csvimports
n
Hi all! We have a script that prevents JE to be uploaded without department value on any of the lines if a certain account is selected. But there are instances where we have some exceptions for certain allocation corrections where a JE is imported without department and class. I was thinking there would be an easy way for avoiding execution of scripts and workflows for JE imports but does not look like that NetSuite give that option. So we end up having to temporarily disable the script deployment for JE records, import & approve the JEs; then redeploy the script deployment. Is there a way to skip running of scripts & workflows for JE import (this is a different navigation path compared to the regular csv import for all other records)
e
avoiding execution of scripts and workflows for JE imports
You can exclude the CSV import context in Workflows and scripts.
thankyou 1
n
@Edgar Valdes That's a good idea- but the thing is there is only one user's one monthly csv import where we want to avoid running scripts in that specific csv import..So avoiding the csv context would be like for all csv imports, right? I was thinking more on lines why netsuite does not give this kind of option for JE import like it does for regular csv imports for other records..
e
What option are you referring to?
You can also deploy a script to specific roles or users, same with the Workflow condition. There are some options in NetSuite i f you don't want to run a script/wf for a specific use case.
n
For the regular csv import (Setup > Import/Export > Import CSV Records), you can uncheck this checkbox of "RUN SERVER SUITESCRIPT AND TRIGGER WORKFLOWS" that you get in the 2nd step under Advanced Options..you do not get this checkbox or any of the advanced options for that matter when you do JE import (Transactions > Financial > Make Journal Entry > Import)
But good idea on making the script role-specific
j
@neerajrtiwari You do have that server suitescript and workflows option for JEs, you just need to use the standard NetSuite import wizard functionality. Do not use the import option/path at Transactions > Financial > Make Journal Entry > Import. Instead go to Setup > Import/Export > Import CSV Records, then select Import Type of "Transactions" and Record Type of "Journal Entry". Load up your file and import journals just like any other transaction type, all the same import options are available to you.
thankyou 1