My user is on SAP Business One 2007A. We want to export a file to a .txt file using an automatic process in a query. The actions we wish to occur are:
1. Export query data to file
2. AutoSave query as a file on a particular path, with a standard name plus today's date plus .txt.
Is this possible and does anyone have the SQL to implement this in an SBO query?