This is part of the azurecurve ClassicPress Plugins
which introduces the plugins I have available for ClassicPress.
The plugin I am going to cover in this post, is an existing one which has been brought up to standard brand new one; Filtered Categories.
The Filtered Categories plugin adds a new widget which can be used in the sidebar, or other widget areas, which can be set to include or exclude certain categories; widget details are configurable and allows a link to be set to a full category list on a page.
The Categories widget in this sites sidebar uses this plugin to present a much shortened list of categories; the full category list can be found here.
The plugin can be downloaded via my Development site.
I was recently putting together a report for a client on Fixed Allocation Accounts and came across some corrupt data in the Fabrikam, Sample Company, Database. To avoid encountering this issue again, next time I am working in this area, I put together a simple script to remove the corrupt records by joining Fixed Allocation Master (GL00103)
with Breakdown Account Master (GL00100)
to identify the data which should not be there and delete it; this makes the script generic enough that I can use it on a live company should the need ever arise.
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (https://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).
['Fixed Allocation Master']
GL00103 AS ['Fixed Allocation Master']
GL00100 ['Account Master']
['Account Master'].ACTINDX = ['Fixed Allocation Master'].ACTINDX
['Account Master'].FXDORVAR = 2
As always, before you run any script, ensure you have a good backup of your database and verify the results after the script has been run.