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 which I am posting to keep it easily accessible should I need it again.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
#Dyn365GP2021.01.18Implementing Post Master Enterprise: Series Index- #Dyn365GP2021.01.15SQL View for to Extract Accruals from Microsoft Dynamics GP Payables Management Module
- #Dyn365GP2021.01.14Identify and Fix Corrupt SOP Transactions in Microsoft Dynamics GP
- #Dyn365GP2021.01.13SQL View on Sales Order Processing Backorder Transactions
