Report Issue

In AX4.0 the code is below for Asset Balance report:

Display Amount AB_FAA_Others()
LedgerJournalTable AB_LedgerJournalTable;
LedgerJournalTrans AB_LedgerJournalTrans;
select AB_LedgerJournalTrans exists join AB_LedgerJournalTable where AB_LedgerJournalTrans.AssetId == AssetBookMerge.AssetId
AB_LedgerJournalTrans.JournalNum == AB_LedgerJournalTable.JournalNum
&& AB_LedgerJournalTrans.AssetTransType == AssetTransTypeJournal::Acquisition
&& AB_LedgerJournalTable.JournalName == “FAA_Others”;


How to write in Ax-2009… as LedgerJournalTrans does not have fields AssetId && AssetTransType

You have one more table LedgerJournalTrans_Asset.

The LedgerJournalTrans_Asset table contains the transaction detail information pertaining to either the fixed asset or offset fixed asset on a single LedgerJournalTrans table record.