This post is part of the series on building my new Raspberry Pi; this series is a sub-series of the Adventures with a Raspberry Pi.
With Pi-hole installed and configured, the final step is to change the DNS settings on the router to point to the Pi-hole rather than the old DNS servers. In my case, they were pointing to OpenDNS on the router, so it as a case of changing them to look to the IP address configured on the Pi-hole which is set to use OpenDNS.
Every router is different in how DNS servers are configured; if your router doesn’t allow the DNS servers to be changed, you could change the DNS settings on your computers instead; bear in mind this approach takes far more effort.
While the General Ledger Year-End Close routine can delete unused segments, during implementation, or creation of new companies , we sometimes end up with segments created which are not needed. The below script can be used to remove all segments not assigned to an account (segments which have been used will not be removed).
The script allows the user to define which segment should be removed by changing the highlighted parameter:
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
DECLARE @SGMTNUMB AS VARCHAR(2) = 3
SGMTNUMB = @SGMTNUMB
SGMNTID NOT IN (
WHEN 1 THEN GL100.ACTNUMBR_1
WHEN 2 THEN GL100.ACTNUMBR_2
WHEN 3 THEN GL100.ACTNUMBR_3
WHEN 4 THEN GL100.ACTNUMBR_4
WHEN 5 THEN GL100.ACTNUMBR_5
WHEN 6 THEN GL100.ACTNUMBR_6
WHEN 7 THEN GL100.ACTNUMBR_7
WHEN 8 THEN GL100.ACTNUMBR_8
WHEN 9 THEN GL100.ACTNUMBR_9
WHEN 10 THEN GL100.ACTNUMBR_10
GL00105 AS GL105
GL00100 AS GL100
GL100.ACTINDX = GL105.ACTINDX