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

Finance and Operations/AX Developer Forum
1

Hi guys,

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

here’s the screen shots.

123213.jpg
123213.jpg1195×715 220 KB

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 :slight_smile:

2

Hi John,

Its an edit method, you can see the check box MarkTrans checked at backend and you can add condition for it.

3

where do i find?

4

Whenever you mark the invoice against paymentjournal(LedgerjournalTrans), One new record will be created in spectrans table.

LedgerJournalTrans ledgerjournaltrans = LedgerJournalTrans::findLedgerJournalId(‘Voucher’);
SpecTrans spectrans;
VendTransOpen vendtransopen;
VendTrans vendtrans;

while select spectrans
join vendtransopen
join vendtrans
where spectrans.SpecCompany == ledgerjournaltrans.DataAreaId &&
spectrans.SpecTableId == ledgerjournaltrans.TableId &&
spectrans.SpecRecId == ledgerjournaltrans.RecId &&
spectrans.RefCompany == vendtransopen.DataAreaId &&
spectrans.RefTableId == vendtransopen.TableId &&
spectrans.RefRecId == vendtransopen.RecId &&
vendtransopen.RefRecId == vendtrans.RecId &&
vendtransopen.AccountNum == vendtrans.AccountNum
{
info(strFmt(’%1’, vendtrans.Invoice));
}

Invoice is marked If you are able to find the record in spectrans table.