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
Print 'AA Work Distributions - AAG10001'
Print '=============================='
Select * from AAG10001 where aaGLWorkHdrID in (Select aaGLWorkHdrID from AAG10000 where JRNENTRY = @JRNENTRY)
Print 'AA Work Assignments - AAG10002'
Print '=============================='
Select * from AAG10002 where aaGLWorkHdrID in (Select aaGLWorkHdrID from AAG10000 where JRNENTRY = @JRNENTRY)
Print 'AA Work Codes - AAG10003'
Print '=============================='
Select * from AAG10003 where aaGLWorkHdrID in (Select aaGLWorkHdrID from AAG10000 where JRNENTRY = @JRNENTRY)
/**********************************************************/
Let me know if that helps!
Regards,
