Enable Filter on Invoice Journal Form

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi,

I want know how we can enable filter in any form which is already disable filter

for example i just attached a screen shot with this mail given below

pastedimage1493924224915v1.png
pastedimage1493924224915v1.png1364×768 59.9 KB

There is a invoice journal form as you can see in that form there is a field AccountName so i just want to enable filter on that

field same as it has for Journal Number Field.

AX Version 2009.

Thanks in Advance

2

Hi ,
Can you tell us the path…(Like AR->Journalls…)

3

Looks like they are customized fields (usually they will be on lines) and they look like the display methods. So filtering is not possible on display method without a change.

4

Path AP->Journal->InvoiceJournal

5

thanks your quick response.
you mention that not possible without change. what does it means

6

Filter is only possible on the data base fields. But it wont be possible on display methods without doing a customization.

7

Hi,

If It is a display method…Try like this…

http://axaptadevmallik.blogspot.in/2014/10/display-method-filter-in-ax-2012.html

8

Hi,
Is the form customized ??..Tell me from which table the name field comes

9

Thanks for your response. i will try above link

10

this is the display method and coming from LedgerJournalTrans Table see given code

//BP Deviation Documented
display LedgerJournalAccountName accountName()
{
LedgerJournalTrans ledgerJournalTrans;
;
select ledgerJournalTrans
where ledgerJournalTrans.JournalNum == this.JournalNum;

return ledgerJournalTrans.accountName();

11

Thanks a lot it is working fine.

12

HI,
Always Close the thread if you got the answer by clicking ’ this helped me’ in the useful reply…

13

A journal can have multiple lines with multiple accounts. Which one will you show on the header with this display method?

14

HI,
As per ur reply i will consider my reply as answer…