We went live with NetSuite in February this year.
Once of the tasks I do each day is to update the stock inventory files on our ftp sites.
I run reports in NetSuite, export them out to csv files save them as an Excel macro files and then use VBA code to put the data in the format I need it in.
I then use FileZilla to upload files to ftp sites. Below is a sample of what’s uploaded.
At the moment the stock files contains the following fields:
Item_Code, Item_Description, Colour_Description, Size_Description, AvailableQty, Barcode, Item_Status but i would like to add more in the new year.
I would like to know if there are better ways of peforming the above process?
One possibility I was thinking of was using a Suitescript script.
Are there an Suitescript scripts out there that users have developed to perform such a task?
Thanks
Michael