I created a new partition in a Dynamics AX 2012 installation and have posted a three invoices. When I go the GL the transactions do not show in the Audit Trail report. I had a look at the report and it the query it runs does a cross join on the CREATEDTRANSACTIONID fields between the TRANSACTIONLOG and GENERALJOURNALENTRY tables. However, when I query those two tables, there are no matching CREATEDTRANSACTIONIDs. Is there some setup item that I’ve missed?

 

Here are the results of a select query on all the records in the TRANSACTIONLOG and GENERALJOURNALENTRY tables:

 

Thanks,

Paul