Community
Showing results for 
Search instead for 
Do you mean 
Reply

Getting Last Sync Dates from ACT!

New Member
Posts: 1
Country: United_Kingdom

Getting Last Sync Dates from ACT!

Hello all,

On Friday I was tasked with putting together a script to email the last dates that our team had synced with Sage ACT! - Admittidly I had put this off until first thing today, mainly due to the issues with PHP not being setup to connect to a MSSQL Database

 

Have a look at the following link which provides the SQL needed to generate this report: http://www.mattclements.co.uk/sage-act-last-sync-dates/

Employee
Posts: 1,163
Country: USA

Re: Getting Last Sync Dates from ACT!

Excelent Matt, thanks for sharing.

Matthew Wood
Act! SDK Support
Community Moderator
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Getting Last Sync Dates from ACT!

Just in case it's useful ... there is also a Sync Status by User template in the Administrative Dashboard

If the people who needed the report are ACT! users, they could get it there :-)
Copper Super Contributor
Posts: 122
Country: United Kingdom

Re: Getting Last Sync Dates from ACT!

Is there an updated version of this to work with Act v16 ? Before I try to sort this myself! Smiley Happy #notreinventingthewheel Thanks in advance Andy
Andy Kent
Angel Solutions (UK and NZ)
www.angelsolutions.co.uk