≡ Menu

TSQL Query for tables where each General ledger entry has effect Dynamics Ax 2012

For Future reference, I used following Queries to check the General Ledger Entry in Dynamics ax 2012. Small tip,

You can used them to delete posted ledger entry

 

select * from LEDGERJOURNALTABLE where JOURNALNUM =’XYZ-015528′

 

select * from LEDGERJOURNALTRANS where JOURNALNUM =’XyZ-015528′

 

select * from LedgerEntryJournal   where JOURNALNUMBER =’XyZ-015528′

select recid,* from GeneralJournalEntry where  LedgerEntryJournal= LedgerEntryJournal.RecID

 

select * from GeneralJournalAccountEntry where GeneralJournalEntry = GeneralJournalEntry.RecID

 

select * from custtrans where   custtrans.VOUCHER      in
–ACCOUNTNUM =’Cust-02032′ and
(
select LedgerJournalTrans.VOUCHER from   LedgerJournalTrans
join  LEDGERJOURNALTABLE
on LedgerJournalTrans.JOURNALNUM = LEDGERJOURNALTABLE.JOURNALNUM
where LEDGERJOURNALTABLE.POSTED = and ( LedgerJournalTrans.ACCOUNTTYPE =1 or LedgerJournalTrans.OFFSETACCOUNTTYPE =1) and LEDGERJOURNALTABLE.JOURNALNUM =’XyZ-015528′

 

{ 0 comments… add one }

Leave a Comment