how to build relation between ledgerjournaltrans table and vendbankaccount table

(2) Share

Report

Posted on by charan12

308

Hi All,

I need to export the vendor payment journal selected lines to excel through code, for that I need some fields to export to excel from 'vendbankaccount' table to fetch into excel.I need to export some fields 'Vend bank name' and 'vend bank account num'. I did not find any direct relation between these 2 tables.

Thanks in Advance.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

udaY-ch 5,133 on at

Like (1)

Report
Hi

You can connect LedgerJournalTrans->VendTable->VendBankAccountTable

VendAccount vendAccount = LedgerJournalTrans.AccountType == LedgerJournalACType::Vend ? LedgerJournalTrans.parmAccount() : LedgerJournalTrans.parmOffsetAccount(); vendTable = VendTable::find(vendAccount); VendbankAccount = VendBankAcocunt::find(VendTable.AccountNum, VendTable.BankAccount);

Hope it helps you.

Thanks

Uday

If you found this answer helpful, kindly mark it as verified so it can assist others facing similar issues.

Was this reply helpful? Yes No
Verified answer

Mohamed Amine Mahmoudi 26,431 Super User 2025 Season 2 on at

Like (1)

Report
Hi @charan12,

You an use this relation :

LedgerJournalTrans.CustVendBankAccountId == VendBankAccount.AccountId

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
charan12 308 on at

Like (0)

Report

Thanks Uday-ch and mohamed Amine, thanks for you time. Uday-ch, yeah it working fine.

Was this reply helpful? Yes No

Join the conversation

Community site session details

how to build relation between ledgerjournaltrans table and vendbankaccount table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

how to build relation between ledgerjournaltrans table and vendbankaccount table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates