In my ongoing Sales Order import project, I now have orders being imported successfully from my client's web site, now I'm on to the next step, which is to automate processing the orders and emailing them out.
I'm sure the process should be simple, and I had some sample code, but it turned out to be for a previous version of JIWA, and doesn't work in 6.5.13.
I've found the examples for processing a single order, and automating bulk processing of back orders, but in my case, I have normal invoice orders which need processing, after which I'd like to email them out.
This will be scheduled to run every hour (a few minutes after the import).
The users currently go to the S/O Processing screen, click 'Go', then click 'Process', with barely a glance at what's there, followed by much the same thing for the email - go the the batch email screen, specify the first invoice (the latest is already there) click 'Go' and 'Process'.
where do I start?
I know I could probably roll one from scratch using a stored procedure to geta list of orders to process and then looping through each one and processing them using the technique described in http://www.jiwa.com.au/forums/viewtopic.php?f=14&t=50, but I'm kinda hoping there's a more efficient way?