How to get Mark Check (Settlement) in VendTransOpen.editMarkTrans() using SQL Server.

jemt22 · May 17, 2016, 4:30am

Hi guys,

I’am create query to get the settlement the mark check only in AX.

here’s the screen shots.

and also i already create the query(but not yet done).

select b.VOUCHER, b.TXT, b.BANKCHEQUENUM,  * from LEDGERJOURNALTABLE a
inner join LEDGERJOURNALTRANS b on a.JOURNALNUM = b.JOURNALNUM
inner join VENDTRANS c on b.VENDTRANSID = c.RECID
inner join VENDTRANSOPEN d on c.ACCOUNTNUM = d.ACCOUNTNUM and c.RECID = d.REFRECID

can anyone help me on this?

how can i query only the mark check(settlement)

Thank you in advance