Hi folks,
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.
Optional ingredients:
1
We have SDO running on Sage so for example the following will output results in a browser:
http://localhost:5493/sdata/accounts50/SDO/-/customers
Presumably the correctly crafted query could pull up the supplier information we need.
2
Am ok with: scripts/VB.Net/Java (or C++ if nothing else)
3
Maybe task scheduler to run a script or executable?
4
Don't want to shell out for Sage SDK etc as it costs a bomb
5
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.
Cheers
You can backup the whole Sage Account folder data with the MS Windows Scheduler
http://www.addictivetips.com/windows-tips/how-to-backup-and-restore-important-filesfolder-in-windows-7/
https://www.experts-exchange.com/questions/27605996/Sage-Accounts-2011-Automatic-Backup.html