最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

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

网络文摘 alirazazaidi 1707浏览 0评论

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

 

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址