Sage Archives - DavidAtkin.com

Sage Antivirus Exclusions – Powershell Script for Windows Defender

By David | June 9, 2018 | Comments 0 Comment

What does this Powershell Script do?

This is a simple Powershell Script to automate the process of adding Exclusions for Sage Accounts into Windows Defender

It will carry out the File and Folder exclusions listed in the following Sage Article:
https://my.sage.co.uk/public/help/askarticle.aspx?articleid=12122

It Will NOT add the URL Exclusions.

The Script has been tested on the following Operating Systems:

Windows 10 32-Bit
Windows 10 64-Bit

The Script:

Download: Sage-Exclusions-Windows-Defender

Remember to run the Script as an Administrator.

Write-Host "Adding Sage Anti-Virus Exclusions" -ForegroundColor Green Write-Host "Excluding Data Files Extensions" -ForegroundColor Yellow Add-MpPreference -ExclusionExtension DTA, DTH, COA, S50 Write-Host "Excluding Report and Layout File Extensions" -ForegroundColor Yellow Add-MpPreference -ExclusionExtension SRT, SLY, SLT, SLB, RPT Write-Host "Excluding Sage Account File Extensions" -ForegroundColor Yellow Add-MpPreference -ExclusionExtension report, layout, letter, label Write-Host "Excluding Memo Files" -ForegroundColor Yellow Add-MpPreference -ExclusionExtension SLM, PLM, NLM, ILM, BLM, CLM, DLM Write-Host "Excluding Critera Files" -ForegroundColor Yellow Add-MpPreference -ExclusionExtension SLC, SLI, PRC, PRO, NMC, NMI, BKC, BKI, SKI, IVC, IVI, SPC, SPI, PCC, PPI, PCI, REC, REI, SAC, SAI, IPC, IPI, PDC, PDI Write-Host "Excluding Folders used by Sage Accounts (32-Bit and 64-Bit)" -ForegroundColor Yellow Add-MpPreference -ExclusionPath "C:\Program Files\Common Files\Sage SBD" Add-MpPreference -ExclusionPath "C:\Program Files (x86)\Common Files\Sage SBD" Add-MpPreference -ExclusionPath "C:\Program Files\Common Files\Sage Line50" Add-MpPreference -ExclusionPath "C:\Program Files (x86)\Common Files\Sage Line50" Add-MpPreference -ExclusionPath "C:\Program Files\Common Files\Sage Report Designer 2007" Add-MpPreference -ExclusionPath "C:\Program Files (x86)\Common Files\Sage Report Designer 2007" Add-MpPreference -ExclusionPath "C:\Program Files\Common Files\Sage Shared" Add-MpPreference -ExclusionPath "C:\Program Files (x86)\Common Files\Sage Shared" Add-MpPreference -ExclusionPath "C:\Program Files\Sage EBanking" Add-MpPreference -ExclusionPath "C:\Program Files (x86)\Sage EBanking" Add-MpPreference -ExclusionPath "C:\Program Files\Sage" Add-MpPreference -ExclusionPath "C:\Program Files (x86)\Sage" Add-MpPreference -ExclusionPath "C:\ProgramData\Sage" Write-Host "Script Complete" -ForegroundColor Green

For large organisations using Sage it is suggested that you configure the exclusions either via your Anti-Virus Management Console or via GPO.

Sage Payroll trying to upgrade previous installation

By David | June 8, 2017 | Comments 0 Comment

Situation:

I came across an error recently whereby I was trying to Install Sage Payroll onto a Windows 7 machine which previously had Payroll on it. The Payroll had been removed some time ago but they now wanted Sage Payroll re-installed on the machine.

When trying to run the Sage50PayrollV22 installer it was trying to do an upgrade of the existing (now removed) Sage Payroll instead of doing a new installation.

Resolution:

There was a Payroll.ini file located in C:\Windows which were being picked up by the Sage installer. During the Installation, the installer was detecting this and was trying to perform an upgrade instead of a new installation.

To Resolve the issue delete the payroll.ini and re-run the installer.

Additional Steps:

Before I got to the above solution I downloaded and installed the Windows Program Removal tool from here and removed all of the previous Sage Payroll Installations:
https://support.microsoft.com/en-gb/help/17588/fix-problems-that-block-programs-from-being-installed-or-removed

This isn’t a required step for the fix but I would suggest doing it if you’re sure that you no longer need the previous installation.

Certified Sage 50 Accounts and Payroll Product Specialist

By David | April 10, 2017 | Comments 0 Comment

Sage

As an IT Engineer, I have a number of Certifications in and around the IT Industry. The company that I work for (Ability IT) have taken the decision to become Sage 50 Accredited Partners, something that I’ve been personally pushing for a while, as a result I have added the following Certifications to my certification list:

Certified Sage 50 Accounts Product Specialist 2017 – Attained 10th March 2017
Certified Sage 50c Accounts Product Specialist – Attained 17th March 2017
Certified Sage 50 Accounts Product Specialist 2018 – Attained 9th October 2017
Certified Sage 50 Payroll Product Specialist 2016 – Attained 24th March 2017
Certified Sage 50 Payroll Product Specialist 2017 – Attained 28th March 2017

Becoming Sage Partners is something that we as a company have wanted for a long time. 90% of our customers use the Sage 50 Product Suite in their businesses so it makes sense for us to be able to support the software to a certain level. Don’t get me wrong, we have been supporting Sage on the behalf of our clients for years but now our customers are able to see our commitment to the Software and it gives them extra comfort to know that we’ve been certified for it.

Personally, I’ve gained more from the course than just being able to install or fix the software. It’s given me a far better understanding of the procedures deployed by companies to manage their accounts and clarity around how business owners want to use the software to analyse there business finances.