AX2012 Ledger Transaction 数据存储_ax2012 get financial dimension value from ledgertr-CSDN博客

本文链接：https://blog.csdn.net/umfish/article/details/9118023

本文介绍AX2012中总账交易数据从单一表格LedgerTrans拆分为多个表格的过程，并提供了针对特定交易日期或特定凭证和交易日期的数据查询SQL示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

AX2012Ledger Transaction 的数据由原来的LedgerTrans一张表,分为GenerJournalAccountEntry, GeneralJournalEntry, SubledgeVoucherGeneralJournalEntry,

LedgerEntry(可选), LedgerEntryJournal(可选),和LedgerEntryJournalizing(可选)六张表. 另外TaxRefId字段被表TaxTransGeneralJournalAccountEntry link表替代.

取某一特定交易日期数据:

取某一特定凭证和交易日期数据:

select RecId from generalJournalAccountEntry
join RecId from generalJournalEntry
where generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry
join RecId from subledgerVoucherGeneralJournalEntry
where subledgerVoucherGeneralJournalEntry.GeneralJournalEntry == generalJournalEntry.RecId
&& subledgerVoucherGeneralJournalEntry.Voucher == <voucher input>
&& subledgerVoucherGeneralJournalEntry.VoucherDataAreaId == <voucher data area ID input>
&& subledgerVoucherGeneralJournalEntry.AccountingDate == <transaction date input>

报表制作要比之前麻烦多了,但是数据短小,可提高报表运行速度.