Hi guys I have the need to develop a purchasing application that scans the last months sales, compares estimated shipping times and onhand quantities to generate purchacing recommendations (actually a good deal more complicated than this, but thats the gist). The resulting file is presented to the user who examines it over a few days and takes action on it. Then, it gets deleted. There is an undetermined number of files to be created (depending on how many people are doing purchasing at that time) all with the same structure.
This means that I'll have to create a few temporary tables to hold the data and then delete them after the work is finished. I have a similiar need for aging Accounts Receivable. What is the recommended way of creating temporary tables and then deleting them when they are no longer needed? I know how to do this in SQL, just not in Ofbiz. Skip
