I need to get a daily scheduled report of aged creditors (what we owe our suppliers and how overdue the payment is) to run in Sage 50 Accounts Professional 2011.
It doesn't matter how it runs as long as I can have it automatically scheduled and it can output to a file or email.
We have SDO running on Sage so for example the following will output results in a browser:
Presumably the correctly crafted query could pull up the supplier information we need.
Am ok with: scripts/VB.Net/Java (or C++ if nothing else)
Maybe task scheduler to run a script or executable?
Don't want to shell out for Sage SDK etc as it costs a bomb
Theoretically we should be able to set up an ODBC to the Sage data (haven't been able to have the ODBC driver show in the ODBC data sources yet)
All ideas gratefully received.