Finance | Project Operations, Human Resources, ...

Why LedgerJournalTrans table doesnt have AccountNum field ?

(0) Share

Report

Posted on by ShaqAX

709

Hi friends,

I'm just learning D365 F&O, may I know in table LedgerJournalTrans does it have field AccountNum ? Since I cannot see it in AOT on its Fields list.

I want to add some display field in General Journal - Journal Lines, but this display should look into what we input inside Account field ->

Please help me to understand.

Thanks

I have the same question (0)

All responses (4)

Answers (0)

Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

Right-click the field (as you did in your second screenshot), highlight Form information and click Form name: Ledger journal trans daily. This will open Form information form, where you can get more details about the form and the form control. Go to Administration fast tab and find Data field. There you'll find the actual field name - it's LedgerDimension.

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (1)

Report

Hi,

Because account num and ofsett account num fields are Recid. They are managed with subtables which help the mixture of merge. It is like inventdim.

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report
Noted with thanks.

And how to use this LedgerDimension field ? Means, I want to create a CoC for additional field that I add in table BankAccountTable. So the logic is : there is a custom field (lets say fieldX) in that table. Now I created this Display method like this :

[ExtensionOf(tableStr(LedgerJournalTrans))] final class LedgerJournalTransTable_Extension { ///
/// Display method for Bank type from bank account table ///
/// /// [SysClientCacheDataMethodAttribute(true)] public display Name bankType(LedgerJournalTrans _this) { if (_this.AccountType == LedgerJournalACType::Bank) return BankAccountTable::find(_this.LedgerDimension).fieldX; return "" ; } }

There is an error while build like this :

Thanks,

Was this reply helpful? Yes No
Suggested answer

ShaqAX 709 on at

Like (0)

Report

Ok, solved it. It should be like this :

BankAccountTable::find(LedgerDynamicAccountHelper::getAccountNumberFromDynamicAccount(_this.LedgerDimension)).fieldX;

Thanks

Was this reply helpful? Yes No