RE: Suite script to import and run csv file
Hi Expert,In order to create a journal entry we need to populate a csv file with required fields and run in the UI.Can we write a suitte script to read the csv file and run that csv file to generate a journal entry .Could you please help out ?
Yes, this can be automated with Suite Script. That being said, how much value does this really add if the user still needs to manually add the file to the appropriate file cabinet folder vs using a saved CSV import template? Fewer clicks perhaps, but you are talking about 1-2 seconds difference.
If you are planning to automate the files being loaded into the file cabinet for CSV import processing i.e. a no touch process, then I would see value in automating the process via Suite Script.
I hope this helps!