Microsoft Dynamics GP Analytical Accounting Open Transactions SQL Query

I was looking into a problem reported by a client recently and needed to check the assignment of Analytical Accounting Transaction Dimension Codes to the AA GL transactions and so wrote the below SQL which I am posting to keep it easily accessible should I need it again.

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is...

Continue Reading Ian Grieve’s Article on their blog

Microsoft Dynamics GP Analytical Accounting Open Transactions SQL Query

I was looking into a problem reported by a client recently and needed to check the assignment of Analytical Accounting Transaction Dimension Codes to the AA GL transactions and so wrote the below SQL‎…

Blog Syndicated with Ian Grieve’s Permission