Dynamics Community Forum Thread Details

Analytical Accounting Unposted

Hello John,

The Unposted Journal Entry information for Analytical Accounting are held within the AAG1000x tables. Listed as follows:

AAG10000 - AA Work Header

AAG10001 - AA Work Distributions

AAG10002 - AA Work Assignments

AAG10003 - AA Work Codes

They are all connected using the aaGLWordHdrID, which is connected to the Journal Entry (JRNENTRY) number in the AAG10000 table.

If you have the All AA GL script from us from a previous support case, you can utilize that to pull all of the GL and AA results for the Journal Entry to see the Codes on it in SQL.

Otherwise, you can use something like the following script to pull just GL and AA Unposted Information using the Journal Entry in question. You will want to put the Journal Entry where noted in the script and then run the results to Text by going to Query | Results To | Results to Text, and then Execute the script.

/**********************************************************/

Declare @JRNENTRY int

Set @JRNENTRY = 12345 --Replace with Journal Entry Number in question

Print 'GL Work Header - GL10000'

Print '=============================='

Select * from GL10000 where JRNENTRY = @JRNENTRY

Print 'GL Work Distributions - GL10001'

Print '=============================='

Select * from GL10001 where JRNENTRY = @JRNENTRY

Print 'AA Work Header - AAG10000'

Print '=============================='

Select * from AAG10000 where JRNENTRY = @JRNENTRY